19c silent mode 설치 (dbca)

19c silent mode 설치

- Database S/W 설치 부분

이전에 있었던 

-showProgress

-ignoreSysPrereqs 옵션은 없어짐.

./runInstaller -silent -debug -force -waitforcompletion -ignorePrereqFailure \

oracle.install.option=INSTALL_DB_SWONLY \

UNIX_GROUP_NAME=dba \

ORACLE_HOME=/oracle/app/product/19.3.0 \

ORACLE_BASE=/oracle/app \

INVENTORY_LOCATION=/oracle/app/oraInventory

oracle.install.db.InstallEdition=EE \

oracle.install.db.isCustomInstall=false \

oracle.install.db.DBA_GROUP=dba \

oracle.install.db.OPER_GROUP=dba \

oracle.install.db.OSBACKUPDBA_GROUP=dba \

oracle.install.db.OSDGDBA_GROUP=dba \

oracle.install.db.OSKMDBA_GROUP=dba \

oracle.install.db.OSRACDBA_GROUP=dba \

DECLINE_SECURITY_UPDATES=true

- Database 생성하는 부분

1. New_Database.dbt 화일 수정

cp /oracle/app/oracle/product/19.3.0/assistants/dbca/templates/New_Database.dbt /oracle/app/oracle/product/19.3.0/assistants/dbca/templates/New_Database.dbt.bak

환경에 맞게 화일 위치 등 수정

vi /oracle/app/oracle/product/19.3.0/assistants/dbca/templates/New_Database.dbt

2. 디렉토리 생성

mkdir -p /oracle/app/admin/TEST/pfile

mkdir -p /oracle/app/admin/TEST/adump

3. dbca 수행

dbca -silent -createDatabase -templateName /oracle/app/oracle/product/19.3.0/assistants/dbca/templates/New_Database.dbt -gdbName TEST -sid TEST \

-sysPassword oracle -systemPassword oracle -createAsContainerDatabase false -characterSet AL32UTF8 -nationalCharacterSet UTF8 -totalMemory 2048

Prepare for db operation

5% complete

Creating and starting Oracle instance

6% complete

9% complete

Creating database files

10% complete

14% complete

Creating data dictionary views

15% complete

18% complete

19% complete

로그는 해당위치에서 확인 가능

/oracle/app/cfgtoollogs/dbca/TEST