data_engine error - OCI_INVALID_HANDLE (Status -2)

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

data_engine pointing to an Oracle database for the UIM database backend, has OCI_INVALID_HANDLE error in the logs:

Oracle_Database::OCIPrep [QoSData] data_engine [QoS] status: -2     Error - OCI_INVALID_HANDLE     OCIEnv: 0x00000000105DE040 OCIAuthInfo: 0x0000000011D76190 OCISvcCtx: 0x000000000F85B100

Functionality may or may not be impacted. If the issue is persistent, the data_engine may not start; if it is intermittent, it may not affect operations other than throwing an alarm.

Environment

• Oracle database server

Cause

• Oracle error

Resolution

This error has been seen a handful of times and in most of those cases it has resolved itself after several minutes, indicating a transient issue with connectivity to the database server.

In one case, rebooting the database server solved the problem.

Below is some information about this error, but it is not caused by anything specific to UIM, or any configuration, defect, or error that we are aware of;  100% of cases where this error message occurred have been resolved without adjusting or touching UIM.

----------------------------------------------------

OCI_INVALID_HANDLE
Cause: The server called OCI with an invalid handle whilc accessing the region database. This is an internal error.

Action: Contact Oracle Support Services.

Contact Oracle to see what tracing is available for both the Client and Database in the event of a recurrence of the alarm. 

The data_engine is just passing the error it received from the Client (which the client may or may not have received from the database).

Whatever the problem, it will need some involvement from the Oracle side, e.g., Oracle DBAs, Oracle support case.