Page 1 of 1

how to change Diagnostics -> examine password

Posted: Tue Jun 23, 2009 3:17 am
by Usman Qureshi
please help me on this topic

Posted: Tue Jun 23, 2009 5:46 am
by oteixeira
Hello.
That is the APPS user password. You must take some care while doing it. Have a look on Metalink Note 813653.1


Octavio

Posted: Tue Jun 23, 2009 6:37 am
by siva sankar
Hi,

The below note explanation:(813653.1)

Oracle applications database contains many default, 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.
For detailed information on the list of the schemas by category, instructions and notes for managing schema passwords refer to the ?Appendix C: Database Schemas Shipped with E-Business Suite? section of "Best Practices for Securing Oracle E-Business Suite guide

Thanks & Regards,

Siva