Monday, October 22, 2018

Datapatch CDB / PDB hits ORA-06508

Symptom:

     When we patch PSU on CDB / PDB , we need to ./datapatch -verbose under Opatch

     It reports
      Patch 26963039 apply (pdb PDB$SEED): WITH ERRORS                                                                            
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26963039/21649415/
26963039_apply_CASCDBSB_PDBSEED_2018Mar08_01_32_17.log (errors)                                                                                                                        
    Error at line 113749: sddvffnc: factor=Database_Hostname,error=ORA-06508: PL/SQL: could not find ......     

Reason:

     Patch 21555660 (Database PSU 12.1.0.2.5, Oracle JavaVM Component ) is not in place of CDB/PDBs. It needs outages to upgrade this OJVM to pass thorough.

     Check both CDB and PDBs for that as the component applies to each PDBs

    sql: select comp_name, version from  dba_registry where comp_name like   '%JAVA Virtual Machin%' and status = 'VALID';

Solution:

 Upgrade OJVM in CDB and PDBs if not in place. To make sure they are on the page.

No comments: