Autosys install tries to connect to SYS$USERS AWS RDS database, ORA-12514 in installer log

Products

• Autosys Workload Automation

Issue/Introduction

Autosys install appears to hang when it initiates the JDBC connection into Oracle AWS database.

/tmp/cawa_installer.log contains entries like this:

2022-02-01 22:20:52,322 [main] DEBUG com.ca.autosys.db.connection.DBOperations - Running query: select SERVICE_NAME as value from gv$session where sid in (select sid from V$MYSTAT)
2022-02-01 22:20:52,356 [main] INFO  com.ca.autosys.db.validation.OracleDBValidator - ORACLE_DB_SETUP : get Service name - SYS$USERS
2022-02-01 22:20:52,356 [main] ERROR com.ca.wla.ae.installer.logger.LogHelper - [CAUAJM_W_112562] The Oracle service name and TNS alias name should be the same.
2022-02-01 22:20:52,356 [main] DEBUG com.ca.wla.ae.installer.logger.LogHelper - Setting the result variables:$AE_DB_ADMIN_INFO_VALIDATE_RETURN_STATUS$ to:W_AE_Ora_ServiceName_Not_Same :$AE_DB_ADMIN_INFO_VALIDATE_RETURN_MSG$ to:[CAUAJM_W_112562] The Oracle service name and TNS alias name should be the same.
2022-02-01 22:20:52,356 [main] DEBUG com.ca.wla.ae.installer.database.AEDatabase - get AE Database AutoSysDBConnection from dbobject
2022-02-01 22:20:52,356 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - Obj: dbTnsAlias null dbServiceName=SYS$USERS dbHostMachine=dev-autosys-mycompany.com.us-east-1.rds.amazonaws.com dbPort=1521
2022-02-01 22:20:52,356 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - TNS_ADMIN=null

2022-02-01 22:20:52,356 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - url template:jdbc:oracle:thin:@//${servername}:${port}/${dbname}
2022-02-01 22:20:52,356 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - Setting host and port: dev-autosys-mycompany.com.us-east-1.rds.amazonaws.com : 1521
2022-02-01 22:20:52,356 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - Database connection string :jdbc:oracle:thin:@//dev-autosys-mycompany.com.us-east-1.rds.amazonaws.com:${port}/SYS$USERS
2022-02-01 22:20:52,356 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - Database connection string :jdbc:oracle:thin:@//dev-autosys-mycompany.com.us-east-1.rds.amazonaws.com:1521/SYS$USERS
2022-02-01 22:20:52,356 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder - Database connection string :jdbc:oracle:thin:@//dev-autosys-mycompany.com.us-east-1.rds.amazonaws.com:1521/SYS$USERS
2022-02-01 22:20:52,357 [main] DEBUG com.ca.autosys.db.connection.DBConnectionOracle - tnsAdmin= null
2022-02-01 22:20:52,357 [main] INFO  com.ca.autosys.db.connection.DBConnectionOracle - connecting ... [jdbc:oracle:thin:@//dev-autosys-mycompany.com.us-east-1.rds.amazonaws.com:1521/SYS$USERS]
2022-02-01 22:20:52,357 [main] INFO  com.ca.autosys.db.connection.DBConnectionOracle - Connecting  with user ... [aedbadmin]
2022-02-01 22:20:52,357 [main] INFO  com.ca.autosys.db.connection.DBConnectionOracle - connecting ... [jdbc:oracle:thin:@//dev-autosys-mycompany.com.us-east-1.rds.amazonaws.com:1521/SYS$USERS]
2022-02-01 22:20:52,365 [main] ERROR com.ca.autosys.db.connection.DBConnectionOracle - SQLException: 
2022-02-01 22:20:52,365 [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
 

Environment

Release : 12.1

Cause

Somehow TNS Names resolution for AWS database is not happening to get the correct Service Name from the database.  SQLPlus seems to work fine.

tnsnames.ora:

AEDB =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = dev-autosys-mycompany.com.us-east-1.rds.amazonaws.com)(PORT = 1521))
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = AEDB)
  )
  )

Resolution

Fix the tnsnames.ora to contain a _A  as the TNS Name  and retry the install.

 

Example:

AEDB_A =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = dev-autosys-mycompany.com.us-east-1.rds.amazonaws.com)(PORT = 1521))
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = AEDB)
  )
  )