oracle 12c 初步操作
阅读原文时间:2023年07月08日阅读:1

查看是否为cdb

SQL> select name,cdb,open_mode,con_id from v$database;

NAME CDB OPEN_MODE CON_ID


ORCL12C YES READ WRITE 0

查看当前容器

SQL> show con_name

CON_NAME

CDB$ROOT

查看有多少个PDB

SQL> select con_id, dbid, guid, name , open_mode from v$pdbs;

CON\_ID       DBID GUID                                             NAME                         OPEN\_MODE  

     2 4096928455 FF675156E40B2F3DE043B303A8C00283                 PDB$SEED                     READ ONLY  
     3 2301438674 FF6761430B3E311EE043B303A8C00BA6                 PDBORCL                      READ WRITE

关闭PDB

SQL> alter session set container=PDBORCL;

Session altered.

SQL> shutdown immediate
Pluggable Database closed.
SQL> show con_name

CON_NAME

PDBORCL
SQL> alter session set container=CDB$ROOT;

Session altered.

SQL> select con_id, dbid, guid, name , open_mode from v$pdbs;

CON\_ID       DBID GUID                                             NAME                         OPEN\_MODE  

     2 4096928455 FF675156E40B2F3DE043B303A8C00283                 PDB$SEED                     READ ONLY  
     3 2301438674 FF6761430B3E311EE043B303A8C00BA6                 PDBORCL                      MOUNTED

启动PDB

SQL> alter session set container=PDBORCL;

Session altered.

SQL> STARTUP
Pluggable Database opened.

进入PDB做一些日常操作

SQL> select FILE_NAME,TABLESPACE_NAME ,file_id from dba_data_files;

FILE_NAME TABLESPACE_NAME FILE_ID


/u01/app/oracle/oradata/orcl12c/pdborcl/example01.dbf EXAMPLE 11
/u01/app/oracle/oradata/orcl12c/pdborcl/SAMPLE_SCHEMA_users01.dbf USERS 10
/u01/app/oracle/oradata/orcl12c/pdborcl/sysaux01.dbf SYSAUX 9
/u01/app/oracle/oradata/orcl12c/pdborcl/system01.dbf SYSTEM 8

创建PDB

SQL> CREATE PLUGGABLE DATABASE pdbtest1 ADMIN USER pdbtest1admin IDENTIFIED BY pdbtest1admin
2 STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)
3 DEFAULT TABLESPACE test1tb1
4 DATAFILE '/u01/app/oracle/oradata/orcl12c/pdbtest1/test1tb101.dbf' size 50m autoextend off
5 FILE_NAME_CONVERT =('/u01/app/oracle/oradata/orcl12c/pdbseed','/u01/app/oracle/oradata/orcl12c/pdbtest1');

Pluggable database created.