CAUAJM_E_85100 DBmaint Connection Failure
Article ID: 36106
Updated On:
Products
Issue/Introduction
Problem:
DBmaint fails with below error.
CAUAJM_I_85000 Compliance Application running
CAUAJM_E_85100 Unable to open database connection.
Error details:
* IO Error: could not resolve the connect identifier "XXXXX"
CAUAJM_E_85002 Compliance Application terminated with error [100]
Environment:
This issue may occur on AIX, Linux, Unix, Solaris and HP with Oracle as DB.
Cause:
The problem is related to using fully qualified TNS alias in the tnsnames.ora. The SID value is extracted from the AE config file and using the TNS short
name.
Solutions:
Modify file tnsnames.ora or Copy JDBC driver from the OCI client install to the $AUTOSYS/lib directory.
The OCI driver is able to retrieve the fully qualified TNS name from the short name.
However, the Oracle JDBC driver is not able to do this.
There are two solutions which can be implemented.
First one:
1. Modify the tnsnames.ora file
2. Duplicate the fully qualified TNS entry and change it to the short name. For example if you have the following in the tnsnames.ora:
TEST.CA.COM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)
copy the TNS entry and change the copy to look like this:
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)
3. Save the tnsnames.ora file.
Second one:
1. Copy the JDBC driver from the OCI client install to the $AUTOSYS/lib directory.
2. Modify the $AUTOSYS/config/cmplapp/connection.properties
Change the following:
oracle.tns.connection.string=jdbc:oracle:thin:@${dbname}
to
oracle.tns.connection.string=jdbc:oracle:oci:@${dbname}
3. Save the connection.properties
Additional Information:
This issue is solved in CA WAAE Release 11.3.6 SP3.
If issue is not solved please raise the case to CA Support.
Environment
Component:
Attachments
Feedback
