I have applied patch 19.7 on top of 19.5. After that I'm getting error when try to open pluggable database as follows:
> sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Nov 15 16:25:19 2024
Version 19.7.0.0.0
SQL> connect / as sysdba
Connected.
SQL> alter pluggable database all open;
Warning: PDB altered with errors.
SQL> SELECT con_id, name, restricted FROM v$pdbs;
CON_ID NAME RES
---------- ---------- ---
2 PDB$SEED YES
3 PDB YES
SQL> SELECT * FROM pdb_plug_in_violations;
TIME NAME CAUSE TYPE ERROR_NUMBER LINE MESSAGE STATUS ACTION CON_ID
------------------------- ---------- ---------- ---------- ------------ ---------- ------------------------------ --------- ------------------------------ ----------
15-NOV-24 04.19.13.468000 PDB$SEED OPTION ERROR 0 1 Database option SDO mismatch: PENDING Fix the database option in the
2
PM PDB installed version 19.0.0.0 PDB or the CDB
.0. CDB installed version NULL
.
15-NOV-24 04.32.53.411000 PDB OPTION ERROR 0 1 Database option SDO mismatch: PENDING Fix the database option in the
3
PM PDB installed version 19.0.0.0 PDB or the CDB
.0. CDB installed version NULL
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
-- SDO option is 'Spatial' then:
SQL> select * from v$option where parameter='Spatial';
PARAMETER VALUE CON_ID
------------------------- ---------- ----------
Spatial FALSE 0
SQL> alter session set container=pdb;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDB
SQL> select * from v$option where parameter='Spatial';
PARAMETER VALUE CON_ID
------------------------- ---------- ----------
Spatial FALSE 0
From above looks like Spatial is turned off on both CDB and PDB. Why I'm getting the error that it is enabled on PDB and PDB$SEED then? I do not understand the output.