Oracle Monitor not working on GTM. Need Suggestions.
I am in a situation and need help.
I am trying to create an "Oracle Monitor" for an Application Server which would log on to the Backend Database Server and run a query to see if the database is working fine. If not the application node whoud be marked as down by the GTM and users should be directed to the DR Site.
The problem is that as soon as i apply the monitor on the VS in the GTM, the VS is marked as down.
The settings for the Oracle monitor are:
I have created a table in the database specially for this purpose which has a static vaule "X" in it.
I have created a username and password for GTM to log onto the Database.
I have the database name and the TCP Port.
The Database version is 11g.
Also, if I apply a TCP based monitor using the IP Address of the Database Server and the Port, it works fine so I believe that there is no issue of communication between the GTM and the Database.
Any help would be highly appreciated. Thanks!
(The monitor screenshot is attached)