1 DB 생성

1.1 Silent mod 생성

 1) response file 생성

  (1) default response file 복사

(ORCL)[oracle@db-sv:~:$] cp $ORACLE_HOME/assistants/dbca/dbca.rsp ~/dbca_initial.rsp

  (2) response file 수정

(ORCL)[oracle@db-sv:~:$] vi dbca_initial.rsp
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0
gdbName=
ORCL
sid=
ORCL
databaseConfigType=
SI
policyManaged=
false
createServerPool=
false
createAsContainerDatabase=
false
numberOfPDBs=
0
useLocalUndoForPDBs=
true
templateName=
/u01/app/oracle/product/19c/dbhome_1/assistants/dbca/templates/New_Database.dbt
sysPassword=
#< password 입력
systemPassword=
#< password 입력
runCVUChecks=FALSE
dvConfiguration=
false
olsConfiguration=
false
datafileDestination=
/oradata/{DB_UNIQUE_NAME}/
storageType=
FS
characterSet=
AL32UTF8
nationalCharacterSet=
AL16UTF16
registerWithDirService=false
listeners=
LISTENER
skipListenerRegistration=
false
variablesFile=
variables=
ORACLE_BASE_HOME=/u01/app/oracle/product/19c/dbhome_1,DB_UNIQUE_NAME=ORCL,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=ORCL,ORACLE_HOME=/u01/app/oracle/product/19c/dbhome_1,SID=ORCL
initParams=undo_tablespace=UNDOTBS1,sga_target=4746MB,db_block_size=8192BYTES,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=ORCLXDB),diagnostic_dest={ORACLE_BASE},control_files=("/oradata/{DB_UNIQUE_NAME}/control01.ctl", "/oradata/{DB_UNIQUE_NAME}/control02.ctl"),remote_login_passwordfile=EXCLUSIVE,audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,processes=1280,pga_aggregate_target=1583MB,nls_territory=AMERICA,local_listener=LISTENER_ORCL,open_cursors=300,compatible=19.0.0,db_name=ORCL,audit_trail=db
sampleSchema=
false
memoryPercentage=
40
databaseType=
MULTIPURPOSE
automaticMemoryManagement=
false
totalMemory=
0

 2) DB 생성

(ORCL)[oracle@db-sv:~:$] dbca -silent -createDatabase -responseFile ~/dbca_initial.rsp

1.2 GUI 사용

 1) DB 생성 프로세스 기동

(ORCL)[oracle@db-sv:~:$] dbca

 2) DB 생성

  (1) 작업 유형 선택

  (2) DB 생성 모드 선택

  (3) DB 배포 유형 선택

  (4) SID 등록

  (5) DB Data 저장소 등록

  (6) Fast Recovery 옵션 선택

Flash Disk를 보유한 경우에는 선택하고 그렇지 않으면 Pass 한다

  (7) 리스너 등록

  (8) DB 옵션 선택

  (9) SGA, PGA 용량 등록

  (10) character set 등록

  (11) connection mode 선택

  (12) Enterprise Manager 등록(유료)

  (13) SYS, SYSTEM 계정 패스워드 등록

  (14) DB 생성 옵션 선택

  (15) 설정 내용 검토 및 Response file 저장(향후 유지보수를 위해 저장 권장)

  (16) 설치 완료