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.

1 comment:

b6zu5nfopv said...

It is used extensively within the engineering industry, significantly for prototyping and creating lightweight geometries. In March 2014, surgeons in Swansea used 3D printed components to rebuild the face of a motorcyclist who had been seriously injured in a street accident. In May 2018, 3D printing has been used for the kidney transplant to save of|to keep away from wasting} a three-year-old boy. As of 2012, 3D bio-printing expertise has been studied by biotechnology firms liberrway stylus pen and academia for possible use in tissue engineering applications by which organs and physique components are built utilizing inkjet printing methods. In this course of, layers of residing cells are deposited onto a gel medium or sugar matrix and slowly built as much as} type three-dimensional structures together with vascular techniques. Recently, a heart-on-chip has been created which matches properties of cells.