The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Difference between Database service and database instance

lmundere
Kilo Sage

Hi,

With discovery for database instances, i have realized that sometimes it injects data for example in class 'Oracle Instance', and some other times in "Oracle DB services". What is actually the difference between the two? 

1 REPLY 1

M Iftikhar
Mega Sage

Hi @lmundere

 

The key difference is that the Oracle Instance represents the running memory and background processes (the software) that manage the database, while the Oracle DB Services represents the logical service names that applications connect to. Discovery populates the Oracle Instance class when it finds a running instance (identified by its SID), which is a mandatory, foundational CI. It populates the Oracle DB Services class when it finds specific, named services that are often configured for load balancing or directing connections to the correct instance in a RAC (Real Application Clusters) environment. Essentially, you connect through a service to an instance.

 

Hope this helps!

 

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution and helpful so others can benefit as well.