Skip to Main Content
Netreo Ideas Portal
Status Needs review
Created by James Mancini
Created on Jul 12, 2022

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
  • 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)