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