AutoSys Application Server Fails to Start with CAUAJM_E_18402 ORA-12571 TNS Packet Writer Failure

Products

• Autosys Workload Automation

Issue/Introduction

Users observe latency when updating job statuses. Attempting to restart the AutoSys Application Server fails, and the application log displays the following error sequence:

Plaintext

 

CAUAJM_E_18416 Event Server: <name of database> Failed Query: <select str_val from ujo_alamode where type='BINARY_VERSION'>
CAUAJM_E_18402 ORA-12571: TNS:packet writer failure
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <902>
CAUAJM_E_40213 AutoSys Application server does not start as the AEDB version does not match with the product version.
CAUAJM_I_30004 AutoSys Application Server shutdown complete.

 

Environment

• Product: CA Workload Automation AE (AutoSys)

• Release: 12.1 and higher

• Database: Oracle

 

Cause

The Oracle client on the Application Server machine is encountering network connectivity failures when communicating with the AutoSys database (AEDB). Hostname resolution issues typically trigger ORA-12571: TNS:packet writer failure, preventing the Application Server from verifying the database schema version.

 

Resolution

Update the Oracle TNS configuration to use the database server's direct IP address instead of its hostname:

1. On the AutoSys Application Server host, locate the tnsnames.ora file (typically in $ORACLE_HOME/network/admin or defined by %TNS_ADMIN%).

2. Open tnsnames.ora in a text editor.

3. Locate the entry for the affected Oracle Event Server (ORCL1 / ORCL2).

4. Update the HOST parameter in the connection string to use the static IP address of the Oracle database server instead of the hostname:

   Plaintext

    

   (ADDRESS = (PROTOCOL = TCP)(HOST = <Database_IP_Address>)(PORT = <Port>))
   

5. Save the file.

6. Restart the AutoSys Application Server.

 

Additional Information

To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on the respective region.