IT38181: "CTGGF0077 FAILED TO DISCOVER ORACLE DATABASES" APPLICATION INVENTORY ERROR

APAR status

• Closed as program error.

Error description

• The application inventory for Oracle servers in IBM Spectrum
  Protect Plus does not find any of the databases located on an
  Oracle server even if all requirements are met.
  
  In the job log, here is an example of an inventory for an
  Oracle server on AIX failing to find any database :
  
  SUMMARY,<timestamp>,CTGGA2398,Starting job for policy
          Application Server Inventory. id -> <JobId>.
          IBM Spectrum Protect Plus version 10.1.7-3102.
  ...
   DETAIL,<timestamp>,CTGGA4000,[<OracleHostAddress>>] Unix Host
          Agent 10.1.x.xxxx running as iusr_spporacle for
          appdiscovery (task ID: 12345)
   DETAIL,<timestamp>,CTGGA4001,[<OracleHostAddress>>] Hostname:
          <OracleHostName> / Operating System: AIX 6.1.0.0
          powerpc / Python: 3.6.9
  ...
   DETAIL,.. Collecting list of Oracle databases.
     WARN,.. Could not collect details for DB instance
             <DBName>: '/bustools/oracle/product/11.2.0.1'.
     WARN,<timestamp>,CTGGF0077,[<OracleHostAddress>>] Failed to
          discover Oracle databases and/or ASM diskgroups.
  ...
  SUMMARY,<timestamp>,CTGGA2340,Job policy Application Server
          Inventory completed in 1 min(s) 36 sec(s) and ended
          with status FAILED.  id <JobId>
  
  In the application log :
  
  [<timestamp>] JOBLOG pid:1234 MainThread populate_oradb_info:
                <CTGGF0089> Collecting list of Oracle databases.
  [<timestamp>]   INFO pid:1234 MainThread get_ismultithreaded:
                  Is Mulithreaded: False
  [<timestamp>] JOBLOG pid:1234 MainThread populate_oradb_details
                : <CTGGF0000> Collecting detailed information for
                instance <DBName>.
  [<timestamp>]   INFO pid:1234 MainThread populate_oradb_info:
                  Traceback (most recent call last):
    File "/opt/IBM/SPP/agents_iusr_spporacle/oracleagent/oradb.
          py", line 300, in populate_oradb_info
    File "/opt/IBM/SPP/agents_iusr_spporacle/oracleagent/oradb.
          py", line 339, in populate_oradb_details
    KeyError: '/bustools/oracle/product/11.2.0.1'
  [<timestamp>]   WARN pid:1234 MainThread populate_oradb_info:
                  <CTGGF0204> Could not collect details for DB
                  instance <DBName>: '/bustools/oracle/product/
                  11.2.0.1'.
  
  The IBM Spectrum Protect Plus inventory job first finds Oracle
  instances paths on the system using the Oracle Central
  Inventory file
  "/bustools/oracle/oraInventory/ContentsXML/inventory.xml".
  Then it tries to find the paths for the specific Oracle
  databases from the current working directory of the database
  process using the sqlplus command :
  'select instance_name,version from v$instance;'
  When there is a discrepancy between these paths, the above
  error is seen.
  An example of such a discrepancy can be as follows.
  
  The output for the sqlplus select command for a database is :
  
     INSTANCE_NAME    VERSION
     ---------------- -----------------
     <DBName>         11.2.0.1.0
  
     ORACLE_HOME=/bustools/oracle/product/11.2.0.1
     ORACLE_SID =<OraSID>
  
  but in the inventory.xml, the HOME_LIST section does not
  display the path "/bustools/oracle/product/11.2.0.1" found
  above :
  
  <HOME_LIST>
  <HOME NAME="OraDb11g_home4" LOC="/bustools/oracle/product/
                                   11.2.0.2" TYPE="O" IDX="1"/>
  <HOME NAME="OraDb11g_home3" LOC="/bustools/oracle/product/
                                   12.1.0.2" TYPE="O" IDX="2"/>
  <HOME NAME="OraDb11g_home2" LOC="/bustools/oracle/product/
                                   11.2.0.3" TYPE="O" IDX="3"/>
  <HOME NAME="OraDb11g_home1" LOC="/bustools/oracle/product/
                                   11.2.0.4/" TYPE="O" IDX="4"/>
  </HOME_LIST>
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.x and later
  
  Additional Keywords: SPP, SPPLUS, TS005529959, inventory,
                       oracle, path, ORACLE_HOME
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.x                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see ERROR description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * currently projected to be fixed in IBM Spectrum Protect Plus *
  * level 10.1.9.                                                *
  * Note that this is subject to change at the discretion of     *
  * IBM.?                                                        *
  ****************************************************************
  

Problem conclusion

• The IBM Spectrum Protect Plus Oracle agent will not have issues
  with discovering databases in an Oracle home when the database
  is ran using a symbolic path.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• Apps     Oracle
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels