Saturday, October 15, 2011

Discoverer: Unable to connect to Oracle Applications database: invalid username/password

unable to connect to: user@123@sid Failed to connect to database - Unable to connect to Oracle Applications database: invalid username/password.
Solution:
1. use the following command to make the authentication off. java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION OFF DBC=file.dbc or Change the xml file and make the value of AUTHENTICATION secure to off.
2. Create a folder with name secure in Oracle Home, and copy dbc file from server ($FND_SECURE) to desktop.

patch 5980072 can also be applied on client to resolve this issue.

No comments:

Post a Comment