[oracle] create database

 

 

Creating a Container Database (CDB)

 

 

1. startup instance

 

2. create database

SQL > create database ...

 3.

한번에 생성

$ORACLE_HOME/rdbms/admin/ catcdb.sql 

 

or

$ORACLE_HOME/rdbms/admin/catalog.sql

$ORACLE_HOME/rdbms/admin/ catproc.sql : 오라클 제공 패키지 생성스크립트

 

 

 

 

 

Creating a CDB by Using a SQL Command: Example

 

 

1. 인스턴스 시작

1-a) 인스턴스이름 설정

Set ORACLE_SID=CDB1

1-b) 파라미터 설정

–  CONTROL_FILES to CDB control file names

– DB_NAME to a CDB name

– ENABLE_PLUGGABLE_DATABASE to TR

 

2. DB 생성

 SQL> 
 CREATE DATABASE cdb1  
 
USER SYS IDENTIFIED BY p1 USER SYSTEM IDENTIFIED BY p2 /*패스워드 설정 */

 LOGFILE GROUP 1 ('/u01/app/oradata/CDB1/redo1a.log', /* 로그파일 2개 생성 */
 '/u02/app/oradata/CDB1/redo1b.log') SIZE 100M,
 GROUP 2 ('/u01/app/oradata/CDB1/redo2a.log',
 '/u02/app/oradata/CDB1/redo2b.log') SIZE 100M 
 
CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16  

EXTENT MANAGEMENT LOCAL DATAFILE    /* ORACLE DATAFILE 만들 때 만드시 필요 */
'/u01/app/oradata/CDB1/system01.dbf' SIZE 325M 
SYSAUX DATAFILE  '/u01/app/oradata/CDB1/sysaux01.dbf' SIZE 325M 
DEFAULT TEMPORARY TABLESPACE tempts1 
TEMPFILE '/u01/app/oradata/CDB1/temp01.dbf' SIZE 20M 
UNDO TABLESPACE undotbs 
DATAFILE '/u01/app/oradata/CDB1/undotbs01.dbf' SIZE 200M

 ENABLE PLUGGABLE DATABASE /* CDB아키텍처 만들기 위해 꼭 필요 */
SEED FILE_NAME_CONVERT =('/u01/app/oradata/CDB1','/u01/app/oradata/CDB1/seed');
/* SEED는 SEED경로(/u01/app/oradata/CDB1/seed) 위치 지정
해당 옵션은 선택임. 옵션지정 말고 파라미터 OMF에 지정하면 ORACLE이 알아서 SEED생성 및 삭제 자동 관리해줌*/

 

 

3. Execute the $ORACLE_HOME/rdbms/admin/catcdb.sqlSQL script

$ORACLE_HOME/rdbms/admin/ catcdb.sql