BE SHARING

temporary tablespace

Temporary tablespace and ODA 19.31.

11.06.2026 by Clemens Bleile

I recently patched Oracle Database Appliances (ODAs) to 19.31. For DBs with more than 1 tempfile in the temporary tablespace I got an error during the “odacli update-dbhome” : # odacli describe-job -i 2ff3fd5d-f611-4ae6-aae0-63df7c08ec71 Job details ---------------------------------------------------------------- ID: 2ff3fd5d-f611-4ae6-aae0-63df7c08ec71(…)

Oracle

datapatch fails when running against an Oracle Container Database because of missing temp files in PDBs

03.08.2022 by Clemens Bleile

When going to 19.15. a customer hit this error when running datapatch: Unsupported named object type for bind parameter at /u01/app/oracle/product/19.0.0.0/dbhome1915/sqlpatch/sqlpatch.pm line 5849, line 4452. After anlyzing the issue it turned out to be related to what(…)