Issue :
JNDI Creation Failed For EBS Database
Observation :
When attempting to create JNDI as per step 4
the following error occurs.
The edit lock associated with this edit session is released once the activation is completed.
Problem invoking WLST – Traceback (innermost last):
File “<ECC_BASE>/Oracle/software/temp/createEBSJndi.py”, line 75, in ?
NameError: BeanAlreadyExistsException
The returned message is: ORA-01017: invalid username/password; logon denied
Reason :
The user used for JNDI setup was not having access to database,
The cause was determined as below by running the below script in the quickinstall directory :
Go to $ECC_BASE/Oracle/quickInstall and execute the following commands:
1- source env/ecc.env
sh validateDBCConnectivity.sh
2- The output of the script execution should confirm which probable cause is the root cause.
<user> is the configured user. Would you like to proceed with this user validation(y/n)? :y
Enter the password:
java.lang.RuntimeException: ORA-20001: The Applications user, <user> is not authorized to access the database.
ORA-06512: at “APPS.APP_EXCEPTION”, line 72
ORA-06512: at “APPS.FND_SECURITY_PKG”, line 606
ORA-06512: at line 1
at oracle.apps.fnd.security.AppsDataSource.setOds(AppsDataSource.java:131)
at oracle.apps.fnd.security.AppsDataSource.setPassword(AppsDataSource.java:212)
at ValidateDBCConnectivity.main(ValidateDBCConnectivity.java:17)
Fix :
As part of EBS JNDI creation, we have to provide the below information:
a)EBS apps user credentials.
b) Password for the EBS_ECC_USER , the FND_USER configured in EccConfig.properties. Set the password if FND_USER is not present in EBS else validate the FND user.
c) ECC domain admin credentials
after using the default user ECC_DISCOVERY for EBC_ECC_USER , the JNDI creation completed successfully.
