Service mapping, How to filter on a specific database when Oracle Server hosts many databases

Nabil EL FILALI
Tera Expert

Hello 

I have to map my application to one database, but on the server hosting this database , there is others. When the mapping is complete, a random database are displayed.

How to fixe that please ? 

 

Thanks

3 REPLIES 3

Mohammed Faazi2
Tera Contributor

I recommend to relate the application service with the 'database instance' rather than 'database'.

Database instance [cmdb_ci_db_instance] - MSSQLSERVER@server_name

Database [cmdb_ci_database] - master , temp, UAT, XYZ...

from CI relationships, a Database instance [contains] Database.

You will raise ticket/incident against the host machine (CI) and the impacted service will be impacted application service linked to this CI.
If there are more than one application service is consuming same DB instance, assuming DEV and UAT application services are using same database,  
the incident caller/agent should be able to select the right application service which is having the impact. 

Hi Mohammed

thanks for your answer, i did some troubleshooting and i realized that the appache server when it reads websphere configuration files , it extracts all databases attached to jdbc. i don't know how to find out the right database, if you have an idea 

 

thanks a lot  

Ideally system will map the DB instance with DB, if we are bringing it via Connectors. 
Manual data will require a correlation ID / relationship with its instance. With this, can probabaly run some scripts to reference CIs or create CI relationships.