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

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