Oracle

After Cloning Oracle Applications And Resetting APPS Password, Discoverer 10g/11g Fails With Error: Unable To Connect To Oracle Applications Database (afscpgcs) [ID 788706.1] |
|
  | Modified25-AUG-2011     Type PROBLEM     Status PUBLISHED |   |
In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

-------------------------------------------------
Applies to:Oracle Discoverer - Version: 10.1.2.1 to 11.1.1.4.0 - Release: 10.1.2 to 11g
Oracle Discoverer - Version: 10.1.2.1 to 11.1.1.4.0   [Release: 10.1.2 to 11g]
Information in this document applies toany platform.
-------------------------------------------------
Symptoms
After successfully cloning an Oracle Applications E-Business Suite instance and changing "APPS" user password, connectionsto Discoverer fail with error:

"Error:
A connection error has occurred.
- OracleBI Discoverer was unable to authenticate using the password provided. This can happen due
to an invalid passwordor because the password was lost while using back, forward, or refresh in your browser. Please enter the password again to continue.
- Failed to connect to database - Unable to connect to OracleApplications database (afscpgcs)".

-------------------------------------------------
Changes
New instance which includes Discoverer EUL is a recently cloned Oracle Applications instance.-------------------------------------------------
Cause
Incomplete setup during cloning operation.
-------------------------------------------------
Solution
To implement the solution, please execute thefollowing steps:
1. In cloned Oracle Applications instance, login as SYSAdmin and set the Site-Level value for Profile option "Signon Password Case" to "insensitive."
2. Stop OracleApplications tier services and concurrent server.
3. Use FNDCPASS to change APPS/APPLSYS password.
4. Run autoconfig on Applications tiers so that new APPS password is propagated correctly.
5....