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
