APAR status
Closed as program error.
Error description
You will see errors like the following in the JobLog: Oracle restore fails with error message CTGGF0156, Databas <db_name>: Restore failed: Failed to start instance [2020-07-03 09:26:36] INFO pid:28858 Thread-62 startupInstancewithPmonCheck: The startup instance process has encountered some issue: ['ORA-00828: specified value of shared_pool_reserved_size inconsistent Command log will have the exception error message startupInstancewithPmonCheck: The startup instance process has encountered some issue: ['ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings', 'ORA-01078: failure in processing system parameters'] File "/opt/IBM/SPP/agents_SPPUser/oracleagent/runner.py", line xyz, in startupInstancewithPmonCheck Exception IBM Spectrum Protect Plus Versions Affected: 10.1.x Initial Impact: Medium Additional Keywords: SPP, SPPlus, TS003899839
Local fix
1. Dump the params of the source DB to a text pfile. 2. Copy the file to a location on the Oracle server e.g. /home/oracle/spp_restore_template.ora 3. Edit the file and fix the parameters based on the recommendations in this Oracle KB article: https://www.ibm.com/support/knowledgecenter/en/SSNQFQ_1 0.1.6/spp/t_spp_creating_oracle_restore_job.html 4. When defining the SPP restore jobs, select options Init Params = Template, and specify the template file path i.e. /home/oracle/spp_restore_template.ora 5. If the Oracle errors ORA-27154, ORA-27300, ORA-27301, and ORA-27302 occur, increase the number of kernel semaphores or decrease the number of processes required in the template.
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Protect Plus level 10.1.5 and 10.1.6 * **************************************************************** * PROBLEM DESCRIPTION: * * See ERROR DESCRIPTION * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is currently * * projected to be fixed IBM Spectrum Protect Plus level 10.1.7 * * Note that this is subject to change at the discretion of * * IBM. * ****************************************************************
Problem conclusion
Adjusted the delay between the retry attempts to start database after a failure.
Temporary fix
Comments
APAR Information
APAR number
IT33969
Reported component name
SP PLUS
Reported component ID
5737SPLUS
Reported release
A15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-08-20
Closed date
2020-09-21
Last modified date
2020-09-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
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":"A15","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
31 January 2024