Skip to Main Content
Netreo Ideas Portal

Oracle polling must change to using Service Name and not SID

Starting with Oracle 12, Oracle introduced the multi-tenant architecture similar to SQL server. In this architecture each DB process has a container database and inside it is 1 or more pluggable databases. This was optional but deprecated through v19, but as of v21 it is obsolete.


Versions of oracle > 19 therefore cannot be monitored with our oracle monitoring product.


In fact our client doesn't seem to connect at all.



Netreo Product Area Netreo (IM)
  • Attach files
      Drop here to upload
    • James Mancini
      Reply
      |
      Jul 12, 2022

      Note: "This was optional but deprecated through v19, but as of v21 it is obsolete." Is referring to accessing databases via SID.

    • James Mancini
      Reply
      |
      Jul 12, 2022

      My oracle dev contractor has indicated that it shouldn't be a difficult change to go from SID to Service Name once the client is updated.

    • James Mancini
      Reply
      |
      Jul 12, 2022

      This will likely also require an update to the oracle client installed as well. We may even need some option for older versions (<=18 vs >=19)