이 페이지의 이전 버전을 보고 있습니다. 현재 버전 보기.

현재와 비교 페이지 이력 보기

« 이전 버전 3 현재 »

1. ORACLE_SID 변경

oracle 계정의 ORACLE_SID 변수 변경
export ORACLE_SID=emrepos

Enterprise Manager의 저장소(Repository)에 맞게 ORACLE_SID를 수정합니다.

dbca를 수행할 명령창에서 임시로 변경하거나 .bash_profile을 수정하여 영구적으로 변경합니다.

2. Database Template 다운로드 및 압축 해제

Database Template 다운로드 위치

https://www.oracle.com/technetwork/oem/enterprise-manager/downloads/dbtemplates-5043300.html

라이센스 동의(Accept License Agreement) 후에 Database 버전, Multitenant 여부 및 OS 종류를 고려하여 파일 다운로드

oracle 유저로 수행
unzip <다운로드 경로>/18.1.0.0.0_Database_Template_for_EM13_3_0_0_0_Linux_x64.zip -d $ORACLE_HOME/assistants/dbca/templates
ls $ORACLE_HOME/assistants/dbca/templates
[oracle@emrepos ~]$ unzip /media/sf_oracle/18.3/18.1.0.0.0_Database_Template_for_EM13_3_0_0_0_Linux_x64.zip -d $ORACLE_HOME/assistants/dbca/templates
Archive:  /media/sf_oracle/18.3/18.1.0.0.0_Database_Template_for_EM13_3_0_0_0_Linux_x64.zip
  inflating: /u01/app/oracle/product/18.3.0/db_1/assistants/dbca/templates/set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Large_deployment.sql
  inflating: /u01/app/oracle/product/18.3.0/db_1/assistants/dbca/templates/set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Medium_deployment.sql
  inflating: /u01/app/oracle/product/18.3.0/db_1/assistants/dbca/templates/set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Small_deployment.sql
  inflating: /u01/app/oracle/product/18.3.0/db_1/assistants/dbca/templates/shpool_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0.sql
  inflating: /u01/app/oracle/product/18.3.0/db_1/assistants/dbca/templates/18_1_0_0_0_Database_Template_for_EM13_3_0_0_0_Large_deployment.dbc
  inflating: /u01/app/oracle/product/18.3.0/db_1/assistants/dbca/templates/18_1_0_0_0_Database_Template_for_EM13_3_0_0_0_Medium_deployment.dbc
  inflating: /u01/app/oracle/product/18.3.0/db_1/assistants/dbca/templates/18_1_0_0_0_Database_Template_for_EM13_3_0_0_0_Small_deployment.dbc
  inflating: /u01/app/oracle/product/18.3.0/db_1/assistants/dbca/templates/18_1_0_0_0_Database_Template_for_EM13_3_0_0_0.dfb
  inflating: /u01/app/oracle/product/18.3.0/db_1/assistants/dbca/templates/18_1_0_0_0_Database_Template_for_EM13_3_0_0_0.ctl

[oracle@emrepos ~]$ ls $ORACLE_HOME/assistants/dbca/templates
18_1_0_0_0_Database_Template_for_EM13_3_0_0_0.ctl
18_1_0_0_0_Database_Template_for_EM13_3_0_0_0.dfb
18_1_0_0_0_Database_Template_for_EM13_3_0_0_0_Large_deployment.dbc
18_1_0_0_0_Database_Template_for_EM13_3_0_0_0_Medium_deployment.dbc
18_1_0_0_0_Database_Template_for_EM13_3_0_0_0_Small_deployment.dbc
Data_Warehouse.dbc
General_Purpose.dbc
New_Database.dbt
Seed_Database.ctl
Seed_Database.dfb
pdbseed.dfb
pdbseed.xml
set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Large_deployment.sql
set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Medium_deployment.sql
set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Small_deployment.sql
shpool_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0.sql

사전에 구성된 Repository Template를 다운로드 받아서 사용할 수 있습니다.

Database 18c R3은 18.1.0.0.0 DB Templates을 사용하면 됩니다.

 

3. DBCA로 Database 생성

oracle 유저로 실행
dbca

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • 레이블 없음