Forum Discussion
Jorge_Herran_14
Jul 06, 2015Altostratus
How to correctly monitor a Database Oracle
we are configuring a monitor health for a Oracle database which has the next configuration parameters:
Send String: select * from dual
Response: X
user:CONSULTA_ANALISTA
password:xxxxxxx
co...
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
}
Recent Discussions
Related Content
DevCentral Quicklinks
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com
Discover DevCentral Connects