BI Discoverer 11g: Unable To Connect To Oracle Applications Database: Invalid Username/Password 



Error:

unable to connect to: user@sid Failed to connect to database - Unable to connect to Oracle Applications database: invalid username/password

Cause:
Admin Server AUTHENTICATION is SECURE.
 
This is justified by running:

java oracle.apps.fnd.security.AdminAppServer apps/<pwd> STATUS DBC=$FND_SECURE/PROD.dbc

Database Server
---------------
DATABASE_ID: PROD
AUTHENTICATION: SECURE

Application Server
------------------
APPL_SERVER_STATUS: VALID
APPL_SERVER_ID: ERURDF876SHFNJ
 

SOLUTION

1. Source application tier environment file <APPL_TOP>/APPS<SID>_<hostname>.env.

2. Run the following command:

java oracle.apps.fnd.security.AdminAppServer apps/<pwd> AUTHENTICATION OFF DBC=$FND_SECURE/<SID>.dbc

3. Re-try to login

 




If you like please follow and comment