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

book

Article ID: 49092

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Workload Automation Agents 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: