PDB went in restricted mode in Oracle 19c
1 min readIssue:
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.