During WebUI/WCC upgrade, the installer tries to connect to the Oracle database and fails with this message:
Error:
[CAUAJM_E_112508] An error occurred while connecting to the "AUTOTST1" database server.
java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Listener log on db server:
22-DEC-2021 13:37:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))(SERVICE_NAME=AUTOTST1)) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.XX.XX)(PORT=55235)) * establish * AUTOTST1 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
Workload Automation AutoSys
Installer attempt to connect to Oracle Database using the JDBC URL it builds (by reading existing connection.properties file) is not resolved via Oracle TNS layer
2021-12-22 16:01:16,686 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - Obj: dbTnsAlias null dbServiceName=AUTOTST1 dbHostMachine=dbserver.example.com dbPort=1521
2021-12-22 16:01:16,686 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - TNS_ADMIN=null
2021-12-22 16:01:16,686 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - url template:jdbc:oracle:thin:@//${servername}:${port}/${dbname}
2021-12-22 16:01:16,686 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - Setting host and port: dbserver.example.com : 1521
2021-12-22 16:01:16,686 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - Database connection string :jdbc:oracle:thin:@//dbserver.example.com:${port}/AUTOTST1
2021-12-22 16:01:16,686 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - Database connection string :jdbc:oracle:thin:@//dbserver.example.com:1521/AUTOTST1
2021-12-22 16:01:16,686 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - Database connection string :jdbc:oracle:thin:@//dbserver.example.com:1521/AUTOTST1
2021-12-22 16:01:16,686 [main] DEBUG com.ca.autosys.db.connection.DBConnectionOracle - tnsAdmin= null
2021-12-22 16:01:16,687 [main] INFO com.ca.autosys.db.connection.DBConnectionOracle - connecting ... [jdbc:oracle:thin:@//dbserver.example.com:1521/AUTOTST1]
2021-12-22 16:01:16,687 [main] INFO com.ca.autosys.db.connection.DBConnectionOracle - Connecting with user ... [wcc]
2021-12-22 16:01:16,687 [main] INFO com.ca.autosys.db.connection.DBConnectionOracle - connecting ... [jdbc:oracle:thin:@//dbserver.example.com:1521/AUTOTST1]
2021-12-22 16:01:16,999 [main] ERROR com.ca.autosys.db.connection.DBConnectionOracle - SQLException:
2021-12-22 16:01:16,999 [main] ERROR com.ca.autosys.db.connection.DBConnectionOracle - Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
2021-12-22 16:01:16,999 [main] DEBUG com.ca.wla.ae.installer.customaction.initialize.AEDBSetUpgradeList - Exception occurred while connecting to database:OracleObject [tnsAlias=null, tnsAdmin=null, oracleWalletJarPath=null, schemaOwner=wcc, cacheLocation=null, principalName=null, jassConfigFile=null]
com.ca.autosys.db.exception.AutosysDBException: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
at com.ca.autosys.db.connection.DBConnectionOracle.openConnection(DBConnectionOracle.java:210)
at com.ca.autosys.db.connection.DBConnectionOracle.openConnection(DBConnectionOracle.java:184)
at com.ca.autosys.db.connection.DBConnectionOracle.<init>(DBConnectionOracle.java:122)
at com.ca.autosys.db.connection.DBFactory.getConnection(DBFactory.java:65)
at com.ca.autosys.db.main.AutoSysDBConnection.openConnection(AutoSysDBConnection.java:78)
at com.ca.autosys.db.main.AutoSysDBConnection.<init>(AutoSysDBConnection.java:57)
Configure WCC to use TNS_ADMIN to resolve the Oracle database and then re-run upgrade.
This can be done by
wcc.database.tnsname=AUTOTST1
wcc.database.tnspath=/opt/oracle/network/admin
reporting.database.tnsname=AUTOTST1
reporting.database.tnspath=/opt/oracle/network/admin
Note: Change the values above to your values, above are just examples