oracle 12c 初步操作

標籤：style   blog   color   os   io   art   ar   div   

查看是否為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_nameCON_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 immediatePluggable Database closed.SQL> show con_nameCON_NAME------------------------------PDBORCLSQL> 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> STARTUPPluggable 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.