Thursday, March 8, 2018

How to install oracle database 12c using response file.

I. Pre-Database installation tasks:

1. Create the directories in which the Oracle software will be installed


Logon as user oracle on both nodes:
mkdir -p /u01/app/oracle/product/12.2.0.1/dbhome_1

2. Set environment for user oracle

Add following to $HOME/.bash_profile
# Oracle Settings
export TMP=/tmp
export TMPDIR=\$TMP

export ORACLE_HOSTNAME=node1.com
export ORACLE_UNQNAME=TEST12C2
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/12.2/dbhome_1
export ORACLE_SID=TEST12C2

export PATH=/usr/sbin:/usr/local/bin:\$PATH
export PATH=\$ORACLE_HOME/bin:\$PATH

export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib


II. Install 12c Database software 
Logon as user oracle

1. Make a copy of the 12c software install response file. I created one already which i will copy. 
cp /softwarelocationresponsefile/12c2/scripts/12cR2_sw.rsp 12cR2_sw_<clustername>.rsp
2. Edit <clustername>.rsp to make sure following parameter are using correct values for your cluster:
oracle.install.db.CLUSTER_NODES=


3. Install 12c DB software
#>cd /gg_nas1/software/oracle/12c2/database

./runInstaller –showProgress -silent -responseFile /softwarelocationresponsefile/12c2/scripts/12cR2_sw_<clustername>.rsp


4. Quick binary verification
#> sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 25 19:30:44 2017
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to an idle instance.
SQL>



III. Create 12c Database
Logon as user oracle

1. Make a copy of the 12c database creation response file
#> cp softwarelocationresponsefile/12c2/scripts/12c_dbca.rsp 12c_dbca_<dbname>.rsp

2. Edit  softwarelocationresponsefile/12c2/scripts/12c_dbca_<dbname>.rsp file to make sure following parameter are using correct values for your cluster
gdbName=
sid=
nodelist=
templateName=
sysPassword=
systemPassword=
datafileDestination=
recoveryAreaDestination=
diskGroupName=
recoveryGroupName=
listeners=
variables=
initParams=


3. Using DBCA to create the database
#>cd $ORACLE_HOME/bin
dbca  -silent -createDatabase -responseFile softwarelocationresponsefile/12c2/scripts/12c_dbca_<dbname>.rsp


4. Quick verify the database
#>$ORACLE_HOME/bin/srvctl status database –d xxxxx 

No comments:

Post a Comment