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]

That's a pitty but then again, good to know Wish you lots of success!

[Nithya V Sivara]

HI MC.Soria ,

  Were you able write powershell scripts for windows Oracle Instance. If so can you please share the shell script.

Thanks,

NIthya