IT33969: ORACLE RESTORE FAILS WITH ERROR MESSAGE CTGGF0156 :FAILED TO START INSTANCE

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 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