Oracle Service JDBC URL
We've got 4 Oracle RAC Nodes, each with multiple instances, each with multiple DB's
We want to put the services behind LTM's for various reasons, improvement upon the Oracle failover being one.
Since we have multiple instances on each node, I'd prefer to monitor oracle at the pool and mark members down if a particular service is unavailable. I've tried the Oracle monitor but it seems to dislike service urls (jdbc:oracle:thin:username/password@//myhost:1521/orcl) and only like sids (judging by the messages in the /var log (forget log name sorry)
Has anyone monitored services before ? was it a custom monitor ? if so, were you able to capitlise upon the jdbc libs used by the oracle monitor and get around firing up another jvm each time?
Cheers for any insight
J