Agent getting invalid userid/password when connecting with Oracle 12c using containers

Products

• Workload Automation Agent
• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation DE - Business Agents (dSeries)

Issue/Introduction

The agent is able to connect to the database, but it is getting an error message of invalid userid and password.

 

ORA-01017: invalid username/password; logon denied

 

I know the account is working since I can connect to the application through different ways with the same userid and password.

 

We are using Oracle 12c and have containers, but not in a cluster configuration.

 

In Oracle 11g, the database URL syntax worked;

 

jdbc:oracle:thin:@<hostname>:<port>:<sid>

 

Environment

Release : 11.x, 12.x

Component : CA Workload Automation Database Agent

Resolution

It makes no difference whether you have containers configured for the Oracle database or not as the Database plugin uses the JDBC driver to connect to the database.

For Oracle 12c database, use the service name instead of SID (system identifier) and URL syntax;

jdbc:oracle:thin:@<hostname>:<port>/<service_name>

Note the / instead of : in the URL.

So, update the db.default.url parameter in agent's agentparm.txt and restart the agent for the change to take effect.