二、Oracle12c中的CDB与PDB

2024年1月12日发(作者：)

SQL> selectname,open_mode,block_size from v$pdbs;

NAME OPEN_MODE BLOCK_SIZE---------------------------------------- ----------PDB$SEED READ ONLY 8192PDB_1 READ WRITE 8192

关闭PDB_1，再查看状态：

SQL> alterpluggable database pdb_1 close immediate;

Pluggabledatabase altered.

SQL> selectname,open_mode from v$pdbs;

NAME OPEN_MODE----------------------------------------PDB$SEED READ ONLYPDB_1 MOUNTED

看到close后，PDB_1状态为MOUNTED。

再次打开PDB_1:

SQL> alterpluggable database pdb_1 open;

Pluggabledatabase altered.

6.3 连接PDB

服务器上添加tns：

PDB_1 =