Oracle multiple SID tnsping ?

did you follow the installation procedure Oracle Database | Centreon Documentation and dos the plugin works correctly when you run it on a SID you configured?

if yes, then you can run as many service check as you want

what you cannot do is check multiple service/SID/Server on the same “check”, but nothing prevents you to have 1 check per SID (or servicename)

Hi Christophe,

Yes, a check by SID is exactly what I want but how do I do many tnsping services for the same host? The SID is set to a host macro inherited from the App-DB-Oracle model.

ahh, you need to split “system” host and “app” host

I needed to do the same thing with multiple MS SQL instance

you will need to create a host per SID, I basically use the generic_active_host custom template to get ping and “host alive” then add the app template, oracle in your case

you could also play with host dependency and have all the oracle app host dependant on the system host (you will get unreachable instead of critical on the child host)

Thanks Christophe but creating a host by SID is exactly what I'm afraid of!
A better solution anyone?

Thanks a lot Christophe, creating a custom check command for each SID seems to be a good solution !

A massive shout-out to @christophe.niel-ACT for helping ! 🙌

ha I didn’t really said that !!

you need only one custom command, take the tnsping command from your config, create a new check comand and replace “$_HOSTSID$” by “$_SERVICESID$”, then you make a custom service template and tell it to use this new command

($_HOSTxxx$ will tell centreon to create a macro on the host template, $_SERVICExxx$ will make the macro available on the service template)

it will automatically create a new input field “SID” on the service when you use this template, where you will be able to input your desired SID

and then duplicate this service how many time you want, based on the same template, and just change the name and macro

you can of course do it the hard way and have 1 command for 1 sid and put the SID statically in the command, but the whole point of templates and macros is to have 1 command and 1 template, and many services (easier to manage and maintain and reuse)

if reusability is not an issue, then sure, the hardway is probably easier in your case