A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

PDB went in restricted mode in Oracle 19c

1 min read

Issue:

PDB went into restricted mode 

Investigation

su - oracle
export ORACLE_HOME=/u01/oracle/product/19/db
export ORACLE_SID= cp9494
$ORACLE_HOME/OPatch/datapatch -verbose

If you get INVALID object error, run the utlrp as below

cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -c P327 -b utlrp -d '''.''' utlrp.sql

There is a chance that the PDB will still be in restricted mode even after the datapatch is success.

In that case, please go with rolling bounce of database instance.

SYS user has the restricted access privilege so it will be able to connect to the database even if the PDB is in restricted mode.