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 number
IT38181
Reported component name
SP PLUS
Reported component ID
5737SPLUS
Reported release
A17
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-08-30
Closed date
2021-10-08
Last modified date
2021-10-08
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A17","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
31 January 2024