Hi !
Can someone help me please
i have un issue , am connecting as oracle user in oracle 19 c
and when make : show pdbs ;
it lists all my databases but they are all in restricted mode
i tried to do the following sql order for several times but it doesn't work :
alter system disable restricted session;
thank you in advance
Hi!
1
Connect to the desired pdb first in order to use alter system disable restricted session;
SQL> show con_name;
CON_NAME ------------------------ CDB$ROOT
SQL> alter session set container = yourpdbname;
Session Altered;
alter system disable restricted session;
2
You can open pdb from cdb like this;
SQL> alter pluggable database YOURPDBNAME open force;
Pluggable database altered.
------------------------------------
https://logic.edchen.org/how-oracle-disable-pdb-restricted-mode/