How to enable and disable restricted mode of pluggable database in Oracle

Leave a reply

Enable and disable restricted mode of Pluggable database in Oracle

SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED
     2 PDB$SEED                       READ ONLY  NO
     3 XEPDB1                         READ WRITE N
SQL>
SQL> alter pluggable database xepdb1 open restricted force;
Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED
     2 PDB$SEED                       READ ONLY  NO
     3 XEPDB1                         READ WRITE YES

SQL> alter pluggable database xepdb1 close;

Pluggable database altered.

SQL> alter pluggable database xepdb1 open restricted;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED






			

				

					
				

			

					

		
		

			This entry was posted in Oracle on  by .										

					

						Unknown's avatar					

					

						

						About SandeepSingh						

						
Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc
Worked as a Development and Database Administrator.

						

							
						

					

				

					

	


				

				



	
	
		

		
Leave a Reply