FNDCPASS

-
Changing Apps Password
/* CHANGE APPLICATION USER PASSWORD USING FNDCPASS*/
FNDCPASS apps/APPS_PASSWORD 0 Y system/SYSTEM_PASSWORD USER USER_WHOSE_PASSWORD_WILL_BE_CHANGED NEWPASSWORD
Example: FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN sysadmin
/* CHANGE "APPS" USER PASSWORD USING FNDCPASS in "R11"*/
FNDCPASS apps/apps 0 Y system/SYSTEM_PASSWORD SYSTEM APPLSYS NEWPASSWORD
Note: Changing apps password will also change applsys password. apps and applsys passwords are always the same..
/* CHANGE "APPS" USER PASSWORD USING FNDCPASS in "R12"*/

FNDCPASS apps/APPS_PASSWORD 0 Y system/SYSTEM_PASSWORD SYSTEM APPLSYS NEW_PASSWORD

Comments

Post a Comment

Popular posts from this blog

ORACLE APPS DBA R12

-
Finding Application user password in R12: 1. CREATE OR REPLACE PACKAGE get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2; END get_pwd; / 2. CREATE OR REPLACE PACKAGE BODY get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2    AS       LANGUAGE JAVA       NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String'; END get_pwd; / 3 . SELECT usr.user_name,        get_pwd.decrypt           ((SELECT (SELECT get_pwd.decrypt                               (fnd_web_sec.get_guest_username_pwd,                                user...
Read more

Finding Database Growth Mothly

-
Query to check database growth mothly: SQL> select to_char(creation_time, 'MM-RRRR') "Month", sum(bytes)/1024/1024/1024 "Growth in GB" from sys.v_$datafile where to_char(creation_time,'RRRR')='2017' group by to_char(creation_time, 'MM-RRRR') order by  to_char(creation_time, 'MM-RRRR');   2    3    4    5 Month   Growth in GB ------- ------------ 01-2017            1 03-2017     .9765625 07-2017           12 1.Find the database used space from dba_segments select sum(bytes/1024/1024/1024) from dba_segments; find the database used plus free space from dba_data_files select sum(bytes/1024/1024/1024) from dba_datafies;
Read more