Forum Discussion
Samir_Jha_52506
Jul 07, 2015Noctilucent
Can u please try this..
gtm monitor oracle /Common/monitor_oracle_test {
count 1
database (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=%node_ip%)(PORT=%node_port%))(CONNECT_DATA=
(SERVICE_NAME=PQR_ONLINE_XYZ))(SERVER=dedicated))
debug no
defaults-from /Common/oracle
description
destination *:*
interval 30
password xxxxx
probe-timeout 30
recv PRIMARY
recv-column 1
recv-row 1
send "SELECT database_role FROM database_name"
timeout 91
username CHECK_DB_ROLE_YES
}