data_engine; OCI_ERROR - ORA-12516: TNS:listener could not find available handler
search cancel

data_engine; OCI_ERROR - ORA-12516: TNS:listener could not find available handler

book

Article ID: 379771

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The data_engine probe is running but continuously reports the error below in the log:

OCI_ERROR - ORA-12516: TNS:listener could not find available handler with matching protocol stack

Environment

Any UIM version with Oracle database

Resolution

This issue is sometimes seen when the number of sessions allowed on the UIM database has exceeded and DBA should be engaged to validate the limit 

Helpful queries:

Inactive session count per system names: select username,machine,count(1) from gv$session where status='INACTIVE' group by username,machine;

Total inactive session: select count(*) from gv$session where status='INACTIVE'


Workaround: Restart the Primary hub to release inactive session

Additional Information

Powered by Wolken Software