Oracle 12.2 Database option XXX mismatch

打开刚创建的PDB告警：
[code]SQL> alter pluggable database pdb2 open;

Warning: PDB altered with errors.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY YES
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE YES[/code]
pdb此时以受限模式打开。

alert.log
[code]PDB2(4):***************************************************************
PDB2(4):WARNING: Pluggable Database PDB2 with pdb id - 4 is
PDB2(4): altered with errors or warnings. Please look into
PDB2(4): PDB_PLUG_IN_VIOLATIONS view for more details.
PDB2(4):***************************************************************

SQL> col NAME for a10
SQL> col cause for a10
SQL> col MESSAGE for a100
SQL> select name,cause,type,message,status from PDB_PLUG_IN_VIOLATIONs order by name;

NAME CAUSE TYPE MESSAGE STATUS
---------- ---------- --------- ---------------------------------------------------------------------------------------------------- ----------
PDB2 OPTION ERROR Database option XOQ mismatch: PDB installed version 12.2.0.1.0. CDB installed version NULL. PENDING
PDB2 OPTION ERROR Database option APS mismatch: PDB installed version 12.2.0.1.0. CDB installed version NULL. PENDING

SQL> col COMP_NAME for a40
SQL> select COMP_ID,comp_name, version, status from dba_registry;

COMP_ID COMP_NAME VERSION STATUS
------------------------------ ---------------------------------------- --------------- ----------
CATALOG Oracle Database Catalog Views 12.2.0.1.0 VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 VALID
XML Oracle XDK 12.2.0.1.0 VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 VALID
APS OLAP Analytic Workspace 12.2.0.1.0 OPTION OFF
RAC Oracle Real Application Clusters 12.2.0.1.0 OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 VALID
OWM Oracle Workspace Manager 12.2.0.1.0 VALID
CONTEXT Oracle Text 12.2.0.1.0 VALID
ORDIM Oracle Multimedia 12.2.0.1.0 VALID
SDO Spatial 12.2.0.1.0 VALID
XOQ Oracle OLAP API 12.2.0.1.0 OPTION OFF
OLS Oracle Label Security 12.2.0.1.0 VALID
APEX Oracle Application Express 5.0.4.00.12 VALID
DV Oracle Database Vault 12.2.0.1.0 VALID

16 rows selected.

SQL> select COMP_ID,comp_name, version, status from dba_registry;

COMP_ID COMP_NAME VERSION STATUS
------------------------------ ---------------------------------------- --------------- ----------
CATALOG Oracle Database Catalog Views 12.2.0.1.0 VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 VALID
XML Oracle XDK 12.2.0.1.0 VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 VALID
RAC Oracle Real Application Clusters 12.2.0.1.0 OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 VALID
OWM Oracle Workspace Manager 12.2.0.1.0 VALID
CONTEXT Oracle Text 12.2.0.1.0 VALID
ORDIM Oracle Multimedia 12.2.0.1.0 VALID
SDO Spatial 12.2.0.1.0 VALID
OLS Oracle Label Security 12.2.0.1.0 VALID
APEX Oracle Application Express 5.0.4.00.12 VALID
DV Oracle Database Vault 12.2.0.1.0 VALID

14 rows selected.[/code]
查询文档，pdb中的组件在cdb中没有，官方建议CDB添加这些组件，或者使用其他方式创建pdb：
However,
* Pluggable Database (PDB)
When you are creating a new PDB from the PDB$SEED, then OLAP will be automatically part of that new PDB as the seed contains all options.
If this is a subset, then the list will be adjusted based on the options installed in the CDB.
There is currently no support for the installation or removal of OLAP after the PDB has been created.

在CDB上添加OLAP相关组件
[code]sqlplus / as sysdba
@?/olap/admin/olap.sql SYSAUX TEMP

SQL> alter pluggable database pdb2 close;

Pluggable database altered.

SQL> alter pluggable database pdb2 open;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY YES
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE NO

SQL> select CON_ID,COMP_ID,STATUS,VERSION from cdb_registry where con_id=4;

CON_ID COMP_ID STATUS VERSION
---------- ------------------------------ ---------- ---------------
4 CATALOG VALID 12.2.0.1.0
4 CATPROC VALID 12.2.0.1.0
4 JAVAVM VALID 12.2.0.1.0
4 XML VALID 12.2.0.1.0
4 CATJAVA VALID 12.2.0.1.0
4 APS VALID 12.2.0.1.0
4 RAC OPTION OFF 12.2.0.1.0
4 XDB VALID 12.2.0.1.0
4 OWM VALID 12.2.0.1.0
4 CONTEXT VALID 12.2.0.1.0
4 ORDIM VALID 12.2.0.1.0
4 SDO VALID 12.2.0.1.0
4 XOQ VALID 12.2.0.1.0
4 OLS VALID 12.2.0.1.0
4 APEX VALID 5.0.4.00.12
4 DV VALID 12.2.0.1.0

SQL> select COMP_ID,STATUS,VERSION from dba_registry ;

COMP_ID STATUS VERSION
------------------------------ ---------- ---------------
CATALOG VALID 12.2.0.1.0
CATPROC VALID 12.2.0.1.0
JAVAVM VALID 12.2.0.1.0
XML VALID 12.2.0.1.0
CATJAVA VALID 12.2.0.1.0
APS VALID 12.2.0.1.0
RAC OPTION OFF 12.2.0.1.0
XDB VALID 12.2.0.1.0
OWM VALID 12.2.0.1.0
CONTEXT VALID 12.2.0.1.0
ORDIM VALID 12.2.0.1.0
SDO VALID 12.2.0.1.0
XOQ VALID 12.2.0.1.0
OLS VALID 12.2.0.1.0
APEX VALID 5.0.4.00.12
DV VALID 12.2.0.1.0

16 rows selected.[/code]
参考文档：
How to add Oracle OLAP to a 12c Database? (Doc ID 1936550.1)
"OPTION WARNING Database option mismatch: PDB installed version NULL" in PDB_PLUG_IN_VIOLATIONS (Doc ID 2020172.1)