Forum Discussion
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
- Jason_KeatingAltostratus
Update.
We decided to go with member monitors, see config below.
ltm monitor oracle aimosprod.wip.ssi.govt.nz_SQLNET_1521_myService_myDatabase_oracle {
Works ok but support for services would be nice.
- Jason_KeatingAltostratusAnother update.
- Ojp_68831NimbostratusHi,
Recent Discussions
Related Content
* 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