DB service agent fails with java.lang.UnsatisfiedLinkError: C:\oracle\19.0.0\client_64\bin\ocijdbc19.dll: The specified procedure could not be found

Products

• CA Automic One Automation

Issue/Introduction

DB service agent dies with the following error in the log file: 'java.lang.UnsatisfiedLinkError: C:\oracle\19.0.0\client_64\bin\ocijdbc19.dll: The specified procedure could not be found'

Scenario:

Oracle database and client were updated to version 19c, ORACLE_HOME variable and PATH variable were adjusted.

However, the DB service agent dies with the following errors:

U02000005 Job 'JOBS.SQL.TEST' with RunID '1234567' started.

U02012031 The database driver returned the following error message:

java.lang.UnsatisfiedLinkError: C:\oracle\19.0.0\client_64\bin\ocijdbc19.dll: The specified procedure could not be found

U02004025 Job-script execution was aborted.

Environment

Release : 12.3

Component : Automation Engine

Cause

Configuration

Resolution

To resolve the issue, follow the steps below:

1. Verify if PATH variable is correctly adjusted, there should not an old Oracle Client reference.

2. Verify if ocijdbc19.dll is present in in the bin directory of the Oracle client

3. Reboot the agent and the server. In many cases, server reboot is not required. However, when starting Service Manager as a service, it inherits values from the system start up, and restarting the server clears that out.