data_engine error - Oracle_Database::getOCISvcCtxUnq (GET) OCISessionGet: retrieving from pool

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The data engine probe has max restarts and fails to get a port. We have tried to activate /deactivate probe, validate probe and restart probe but still fails.

Can see the below error messages in data_engine logs

Jan 13 14:01:30:535 [11544] 0 de: data_engine [main] [main] - Oracle_Database::OCIPrep [main] data_engine [main] status: -2 
Jan 13 14:01:30:535 [11544] 0 de: check_output - Output Parameters returned from SP....size: 0 
Jan 13 14:01:30:535 [11544] 3 de: Oracle_Database::OpenDB OCIEnvNlsCreate init status query to ms_pEnvhp=000000DE9C963560... 
Jan 13 14:01:30:535 [11544] 1 de: Oracle Env Session Lock LOCK 
Jan 13 14:01:30:535 [11544] 1 de: Session pool already initialized. Not initializing again. 
Jan 13 14:01:30:535 [11544] 1 de: Oracle Env Session Lock UNLOCK 
Jan 13 14:01:30:535 [11544] 3 de: OCIWrapper::allocateOCIErrorHandle OCIHandleAlloc errhp... 
Jan 13 14:01:30:535 [11544] 3 de: Oracle_Database::OpenDB (SET) OCIAttrSet OCI_ATTR_USERNAME: apmuim ... 
Jan 13 14:01:30:535 [11544] 2 de: Oracle_Database::OpenDB (RETURN) OCIAttrSet OCI_ATTR_USERNAME: xxxxxx STATUS = 0 
Jan 13 14:01:30:535 [11544] 3 de: Oracle_Database::OpenDB (SET) OCIAttrSet OCI_ATTR_PASSWORD:  ... 
Jan 13 14:01:30:535 [11544] 2 de: Oracle_Database::OpenDB (RETURN) OCIAttrSet OCI_ATTR_PASSWORD:  STATUS=0 
Jan 13 14:01:30:535 [11544] 3 de: Oracle_Database::getOCISvcCtxUnq (GET) OCISessionGet: retrieving from pool OCI:SP:lO3MmufjSMWeFQ0WsOcMdC ... 
Jan 13 14:01:31:300 [11544] 0 de: data_engine [update] [update] - Oracle_Database::getOCISvcCtxUnq [update] data_engine [update] status: 1 
 OCIEnv: 0x000000DE9C963560 OCIAuthInfo: 0x000000DE9C973D90 OCISvcCtx: 0x0000000000000000  
Jan 13 14:01:31:300 [11544] 0 de: slm_40_update - could not connect to the database 
Jan 13 14:01:31:300 [11544] 0 de: main Database update failed. Correct the problem and try again. 
Jan 13 14:01:31:300 [11544] 3 de: Database_global_lock LOCK 
Jan 13 14:01:31:300 [11544] 3 de: Database_global_lock UNLOCK 
Jan 13 14:01:31:300 [11544] 0 de: Database library - program is exiting through exit()... 
Jan 13 14:01:31:300 [11544] 3 de: Database library unloaded 
Jan 13 14:01:31:300 [11544] 3 de: Database_global_lock DESTROY LOCK 
Jan 13 14:01:31:300 [11544] 3 de: Copy Snapshot DESTROY LOCK 
Jan 13 14:01:32:310 [1236] Controller: Max. restarts reached for probe 'data_engine' (command = data_engine.exe) 

Popup window error showed:

A database warning was encountered performing the requested operation:

ORA-28002: the password will expire within 5 days
28002. 00000 - "the password will expire within %s days"
"Cause:  The user's account is about to expire and the password needs to be changed
*Action:  change the password or contact the DBA Vendor code 28002

Environment

• Release: 9.2.0 or potentially higher UIM versions
• Component: DATA_ENGINE
• Oracle database: 11G

Cause

• Oracle database password expiration

Resolution

After being checked by the DBA team, the credentials used by UIM on the data_engine were found to be expired.

After the password was updated, the data engine was activated again, and then the QOS data was successfully being inserted into the UIM database.