Reconciliation rules not working for Oracle DB discovery

[devpc]

Hello everyone, I'm having some issues with Database discovery on serviceNow, the Reconciliation rule for oracle instance isn't working, I can see the Oracle instance is duplicated (see screen 1) and I have this error message if I try the debug mode (see screen 2) which is the same error message I receive when I see the log of the discovery (for instance in screen 2 there is an error message and what I see is in Screen 3). Also I can't discover the Oracle Database itself (cmdb_ci_oracle_database) but only the instance. 

How can I manage it?

Thanks

[blanm]

Hi,

I am new to oracle/discovery myself but I have done a lot of research. I think there is a setting in the discovery properties that addresses lower case and uppercase host names, which might be the issue here since the duplicate is lowercase. (All> Discovery Definition>Properties  for xanadu)

Here is another good resource from servicenow explaining your issue with only discovering the instance and not the db:

https://www.servicenow.com/docs/bundle/xanadu-it-operations-management/page/product/discovery/concep... 

Additional requirements

Discovery identifies a running instance of an Oracle database on UNIX from the process that starts with ora_pmon_. Ensure this process is running in the IP range you designate for Discovery. Discovery identifies a running instance of an Oracle database on Windows from the oracle.exe process. Ensure this process is running in the IP range you designate.

Here is another good article

https://www.servicenow.com/docs/bundle/xanadu-it-operations-management/page/product/discovery/concep...