Dashboard Designer - ORA-01034, ORA-27101, SVR4 Error 2 when creating JDBC connection to Oracle

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are trying to create a JDBC connection to an Oracle Database in the Dashboard Designer as per the following document:

Add a Database Connection for SQL Data Sources

The UIM installation itself is not hosted on Oracle, but we are attempting to connect to an external Oracle database.

When attempting to test the connection we receive numerous Oracle errors:

  ORA-01034: ORACLE not available
  ORA-27101: shared memory realm does not exist
  SRV4 Error: 2: No such file or directory

What is the cause of this error and how can it be corrected?

Cause

This is related to the PATH or ORACLE_HOME environment variables.

These variables should not be set when the UIM environment itself is not hosted on Oracle.

The Oracle client is not needed and should not be installed or referenced in the environment variables.

Resolution

The Dashboard Designer JDBC functionality does not require a local installation of the Oracle client; it uses the built-in Java-based drivers and there are no additional drivers required.

If the Oracle Client (instant or full version) has been installed on the system, this can interfere with the creation of JDBC connections.

Remove the Oracle Client from the Operator Console system, and ensure that the ORACLE_HOME environment variable is not set at either the controller/robot level or the operating system level on the Operator Console robot.

Also check the PATH variable and ensure that the path to Oracle client is not present.