Reconciliation rules not working for Oracle DB discovery
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2025 09:33 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-03-2025 11:03 AM
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:
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
