The PDB is in Restricted Mode due to an XML version mismatch: PDB version 19.0.0.0.0, CDB version NULL.
(Doc ID 3051091.1)
Last updated on OCTOBER 03, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterOracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/A
Information in this document applies to any platform.
Symptoms
An error is encountered when executing the query below:
SQL> column status format a9
SQL> column type format a9
SQL> column con_id format 9
SQL> select con_id, type, message, status from PDB_PLUG_IN_VIOLATIONS where status<>'RESOLVED' order by time;
ERROR Database option XML mismatch: PDB installed version 19.0.0.0.0. CDB installed version NULL.
When verifying the PDB status
CON_ID CON_NAME OPEN MODE RESTRICTED
1 PDB123 READ WRITE YES
Based on the DBA_REGISTRY output from CDB$ROOT
SQL> alter session set container=CDB$ROOT;
Session altered.
SQL> col comp_id for a12
SQL> col version for a15
SQL> col Comp_Name for a40
SQL> col status for a10
SQL> SELECT substr(comp_id,1,12)Comp_ID, Status,substr(Version,1,10)Version,substr(Comp_Name,1,40)Comp_Name FROM DBA_Registry ORDER by 1,2;
COMP_ID STATUS VERSION COMP_NAME
------------ ---------- --------------- ----------------------------------------
APS VALID 19.0.0.0.0 OLAP Analytic Workspace
CATALOG VALID 19.0.0.0.0 Oracle Database Catalog Views
CATPROC VALID 19.0.0.0.0 Oracle Database Packages and Types
CONTEXT VALID 19.0.0.0.0 Oracle Text
DV VALID 19.0.0.0.0 Oracle Database Vault
JAVAVM VALID 19.0.0.0.0 JServer JAVA Virtual Machine
OLS VALID 19.0.0.0.0 Oracle Label Security
OWM VALID 19.0.0.0.0 Oracle Workspace Manager
RAC OPTION OFF 19.0.0.0.0 Oracle Real Application Clusters
SDO VALID 19.0.0.0.0 Spatial
XDB VALID 19.0.0.0.0 Oracle XML Database
XOQ VALID 19.0.0.0.0 Oracle OLAP API
13 rows selected. >>>XDK not Installed in CDB<<<
According to the DBA_REGISTRY output from PDB123
SQL> alter session set container=PDB123;
Session altered.
SQL> col comp_id for a12
SQL> col version for a15
SQL> col Comp_Name for a40
SQL> col status for a10
SQL> SELECT substr(comp_id,1,12)Comp_ID, Status,substr(Version,1,10)Version,substr(Comp_Name,1,40)Comp_Name FROM DBA_Registry ORDER by 1,2;
COMP_ID STATUS VERSION COMP_NAME
------------ ---------- --------------- ----------------------------------------
APS VALID 19.0.0.0.0 OLAP Analytic Workspace
CATALOG VALID 19.0.0.0.0 Oracle Database Catalog Views
CATJAVA VALID 19.0.0.0.0 Oracle Database Java Packages
COMP_ID STATUS VERSION COMP_NAME
------------ ---------- --------------- ----------------------------------------
CATPROC VALID 19.0.0.0.0 Oracle Database Packages and Types
CONTEXT VALID 19.0.0.0.0 Oracle Text
DV VALID 19.0.0.0.0 Oracle Database Vault
COMP_ID STATUS VERSION COMP_NAME
------------ ---------- --------------- ----------------------------------------
JAVAVM VALID 19.0.0.0.0 JServer JAVA Virtual Machine
OLS VALID 19.0.0.0.0 Oracle Label Security
OWM VALID 19.0.0.0.0 Oracle Workspace Manager
COMP_ID STATUS VERSION COMP_NAME
------------ ---------- --------------- ----------------------------------------
RAC OPTION OFF 19.0.0.0.0 Oracle Real Application Clusters
SDO VALID 19.0.0.0.0 Spatial
XDB VALID 19.0.0.0.0 Oracle XML Database
COMP_ID STATUS VERSION COMP_NAME
------------ ---------- --------------- ----------------------------------------
XML VALID 19.0.0.0.0 Oracle XDK >>> XDK Installed in PDB <<<
XOQ VALID 19.0.0.0.0 Oracle OLAP API
14 rows selected.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |