Receiving ORA-12154: TNS: could not resolve the connect identifier specified during AutoSys Install

Products

• Autosys Workload Automation

Issue/Introduction

2024-04-02 12:22:36,374 [main] DEBUG com.ca.autosys.db.connection.DBConnectionOracle(466) - Trying to connect with password authentication
2024-04-02 12:22:36,374 [main] DEBUG com.ca.autosys.db.connection.DBConnectionOracle(472) - Running command: sqlplus -S -L "aedbadmin"/"******"@<name of database> @"/tmp/415714.tmp/ddl_tmp.sql"
2024-04-02 12:22:36,374 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor(22) - In execute Command

2024-04-02 12:22:36,374 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor(27) - Command Env : ORACLE_HOME = /oracle/app/oracle/product/21.0.0/client_1
2024-04-02 12:22:36,374 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor(27) - Command Env : TNS_ADMIN = /oracle/app/oracle/product/21.0.0/client_1/network/admin
2024-04-02 12:22:36,393 [Thread-16] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - ERROR:
2024-04-02 12:22:36,393 [Thread-16] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - ORA-12154: TNS:could not resolve the connect identifier specified
2024-04-02 12:22:36,394 [Thread-16] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - 
2024-04-02 12:22:36,394 [Thread-16] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - 
2024-04-02 12:22:36,394 [Thread-16] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus
2024-04-02 12:22:36,395 [main] INFO  com.ca.autosys.db.utils.CommandExecutor(49) - Command return value:1
2024-04-02 12:22:36,395 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor(51) - RetVal =1
2024-04-02 12:22:36,396 [main] WARN  com.ca.autosys.db.install.CreateInstanceSchema(491) - Found error pattern ORA-12154
2024-04-02 12:22:36,396 [main] ERROR com.ca.autosys.db.install.CreateInstanceSchema(160) - database was not created or updated.

Resolution

The password for the aedbadmin user had an @ in the password. Specified a new password for the aedbadmin user without the @

Here is the link to Oracle regarding special characters and reserved words:

https://docs.oracle.com/en/industries/health-sciences/life-sciences-data-hub/3.0/app-dev-guide/special-characters-and-reserved-words.html