Wednesday, June 01, 2011

How to change the default passwords in Oracle Applications


After a fresh installation of Oracle Applications, database contains many defaults, open schemas with default passwords.

These accounts and corresponding passwords are well-known, and they should be changed, especially for a database to be used in a production environment as a best practice.

Default schemas come from different sources and can be classified as below:

1. Default database administration schemas
2. Schemas belonging to optional database features neither used nor patched by E-Business Suite
3. Schemas belonging to optional database features used but not patched by E-Business Suite
4. Schemas belonging to optional database features used and patched by E-Business Suite
5. Schemas common to all E-Business Suite products
6. Schemas associated with specific E-Business Suite products

For the schemas in categories 1, 2 and 3, use standard database commands to change a password:
SQL> alter user [SCHEMA] identified by [NEW_PASSWORD];

For the schemas in categories 4, 5 and 6, use the application password change tool:
$ FNDCPASS APPS/apps_pwd 0 Y SYSTEM/system_pwd ORACLE [SCHEMA] [NEW_PWD]

To save time, category six (6) schema passwords may be changed en masse using FNDCPASS.
FNDCPASS accepts a keyword ALLORACLE forcing a change of all managed schemas to the new password. If your version of FNDCPASS does not already support the ALLORACLE keyword, apply patch 5080487.
$ FNDCPASS APPS/apps_pwd 0 Y SYSTEM/system_pwd ALLORACLE [NEW_PWD]

To determine which schemas are managed by E-Business Suite (categories 4, 5 and 6), run the AD adutconf.sql script.


 Regards,
Sukhwinder Singh

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

There was an error in this gadget