UCMDB Tip: Troubleshooting Oracle SAI recognition

Hello All,


If you come across an issue where Oracle products are installed in your environment, but not identified using SAI recognition, please check the following:

  • The Oracle product can be recognized only if it was installed by using the Oracle Universal Installer.
  • Only Oracle 10g and later versions can be recognized consistently. For Oracle 9i, the installed component information can still be collected by scanners.
  • The central inventory pointer file (oraInst.loc) must be stored in the default location. Otherwise, the Oracle inventory information will not be collected by scanners. The reason for this is that this file contains important references for Oracle. If this file exists, the scanner will then use the references from that file to get the relevant info from other directories where this file points to. If this file does not exist in the default location, then this information can not be obtained by the scanner. Please see below the default inventory pointer locations on the various platforms:  

Linux                                              /etc/oraInst.loc

AIX                                                  /etc/oraInst.loc

Solaris, HP-UX, Mac OS X     /var/opt/oracle/oraInst.loc

Windows            HKEY_LOCAL_MACHINE/ Software/Oracle/inst.loc

  • In a UNIX environment, you can use the opatch lsinventory command to locate the oraInst.loc file (see the "from" field). Copy the file to the default location, if it is not already in the default location.