Datapatch Failing on ORA-65108 (PDB$SEED): Applying Datapatch Manually

ORA-00704: bootstrap process failure
 ORA-00604: error occurred at recursive SQL level 1
 ORA-65108: invalid use of a cursor belonging to another container
 kpdbaKillPdbSessions: Starting kill.
 2019-01-29 07:09:21.486584 :kjcipctxinit(): (pid|psn)=(25|2): initialised and linked pctx 0x00007FFB1A7B49C8 into process list
 ORA-00704: bootstrap process failure
 ORA-00604: error occurred at recursive SQL level 1
 ORA-65108: invalid use of a cursor belonging to another container

1. First, apply the datapatch to other PDBs using the -pdbs clause:

   ./datapatch -verbose -pdbs PDB1,PDB2

2. Open PDB$SEED for Oracle scripts:

   SYS@CDB$ROOT SQL> alter session set "_oracle_script"=true; 
    Session altered. 
    SYS@CDB$ROOT SQL> alter pluggable database pdb$seed open read write force; 
    Pluggable database PDB$SEED altered.

3. Apply the datapatch to the PDB$SEED:

   $ORACLE_HOME/OPatch/datapatch -verbose -pdbs ‘PDB$SEED’

4. Close PDB$SEED and mount it:

   SYS@CDB$ROOT SQL> alter session set container=PDB$SEED 
    Session altered. 
    SYS@CDB$ROOT SQL> shutdown immediate 
    Pluggable Database closed 
    ++ From Root 
    SYS@CDB$ROOT SQL> alter pluggable database PDB$SEED open read only;

I hope it helps, cheers!

Oracle Database Consulting Services

Ready to optimize your Oracle Database for the future?