DBMaint Issue: CAUAJM_E_85002 Compliance Application terminated with error [100]

Document ID : KB000097587
Last Modified Date : 23/05/2018
Show Technical Document Details
Issue:
DBMaint is failing during the execution of the compliance application with

DBMaint: Starting at: 05/16/18 03:31 ------------------------------------------------------------------------
CAUAJM_I_85000 Compliance Application running
CAUAJM_E_85100 Unable to open database connection. Error details: * IO Error: could not resolve the connect identifier "cawladb"
CAUAJM_E_85002 Compliance Application terminated with error [100]
 
Environment:
CA WAAE 11.3.6 SP7 on Linux with Oracle 11G.
But it can happen with any other CA WAAE Service Packs and Oracle versions
Cause:
JDBC driver did not support the syntax of the tnsnames.ora file
Resolution:
Modify the tnsnames.ora file

From:
====

SID01 = 
(DESCRIPTION = 
    (ADDRESS_LIST =
          (ADDRESS = 
        (PROTOCOL = tcp)
        (HOST = SERVER1)
        (PORT = 1528))
          )
     (CONNECT_DATA =
        (SERVICE_NAME = SID01)
        
          )
)

To:
==
SID01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER1)(PORT = 1528))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID01)
)
)