From Root Container:
To change the open mode
of a pluggable database from the root container, do as follows:
$ sqlplus / as sysdba
SQL> alter pluggable
database salespdb open;
You can also start a
pluggable database in a particular state, such as read-only:
SQL> startup
pluggable database salespdb open read only;
To close a pluggable
database, you can specify the name of the pluggable database:
SQL> alter pluggable
database salespdb close immediate;
You can also open or
close all pluggable databases while connected to the root container as SYS:
SQL> alter pluggable
database all open;
SQL> alter pluggable
database all close immediate;
From Pluggable:
To open/start a
pluggable database, connect to the pluggable database as SYS:
$ sqlplus
sys/foo@salespdb as sysdba
SQL> startup;
To shut down the
database, issue the following command:
SQL> shutdown
immediate;
No comments:
Post a Comment