Sunday, February 22, 2015

SP2-0310: unable to open file catmmig.sql

Patch 19518079 was needed to reflect the fact that DB was upgraded from 12.1.0.1 to 12.1.0.2.However this patch is now included in the PSU 12.1.0.2.2. This result in an error when the post patch installation steps are carried out.
Patch 19518079 rollback (pdb CDB$ROOT): WITH ERRORS
  logfile: /opt/app/oracle/cfgtoollogs/sqlpatch/19518079/18024100/19518079_rollback_ENT12C_CDBROOT_2015Feb06_17_47_56.log (errors)
    Error at line 27: SP2-0310: unable to open file "/opt/app/oracle/product/12.1.0/dbhome_2/sqlpatch/19518079/18024100/rollback_files/rdbms/admin/catmmig.sql"
Patch 19877336 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/app/oracle/cfgtoollogs/sqlpatch/19877336/18313828/19877336_apply_ENT12C_CDBROOT_2015Feb06_17_47_56.log (no errors)
Patch 19769480 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/app/oracle/cfgtoollogs/sqlpatch/19769480/18350083/19769480_apply_ENT12C_CDBROOT_2015Feb06_17_49_33.log (no errors)
Patch 19518079 rollback (pdb PDB$SEED): WITH ERRORS
  logfile: /opt/app/oracle/cfgtoollogs/sqlpatch/19518079/18024100/19518079_rollback_ENT12C_PDBSEED_2015Feb06_17_49_40.log (errors)
    Error at line 57: SP2-0310: unable to open file "/opt/app/oracle/product/12.1.0/dbhome_2/sqlpatch/19518079/18024100/rollback_files/rdbms/admin/catmmig.sql"
Patch 19877336 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/app/oracle/cfgtoollogs/sqlpatch/19877336/18313828/19877336_apply_ENT12C_PDBSEED_2015Feb06_17_49_40.log (no errors)
Patch 19769480 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/app/oracle/cfgtoollogs/sqlpatch/19769480/18350083/19769480_apply_ENT12C_PDBSEED_2015Feb06_17_51_28.log (no errors)
Patch 19877336 apply (pdb PDB12C): SUCCESS
  logfile: /opt/app/oracle/cfgtoollogs/sqlpatch/19877336/18313828/19877336_apply_ENT12C_PDB12C_2015Feb06_17_51_33.log (no errors)
Patch 19769480 apply (pdb PDB12C): SUCCESS
  logfile: /opt/app/oracle/cfgtoollogs/sqlpatch/19769480/18350083/19769480_apply_ENT12C_PDB12C_2015Feb06_17_53_00.log (no errors)
Patch 19877336 apply (pdb PDB12CDI): SUCCESS
  logfile: /opt/app/oracle/cfgtoollogs/sqlpatch/19877336/18313828/19877336_apply_ENT12C_PDB12CDI_2015Feb06_17_51_33.log (no errors)
Patch 19769480 apply (pdb PDB12CDI): SUCCESS
  logfile: /opt/app/oracle/cfgtoollogs/sqlpatch/19769480/18350083/19769480_apply_ENT12C_PDB12CDI_2015Feb06_17_53_00.log (no errors)
Rolling back of the patch fails with unable to open file catmmig.sql.



The log files shows
IGNORABLE ERRORS: NONE

INSTALL_FILE
--------------------------------------------------------------------------------
?/sqlpatch/19518079/18024100/rollback_files/rdbms/admin/catmmig.sql

SP2-0310: unable to open file "/opt/app/oracle/product/12.1.0/dbhome_2/sqlpatch/19518079/18024100/rollback_files/rdbms/admin/catmmig.sql"

PL/SQL procedure successfully completed.
The metalink notes listed at the end of the post gives a workaround for this which involves manually adding an entry to the registry$history to mention the upgrade.

Useful metalink notes
Oracle Quarterly Database Patch 12.1.0.2.4 Known Issues [ID 1942931.1]
Oracle Quarterly Database Patch 12.1.0.2.1 Known Issues [ID 1930503.1]
Bug 20421900 - catmmig.sql is missing from the 12.1.0.2.2/3/4 Engineered Systems / DB In-Memory Bundle Patch (DBBP) [ID 20421900.8]