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