A few times the database components will be in upgraded mode in the PDB once you have completed your database upgrade from 12c to version 19c.
column comp_name format a30
column status format a10
select comp_name, version, status from dba_registry;
COMP_NAME VERSION STATUS
-------------------------------- ------------------ ----------
Oracle Database Catalog Views 19.0.0.0.0 UPGRADED
Oracle Database Packages and Types 19.0.0.0.0 UPGRADED
JServer JAVA Virtual Machine 19.0.0.0.0 UPGRADED
Oracle XDK 19.0.0.0.0 UPGRADED
Oracle Database Java Packages 19.0.0.0.0 UPGRADED
SYS@sajiddb1>alter session set "_oracle_script"=TRUE;
session altered
SYS@sajiddb1>alter pluggable database pdb$seed close immediate instances=all;
Pluggable database altered.
SYS@sajiddb1>alter pluggable database pdb$seed OPEN READ WRITE force;
Pluggable database altered.
SYS@sajiddb1>alter session set container=PDB$SEED;
session altered
To resolve it follow the below steps.
@ORACLE_HOME/rdbms/admin/catalog.sql
@ORACLE_HOME/rdbms/admin/catproc.sql
@ORACLE_HOME/rdbms/admin/utlrp.sql
Check the components, it will be normal now.
SYS@sajiddb1>alter pluggable database pdb$seed close immediate instances=all;
Pluggable database altered.
SYS@sajiddb1>alter pluggable database pdb$seed OPEN READ ONLY force;
Pluggable database altered.
SYS@sajiddb1>show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
------ ------------ ----------- ------------
2 PDB$SEED READ ONLY NO
SYS@sajiddb1>alter session set "_oracle_script"=FALSE;
session altered
column comp_name format a30
column status format a10
select comp_name, version, status from dba_registry;
COMP_NAME VERSION STATUS
-------------------------------- ---------------- ----------
Oracle Database Catalog Views 19.0.0.0.0 VALID
Oracle Database Packages and Types 19.0.0.0.0 VALID
JServer JAVA Virtual Machine 19.0.0.0.0 VALID
Oracle XDK 19.0.0.0.0 VALID
Oracle Database Java Packages 19.0.0.0.0 VALID
No comments:
Post a Comment