Cambiarpwd

Author – A.Kishore/Sachin http://appsdba.info

FNDCPASS
FNDCPASS is an EBS tool to change passwords of database schemas within the Oracle EBS. For example, you can change the APPS password usingFNDCPASS and also any other schema in the EBS database. FNDCPASS can also be used to change the password of an application user (like sysadmin). FNDCPASS uses three modes in changing the password (i)SYSTEM ,It is used to change APPS/APPLSYS password (ii) USER , It is used to change oracle applications user like SYSADMIN (iii) ORACLE , It is used to change the password of oracle schema like GL,AP(iv) ALLORACLE , It is used to change all passwords of all schema.

(A) Use FNDCPASS to change APPS password
Step 1 : Login as applmgr user and set the environment variables $ cd/d01/oracle/prodappl $. ./ APPSORA.env

1

Author – A.Kishore/Sachin http://appsdba.info

Step 2 : Enter FNDCPASS, if you need any help as shown below:

Step 3 : Now we will change APPS password using FNDCPASS,as shown below $ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS KISHORE

2

Author – A.Kishore/Sachin http://appsdba.info

Step 4 : Check the log file using vi,if any errors are there :Log file looks like below screen

Step 5 : Execute autoconfig. $ cd /$COMMON_TOP/admin/scripts/PROD_erp $ adautocfg.sh Enter the APPS user password: Here we will put the new password that isKISHORE

3

Author – A.Kishore/Sachin http://appsdba.info

4

Author – A.Kishore/Sachin http://appsdba.info

Please wait for the autoconfig completion:

Step 6 : Check the log file generatedby autoconfig using vi, for errors (if any)

5

Author – A.Kishore/Sachin http://appsdba.info

6

Author – A.Kishore/Sachin http://appsdba.info

Step 7 : Now login to sqlplus using thenew password as shown below: $ sqlplus apps/kishore

(B) Change Application User (sysadmin) Password Using FNDCPASS
Step 1 : we will use the USER mode to change the application user password like...