버전 비교

이전 버전 1

changes.mady.by.user 윤병훈

에 저장

비교대상

새 버전 2

changes.mady.by.user 윤병훈

에 저장

키

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.

ORACLE_SID 변경

코드 블럭
titleoracle 계정의 ORACLE_SID 변수 변경
linenumberstrue
export ORACLE_SID=emrepos

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

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

Database Template 다운로드 및 압축 해제

패널
titleDatabase Template 다운로드 위치

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

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

코드 블럭
languagebash
titleoracle 유저로 수행
linenumberstrue
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을 사용하면 됩니다.

 

DBCA로 Database 생성

코드 블럭
languagebash
titleoracle 유저로 실행
linenumberstrue
dbca

 

Image Added

 

Image Added

 

Image Added

 

Image Added

 

Image Added

 

Image Added

 

Image Added

 

Image Added

 

Image Added

펼치기

Image Added

Image Added

Image Added

Image Added

 

Image Added

 

Image Added

 

Image Added

 

Image Added

펼치기

Image Added

Image Added

 

Image Added

펼치기

Image Added

Image Added

 

Image Added