Servicenow not able to discover Oracle Schemas

[naveenmsn]

Servicenow not able to discover Oracle Schemas

For ORACLE Discovery - The current Discovery process identifies the instances/databases (from the OS access), but it does not actually login to the Oracle database in order to drill further and list the various schemas. I am looking into why it was not happening with ServiceNow discovery...Do we need to go with custom options such as a custom SQL query that would extract the schema info after logging in with an Oracle database credential. Let us know the options available for discovering schemas(rather than databases)

[benly]

Hi Naveen,

ServiceNow is not set up to Discover the Databases and Catalogs out of the box.

• Oracle database discovery

Important: Discovery does not discover the Oracle databases themselves, which are referred to as database catalogs.

• Database catalog discovery

Important: Discovery does not support Oracle or MySQL database catalog discovery in the base system. You must create probes and sensors to find these. However the Windows - MSSQL probe is available by default for MSSQL discovery. Starting with the Jakarta release, a pattern is also available. However the pattern and the probes do not populate the same information.

If you wish to discover these, you may have to write some custom probes and sensors. I hope that helps.

Cheers,

Ben

[naveenmsn]

Thank You Ben for the update, it helps.

Will check on feasibility to write some custom probes and sensors and get required info. Let me know if you have any thoughts.

Thanks

Naveen

[Aditya Telideva]

Hi Naveen,

OOB you can discover Oracle instances and listeners. you cannot discover Oracle catalogs or databases. Also, you don't need JDBC type credential to discover Oracle, if you have a credential that can access Oracle Database then configure it as Applicative credential as Oracle instance. If its Unix device then your SSH credential should have a permission to read Oratab files. Please read prerequisites for more information.

Oracle database discovery

[naveenmsn]

Hi Aditya,

I am looking to discover Oracle schemas. we are able to discover oracle instances.

looks like we may need to write some custom probes as mentioned in previous thread. Let me know if you have any thoughts.

Thanks

Naveen