Monday, January 4, 2016

Change Oracle Apps 12.1.3 database APPS password

Steps:

Source the environment first as shown below:

1. Log into the Operating system level by way of the applmgr user.

2. Run the environment script APPSORA.env:
a. cd $APPL_TOP
b. Run APPSORA.env.
c. The above should also run <sid>_<node>.env, but can verify by running it.
d. cd admin.
e. Run adovars.env

FNDCPASS Utility:

FNDCPASS <APPS username>/<APPS password> 0 Y \ <SYSTEM username>/<SYSTEM password> <token> <username> <new_password>

Example:

1) To change the APPS and APPLSYS schema password:

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME

2) To change an Oracle Applications schema password (other than APPS/APPLSYS):

FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1

3) To change all ORACLE schema passwords:

FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME

4) To change an Oracle Applications user's password:

FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME



No comments:

Post a Comment