Error: Warning: PDB altered with errors.
Alert log: Error while rollback the patch in CDB database when we run the datapatch verbose command to rollback in database we left the PDB database in mount state that cause the following error:
During the datapatch we also got warning message that PDB database is not open.
datapatch -verbose
SQL Patching tool version 19.26.0.0.0 Production on Thu Jun 12 08:52:40 2025
Copyright (c) 2012, 2025, Oracle. All rights reserved.
Log file for this invocation: F:\Test\oracle19\cfgtoollogs\sqlpatch\sqlpatch_7364_2025_06_12_08_52_40\sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Warning: PDB RADB is in mode MOUNTED and will be skipped.
When we try to open the database PDB then it shows warning message
SQL> alter pluggable database RADB open;
Warning: PDB altered with errors.
In Alert log error display like that:
Violations: Type: 1, Count: 1
Violations: Type: 2, Count: 1
RADB(3):***************************************************************
RADB(3):WARNING: Pluggable Database RADB with pdb id - 3 is
RADB(3): altered with errors or warnings. Please look into
RADB(3): PDB_PLUG_IN_VIOLATIONS view for more details.
RADB(3):***************************************************************
RADB(3) Error Violation: SQL Patch, Cause: Interim patch 37102264/26088432 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264)): Not installed in the CDB but installed in the PDB, Action: Call datapatch to install in the PDB or the CDB
RADB(3):SUPLOG: Set PDB SUPLOG SGA at PDB OPEN, old 0x18, new 0x0 (no suplog)
2025-06-12T09:10:15.007585+00:00
RADB(3):Opening pdb with Resource Manager plan: DEFAULT_PLAN
RADB(3):joxcsys_required_dirobj_exists: directory object exists with required path F:\TEST\ORACLE19C\WINDOWS.X64_193000_DB_HOME\JAVAVM\ADMIN\, pid 8752 cid 3
Pluggable database RADB opened read write
Solution: We need to rerun the datapatch verbose command with open the pluggable database to fix the issue.
Run the datapatch -verbose after open the pluggable database.
datapatch -verbose
SQL Patching tool version 19.26.0.0.0 Production on Thu Jun 12 09:53:50 2025
Copyright (c) 2012, 2025, Oracle. All rights reserved.
Log file for this invocation: F:\Test\oracle19\cfgtoollogs\sqlpatch\sqlpatch_8056_2025_06_12_09_53_50\sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of interim SQL patches:
Interim patch 36414915 (OJVM RELEASE UPDATE: 19.24.0.0.240716 (36414915)):
Binary registry: Not installed
PDB CDB$ROOT: Not installed
PDB PDB$SEED: Not installed
PDB RADB: Not installed
Interim patch 36878697 (OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697)):
Binary registry: Not installed
PDB CDB$ROOT: Not installed
PDB PDB$SEED: Not installed
PDB RADB: Not installed
Interim patch 37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264)):
Binary registry: Not installed
PDB CDB$ROOT: Rolled back successfully on 12-JUN-25 08.55.42.679000 AM
PDB PDB$SEED: Rolled back successfully on 12-JUN-25 08.56.00.554000 AM
PDB RADB: Applied successfully on 26-MAY-25 02.14.22.740000 PM
Current state of release update SQL patches:
Binary registry:
19.26.0.0.0 Release_Update 250129014853: Installed
PDB CDB$ROOT:
Applied 19.26.0.0.0 Release_Update 250129014853 successfully on 26-MAY-25 02.06.43.717000 PM
PDB PDB$SEED:
Applied 19.26.0.0.0 Release_Update 250129014853 successfully on 26-MAY-25 02.19.43.150000 PM
PDB RADB:
Applied 19.26.0.0.0 Release_Update 250129014853 successfully on 26-MAY-25 02.19.43.150000 PM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
No interim patches need to be rolled back
No release update patches need to be installed
No interim patches need to be applied
For the following PDBs: RADB
The following interim patches will be rolled back:
37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264))
No release update patches need to be installed
No interim patches need to be applied
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...done
Patch 37102264 rollback (pdb RADB): SUCCESS
logfile: F:\Test\oracle19\cfgtoollogs\sqlpatch\37102264\26088432/37102264_rollback_RELIUS_RADB_2025Jun12_09_54_37.log (no errors)
SQL Patching tool complete on Thu Jun 12 09:54:52 2025