SQL_RESPONSE - Oracle Monitoring - Restarting - Changind PID

book

Article ID: 142390

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

sql_response probe is restarting, changing the PID and you can see this messages:

Dec 20 10:48:27:534 sql_response: loadConnections hostname: mur02qdb,conn->server: <server_name>
Dec 20 10:48:27:534 sql_response: get_path- [D:\app\client\oracle\product\12.1.0\client_1] length->l=44
Dec 20 10:48:27:534 sql_response: Inside load connection->ora_path=D:\app\client\oracle\product\12.1.0\client_1\network\admin\tnsnames.ora
Dec 20 10:48:27:534 sql_response: Search_in_File..., upstr: <server_db_name>
Dec 20 10:48:27:534 sql_response: host name/ip not found in ora file

Environment

Release : 9.0.2

Component : UIM - SQL_RESPONSE

Resolution

Just set up from Host name to IP Adress on: \app\client\oracle\product\12.1.0\client_1\network\admin\tnsnames.ora file of the oracle client installed on the robot where the sql_response probe is running.