Discover Oracle Edition

[MC_Soria]

Hi Everyone,

We're trying to find a way to Discover Oracle Editions from instances installed on both Unix and Windows servers.

From what I've found so far, it seems that you'd need an SSH or Powershell command to log on to the installed Oracle instance and run the following query:

SELECT * FROM v$version;

Which would return something like this:

Banner

--------------------------------------------------------------------------------------

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

CORE 11.2.0.2.0 Production

TNS for Linux: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production

Here is the website where I found this info:

Oracle/PLSQL: Retrieve Oracle version information

Has anyone been able to do this and would you be willing to share the probe & sensor config / scripts?

Any help is greatly appreciated. Thanks.

[Stijn Verhulst3]

Hi Mario,

maybe you should check the ServiceNow Share site whether someone has provided probes & sensors over there. It's not so difficult though to implement this as you already know the command and well as the output of the command.

Coding & configuration can be done quickly as soon as you know which information you want to filter from the output. Which information from the output needs to be stored where exactly?

Kind regards,

Stijn

[MC_Soria]

Hi Stijn,

Thanks for your reply. Ideally, we'd like to parse the banner for the edition and then update a custom "Edition" field we've added to the Oracle Instance CMDB CI form.

- Mario

[Stijn Verhulst3]

Mario,

I've looked a bit into detail. You'll need to attach the newly probe & sensor to the Process Classification 'Oracle Instance' (can be found via 'Discovery Definition' application -> module 'Processes').

But I'm not really sure whether you'll have to create a new probe & sensor as OOB probes / sensors are available to discover the Oracle version; at least on the Fuji release:

- for UNIX: Oracle - Instance Details

- for Windows: Oracle - Instance Version

Both will normally discover the version of the Oracle instances and store them in the version field. Of course, this is what I see on a Fuji OOB instance.

If you're running an older release, an upgrade might do the trick although that depends on your situation. Also it depends on the fact whether the returned output from the machine holds the desired information you wish to store in the CMDB. If the last is not true, you'll have to create a new probe / sensor after all.

Some people might argue you can always adjust the existing probes & sensors but I personally de-advise if it's possible to implement it next to the existing configuration.

Stijn

[MC_Soria · Accepted solution]

Thanks again Stijn - we ended up working with our Oracle, Unix, and Windows teams to write new probes & sensors. We on Fuji, but the OOB probes & sensors weren't returning the edition for the Oracle Instances. We're testing out the Unix stuff, but are still working on the Windows Powershell scripts.