Oracle error ora-01005: null password given logon denied after AIX upgrade

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

Description:

After an AIX upgrade from 5.3 to 6.1, when running a trigger on the System Agent 11.3 with the Oracle plugin, the connection to Oracle was rejected with error: "Java.sql.sql exception..ora-01005: null password given logon denied"

Solution:

Problem was related to the JDBC driver ojdbc5.jar not being compatible with AIX 6.1 release.

Resolved by applying the following solution:

1. Stop the agent
   
   
2. Locate the ojdbc5.jar in <agent_directory>/jars/ext
   
   
3. Move the file to some other location. E.g. You can move it to the <agent_directory>.
   
   
4. Find out the path of the Oracle JDBC. Usually it is in
   
   $ORACLE_HOME/jdbc/lib
   
   
5. Edit the agentparm.txt and edit this parameter:
   
   oscomponent.classpath=jars/*.jar:jars/ext/*
   Change it to
   oscomponent.classpath=jars/*.jar:jars/ext/*:<path_to_Oracle_jdbc>/ojdbc14.jar
   
   NOTE: Make sure you add the full/absolute path and file name of the jdbc jar file.
   
   Do not put *, as other jar files will get picked up agent. This can and will result in agent shutdown.
   
   
6. Save the agentparm.txt file
   
   
7. Restart the agent

Environment

Release: ATSAGE99000-11.3-Workload Automation AE-Remote Agent
Component: