Cannot install AutoSys against Oracle database, error "[CAUAJM_E_112515] Unable to connect to the "oracle19c" database server using the database client utility"
search cancel

Cannot install AutoSys against Oracle database, error "[CAUAJM_E_112515] Unable to connect to the "oracle19c" database server using the database client utility"

book

Article ID: 399783

calendar_today

Updated On:

Products

Autosys Workload Automation

Issue/Introduction

Customer attempt to install AutoSys against Oracle database gave an error "[CAUAJM_E_112515] Unable to connect to the "oracle19c" database server using the database client utility. For more information, refer to the log file."

/tmp/cawa_installer.log shows errors like this:

2025-05-28 04:30:01,559 [main] INFO  com.ca.autosys.db.connection.DBConnectionOracle(203) - Connected to jdbc:oracle:thin:@oracle19c
2025-05-28 04:30:01,559 [main] INFO  com.ca.autosys.db.connection.DBConnectionOracle(204) - Connected  with user ... [aedbadmin]
2025-05-28 04:30:01,559 [main] DEBUG com.ca.wla.ae.installer.customaction.validate.AEValidateDBUpgradeAdminInfo(302) - Connection to schema:true
2025-05-28 04:30:01,560 [main] DEBUG com.ca.autosys.db.connection.DBOperations(81) - Running query: SELECT VERSION FROM PRODUCT_COMPONENT_VERSION WHERE PRODUCT LIKE ? AND ROWNUM=1
2025-05-28 04:30:01,560 [main] DEBUG com.ca.autosys.db.connection.DBOperations(191) - Query params:
2025-05-28 04:30:01,560 [main] DEBUG com.ca.autosys.db.connection.DBOperations(195) - [1 : Oracle Database%]
2025-05-28 04:30:01,562 [main] INFO  com.ca.autosys.db.validation.DBValidator(179) - Database server version - 19.0.0.0.0
2025-05-28 04:30:01,562 [main] DEBUG com.ca.wla.ae.installer.database.DBHelper(1530) - The server version is:19.0.0.0.0
2025-05-28 04:30:01,562 [main] DEBUG com.ca.autosys.db.validation.DBValidator(131) - Checking the version :19 19
2025-05-28 04:30:01,563 [main] DEBUG com.ca.autosys.db.validation.DBValidator(131) - Checking the version :0 0
2025-05-28 04:30:01,563 [main] DEBUG com.ca.autosys.db.validation.DBValidator(131) - Checking the version :0 0
2025-05-28 04:30:01,563 [main] DEBUG com.ca.autosys.db.validation.DBValidator(131) - Checking the version :0 0
2025-05-28 04:30:01,563 [main] DEBUG com.ca.autosys.db.validation.DBValidator(131) - Checking the version :0 0
2025-05-28 04:30:01,564 [main] DEBUG com.ca.autosys.db.validation.DBValidator(117) - Checking the major version only:[19] [23]
2025-05-28 04:30:01,564 [main] DEBUG com.ca.autosys.db.validation.DBValidator(131) - Checking the version :19 23
2025-05-28 04:30:01,583 [main] DEBUG com.ca.wla.ae.installer.customaction.validate.AEValidateOracleHomeTnsAdmin(243) - /opt/CA/oracle/product/client/lib/libclntsh.so IS 64 BIT
2025-05-28 04:30:01,584 [main] DEBUG com.ca.autosys.db.connection.DBConnectionOracle(516) - Trying to connect with password authentication
2025-05-28 04:30:01,584 [main] DEBUG com.ca.autosys.db.connection.DBConnectionOracle(522) - Running command: sqlplus -S -L "aedbadmin"/"######"@oracle19c @"/tmp/AEInstallerOra919273048035934670.sql"
2025-05-28 04:30:01,584 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor(59) - In execute Command
2025-05-28 04:30:01,585 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor(64) - Command Env : PATH = /opt/CA/oracle/product/client/bin:/opt/CA/oracle/product/client:/usr/xpg4/bin:/opt/CA/WorkloadAutomationAE/autosys/csutils/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/opt/puppetlabs/bin:/root/bin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin
2025-05-28 04:30:01,585 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor(64) - Command Env : LD_LIBRARY_PATH = /opt/CA/oracle/product/client/lib:/mnt/r24.0/modules/LIBS:/opt/CA/SharedComponents/Csam/SockAdapter/lib:/opt/CA/SharedComponents/Csam/SockAdapter/lib64
2025-05-28 04:30:01,585 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor(64) - Command Env : ORACLE_HOME = /opt/CA/oracle/product/client
2025-05-28 04:30:01,585 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor(64) - Command Env : TNS_ADMIN = /opt/CA/oracle/product/client/network/admin
2025-05-28 04:30:02,659 [Thread-17] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - ERROR:
2025-05-28 04:30:02,659 [Thread-17] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - ORA-01017: invalid username/password; logon denied
2025-05-28 04:30:02,660 [Thread-17] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) -
2025-05-28 04:30:02,660 [Thread-17] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) -
2025-05-28 04:30:02,660 [Thread-17] DEBUG com.ca.autosys.db.utils.CommandExecutorThread(39) - SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus
2025-05-28 04:30:03,638 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor(87) - Command valueERROR:ORA-01017: invalid username/password; logon deniedSP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus :
2025-05-28 04:30:03,638 [main] INFO  com.ca.autosys.db.utils.CommandExecutor(88) - Command return value: =1
2025-05-28 04:30:03,638 [main] DEBUG com.ca.wla.ae.installer.database.DBHelper(2605) - Failed to connect to database using client
2025-05-28 04:30:03,639 [main] ERROR com.ca.wla.ae.installer.logger.LogHelper(27) - [CAUAJM_E_112515] Unable to connect to the "oracle19c" database server using the database client utility. For more information, refer to the log file.
2025-05-28 04:30:03,639 [main] DEBUG com.ca.wla.ae.installer.logger.LogHelper(35) - Setting the result variables:$AE_DB_UPG_ADMIN_INFO_VALIDATE_RETURN_STATUS$ to:E_AE_DB_Client_Connect_Err :$AE_DB_UPG_ADMIN_INFO_VALIDATE_RETURN_MSG$ to:[CAUAJM_E_112515] Unable to connect to the "oracle19c" database server using the database client utility. For more information, refer to the log file.
2025-05-28 04:30:03,639 [main] INFO  com.ca.wla.ae.installer.customaction.validate.AEValidateDBUpgradeAdminInfo(111) - Done validating the Database admin information

 

As seen above, the first connection test using aedadmin account using JDBC succeeded.  But the same test via SQLPlus failed with invalid username / password error.
 

Environment

AutoSys Workload Automation

Cause

Database user aedbadmin password had a special character & 

Resolution

Change the database passwords for the users aedbadmin / autosys, to remove &   as one of the characters from it.  Retry the installer again there after.

Additional Information

The installer is attempting the sqlplus using something like this:

  • Create a file, /tmp/ae-test.sql  with below contents:

SET ECHO ON;
WHENEVER OSERROR EXIT FAILURE;
WHENEVER SQLERROR EXIT SQL.SQLCODE;
EXIT SUCCESS;

  • Save the file
  • Execute sqlplus command using below syntax,  keep the double quotes  and replace ####### with your password for aedbadmin account:

sqlplus -S -L "aedbadmin"/"#######"@oracle19c @/tmp/ae-test.sql

This should give the same error as the installer, ORA-01017, if the aedbadmin account password has an &  character in it.  This validates that the issue happens outside of the installer too

Powered by Wolken Software