Forum Discussion

Bradley_Rhea's avatar
Bradley_Rhea
Icon for Neophyte rankNeophyte
6 years ago

Monitoring Oracle Plugggable Databases

Has anyone tried to get metrics from the individual Oracle pluggable databases running on Oracle Cloud? The existing Oracle data sources get the high level information on the system, temp, etc. DBs but doesn't seem to be able to get down to the PDBs. If they can be configured to see the PDBs, I haven't been able to find out how yet.

  • 1 hour ago, Bradley Rhea said:

    Has anyone tried to get metrics from the individual Oracle pluggable databases running on Oracle Cloud? The existing Oracle data sources get the high level information on the system, temp, etc. DBs but doesn't seem to be able to get down to the PDBs. If they can be configured to see the PDBs, I haven't been able to find out how yet.

     

    Just a thought, but have you tried adding the DB name into the JDBC connection string ? We've got some Groovy based examples here: https://github.com/logicmonitor/monitoring-recipes/tree/master/DataSources/Groovy/JDBC

    jdbc:oracle:thin:@//<hostname>:<port>/<database_name>