Oracle Databases

Mike216
Tera Contributor

Does every oracle database ci have a related oracle database instance ci?

Or is there ever a case where an oracle database CI would NOT have a related oracle database instance CI -- for example, if the Oracle database is not part of a cluster?

Oracle Database table: cmdb_ci_oracle_database

Oracle Instance table: cmdb_ci_db_instance

Thanks. 

3 REPLIES 3

AJ-TechTrek
Giga Sage
Giga Sage

Hi @Mike216 ,

 

This can be possibilities for an oracle Database where not database instance related to that, That basically depends what is configured by Infra Team on oracle, Please check them if you feel any discrepancies

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

 

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

in the Discovery Data.

 

 

SteveMacWWT
Kilo Sage

It may seem like a duplication of data to manage a separate instance CI for a database CI when there is only one instance, but by using the relationship correctly, you are preparing for a future when there could be a cluster implemented.

 

This way you have people referencing the right type of CI from the beginning, and don't need to change code, lists, reference qualifiers, etc. Even if you 'carry' the overhead yourself to implement it this way, and maintain both CIs, end users only need to go to the right class, and don't need to worry about the other class.  

antimark
Kilo Contributor

You can not have an Oracle database without an Oracle instance.  An Oracle "Instance" consists of the processes and memory structures that support the Oracle "database" which consists of the data/data objects. in a traditional Oracle environment you might be a able to loosly associate a "schema" to a database. If all data for a particular purpose is owned by a single user (one-to-one relationship between user and schema) you could (loosly) call that a database so you could have multiple "database" per instance. With Oracle's container database you have 1 container database per instance (think of it like the master database in MSSQL) and then a number of disparet databases (called pluggable databases).