[오라클]DB Slient 설치

DB Silent Mode 설치

export ORACLE_HOME=/oracle/product/10.2
export ORACLE_BASE=/oracle/product/10.2
export ORACLE_CD=/oracle/product/10.2

runInstaller [ Install ]
----------------------------------------------------------------------------------
필수 사항
=======================================================
export TMPDIR=$ORACLE_BASE/tmp
export TMP=$ORACLE_BASE/tmp
mkdir -p $ORACLE_BASE/tmp

export ORACLE_CD=$ORACLE_BASE
cp $ORACLE_CD/database/response/enterprise.rsp .

vi enterprise.rsp
------------------------------------------------------------------
UNIX_GROUP_NAME="dba"
FROM_LOCATION="/oracle/product/10.2/database/stage/products.xml"
ORACLE_BASE="/oracle/product/10.2"
ORACLE_HOME="/oracle/product/10.2"
ORACLE_HOME_NAME="OUIHome1"
INSTALL_TYPE="EE"
COMPONENT_LANGUAGES={"en","ko"}
n_configurationOption=false
=======================================================

export rsp=enterprise.rsp
cat $rsp | grep ^FROM_LOCATION=> $rsp.out
cat $rsp | grep ^ORACLE_HOME=>> $rsp.out
cat $rsp | grep ^ORACLE_HOME_NAME=>> $rsp.out
cat $rsp | grep ^INSTALL_TYPE=>> $rsp.out
cat $rsp | grep ^COMPONENT_LANGUAGES=>> $rsp.out
cat $rsp | grep ^UNIX_GROUP_NAME=>> $rsp.out
cat $rsp | grep ^n_configurationOption=>> $rsp.out
cat $rsp.out

설치
=====
$ORACLE_CD/database/runInstaller -silent -force -waitforcompletion \
-responseFile `pwd`/$rsp


runInstaller [ Patch ]
----------------------------------------------------------------------------------
필수 사항
=======================================================
export TMPDIR=$ORACLE_BASE/tmp
export TMP=$ORACLE_BASE/tmp
mkdir -p $ORACLE_BASE/tmp

export ORACLE_CD=$ORACLE_BASE
cp $ORACLE_CD/Disk1/response/patchset.rsp .

vi enterprise.rsp
------------------------------------------------------------------
UNIX_GROUP_NAME="dba"
FROM_LOCATION="/oracle/product/10.2/Disk1/stage/products.xml"
ORACLE_HOME="/oracle/product/10.2"
ORACLE_HOME_NAME="OUIHome1"
COMPONENT_LANGUAGES={"en","ko"}
11g의 경우 추가
----------------
b_acceptLicense=false
b_useRegistration=false
DECLINE_SECURITY_UPDATES=true
=======================================================

export rsp=patchset.rsp
cat $rsp | grep ^FROM_LOCATION=> $rsp.out
cat $rsp | grep ^ORACLE_HOME=>> $rsp.out
cat $rsp | grep ^ORACLE_HOME_NAME=>> $rsp.out
cat $rsp | grep ^COMPONENT_LANGUAGES=>> $rsp.out
cat $rsp | grep ^UNIX_GROUP_NAME=>> $rsp.out
cat $rsp.out

Patch
=====
$ORACLE_CD/Disk1/runInstaller -silent -force -responseFile `pwd`/$rsp

netca
----------------------------------------------------------------------------------
cp $ORACLE_CD/database/response/netca.rsp .
SHOW_GUI=false

netca /silent /responsefile netca.rsp
$ORACLE_HOME/bin/netca /silent /log /responseFile /data/oracle/media/database/response/netca.rsp
yum install libXp-1.0.0-8.i386.rpm
yum install libXp

dbca
----------------------------------------------------------------------------------
수정 파일: $ORACLE_HOME/assistants/dbca/templates/New_Database.dbt
< option name="SPATIAL" value="false"/>
< initParam name="sga_target" value="140" unit="MB"/>

export DB_UNIQUE_NAME=DB10
export ORACLE_BASE=/oracle

dbca -silent -createDatabase -templateName New_Database.dbt \
-gdbname DB10 -sid DB10 -sysPassword system -systemPassword system \
-datafileDestination /oradata
-recoveryAreaDestination /oradata/DB10/flash_recovery_area
[-characterSet KO16MSWIN949
-characterSet KO16KSC5601
-characterSet UTF-8 ]

dbca -silent -deleteDatabase -sourceDB DB10

dbca -silent -createDatabase -templateName New_Database.dbt \
-gdbname Ora10g -sid Ora10g -sysPassword qodzmxkdns -systemPassword qodzmxkdns \
-datafileDestination /data/oradata -recoveryAreaDestination /data/oradata/Ora10g/flash_recovery_area -characterSet AL16UTF8 -characterSet KO16KSC5601


10205/Disk1/runInstaller -silent -responseFile /HDHOSP/patch/Disk1/response/patchset.rsp
~~~~~~~~~~~~~~~~~~~~~~~~
INFO: The user has chosen to include the collector, but with the shiphomeinfo.properties value, is the collector included for configuration ? : true
INFO: The ORACLE_CONFIG_HOME env var is set to
INFO: The selected Home : /oracle/product/10.2 is selected for upgrade ? false
INFO: Setting the value of COLLECTOR_UPGRADE
INFO: Setting variable 'COLLECTOR_UPGRADE' to 'false'. Received the value from a code block.
INFO: Can we show the collector page ? true

SEVERE:Values for the following variables could not be obtained from the command line or response file(s):
MYORACLESUPPORT_USERNAME(MyOracleSupportUsername)
Silent install cannot continue.

조치
10205/Disk1/runInstaller -silent -responseFile /HDHOSP/patch/Disk1/response/patchset.rsp DECLINE_SECURITY_UPDATES=TRUE