Oracle silent mode Install

--엔진설치

./runInstaller -silent -debug -force \
FROM_LOCATION=/u01/software/database/stage/products.xml \
oracle.install.option=INSTALL_DB_SWONLY \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/u01/app/oraInventory \
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 \
ORACLE_HOME_NAME="OraDb11g_Home1" \
ORACLE_BASE=/u01/app/oracle \
oracle.install.db.InstallEdition=SE \
oracle.install.db.isCustomInstall=false \
oracle.install.db.DBA_GROUP=dba \
oracle.install.db.OPER_GROUP=dba \
DECLINE_SECURITY_UPDATES=true

-DB 생성

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname DEV -sid DEV -SystemPassword manager -SysPassword oracle -emConfiguration NONE -datafileDestination /app/oracle/oradata/dev -storageType FS -characterSet AL32UTF8 -redoLogFileSize 100 -automaticMemoryManagement False

-memoryPercentage 30

 -DB 삭제

dbca -silent -deleteDatabase -sourceDB DEV -sysDBAUserName sys -sysDBAPassword oracle

pfile 생성
(sga 수동,자동 여부확인 후 적용)
memory 사이즈 수정

process 수 수정

hidden parameter 적용

controlfile multiplexing
archive log 적용

shutdown
startup mount
아카이브 적용

open

undo table auto off
temp size 수정

listener, tnsname file 수정

백업스크립트 작성 및 적용