Tuesday, March 06, 2018

Datapatch CDB / PDB hits ORA-01652 Error

Symptom:

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

     It reports
      DBD::Oracle::st bind_param failed: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Reason:

     Datapatch is expected to patch all open PDBs in the CDB which includes PDB$SEED. Our application based PDBs are with enough TEMP . Unfortunately  PDB$SEED does not have much by default

Solution:

     Login PDB$SEED ,add 500m tempfile manually.

No comments: