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: <username>... 
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

Before resetting the password, check to make sure the database listener is active.

 

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.