신문지한장

[Tech][Multitenant] Oracle CDB&PDB add 및 open 본문

Oracle/Tech

[Tech][Multitenant] Oracle CDB&PDB add 및 open

신문지한장 2024. 9. 3. 09:11
OS : CentOS 7.9 (64bit)
DB : Oracle Database 19c ( Release - 19.3 )

 

1. 기존 PDB 확인

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO

 

 

2. datafile 확인

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATA/KEJPDB/DATAFILE/system.322.1150139621
+DATA/KEJPDB/DATAFILE/sysaux.323.1150139697
+DATA/KEJPDB/DATAFILE/undotbs1.324.1150139733
+DATA/KEJPDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.330.1150141383
+DATA/KEJPDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.331.1150141383
+DATA/KEJPDB/DATAFILE/users.325.1150139739
+DATA/KEJPDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.332.1150141383
+DATA/KEJPDB/DATAFILE/undotbs2.334.1150141875

8 rows selected.

 

 

3. CDB 생성

SQL> Create pluggable database truin admin user PDBUSR identified by PASSWORD;

 

 

4. CDB 생성 확인

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TRUIN                          MOUNTED

 

 

5. datafile 확인

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATA/KEJPDB/DATAFILE/system.322.1150139621
+DATA/KEJPDB/DATAFILE/sysaux.323.1150139697
+DATA/KEJPDB/DATAFILE/undotbs1.324.1150139733
+DATA/KEJPDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.330.1150141383
+DATA/KEJPDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.331.1150141383
+DATA/KEJPDB/DATAFILE/users.325.1150139739
+DATA/KEJPDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.332.1150141383
+DATA/KEJPDB/DATAFILE/undotbs2.334.1150141875
+DATA/KEJPDB/079872EF8C041FCDE0636500A8C0CAEA/DATAFILE/system.339.1150144515
+DATA/KEJPDB/079872EF8C041FCDE0636500A8C0CAEA/DATAFILE/sysaux.340.1150144515
+DATA/KEJPDB/079872EF8C041FCDE0636500A8C0CAEA/DATAFILE/undotbs1.338.1150144515

11 rows selected.

 

 

6. pdb open

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TRUIN                          MOUNTED
SQL> alter pluggable database truin open;

Pluggable database altered.
SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TRUIN                          READ WRITE NO

'Oracle > Tech' 카테고리의 다른 글

[Tech] Oracle 데이터베이스 구조 확인 딕셔너리뷰  (0) 2024.09.13
[Tech][Multitenant] 유저 생성시 C## 안붙이고 생성하는 방법 & 히든파라미터 조회 sql(파라미터 변경)  (1) 2024.09.03
[Tech] oracle profile  (0) 2024.08.05
[Tech] oracle awr snapshot 주기확인 및 변경  (0) 2024.08.05
[Tech] oracle 12c 미지원 파라미터  (0) 2024.05.23
'Oracle/Tech' Related Articles more