Saucepan

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
======Install Oracle 11gR2======

This page shows how to install 64bit Oracle 11gR2 SP3 on CentOS 6 64bit.

=====Prerequisites=====
You must have a CentOS machine already set up in accordance with the [[linux:install_centos6|Install CentOS 6]] guide.

It is assumed that the system has a blank 80G+ disk attached to it at /dev/sdc.

====Download Installers====
For this guide, we assume that installer has been downloaded and is in <code>/tmp</code> such that the following exists '\\fileserver\setups\Oracle\database\runInstaller'. We mount this directly on to the machine so we shouldn't have to download anything. However, just in case the installation files have been deleted, this is how you can get them back.

You need to have downloaded the Oracle Database installation files for Linux x64. The account you use to log into the Oracle network (if prompted).
  * You can download Oracle Database 11g Release 2 (11.2.0.1.0) from [http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html here].
  * Main Oracle Database download page is [http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html here].

=====Preparation=====
We need to prepare the machine to have Oracle installed. We assume that a 110GB disk has been added to the system at /dev/sdc (sda is the system disk and sdb is the swap space disk).

Unless otherwise specified, the following should be run as the root user.

====Install Prerequisite Software====
Oracle 11gR2 requires the following software packages to be installed on CentOS 6.4.
<code>yum -y install \
compat-libstdc++* gcc-c++ ksh elfutils-libelf-devel libaio-devel  \
unixODBC unixODBC-devel libaio.i686 libaio-devel.i686 libgcc.i686 \
libstdc++.i686 libstdc++-devel libstdc++-devel.i686 unixODBC.i686 \
unixODBC-devel.i686 xdpyinfo</code>

====Create User and Groups====
Create user 'oracle' and appropriate groups.
  * oinstall (group) 200 - The Oracle Inventory group
  * dba (group) - 201 - The OSDBA group 
  * oper (group) - 202 - The OSOPER group 
  * oracle (user) - 440 - The Oracle software owner
<code>groupadd oinstall -g 200
groupadd dba -g 201
groupadd oper -g 202
useradd -g oinstall -G dba,oper -u 440 oracle</code>

Set the password for the user 'oracle'.
<code>passwd oracle</code>

====Set Kernel Parameters====
<code>cat << EOF >> /etc/sysctl.conf

  - Set to meet install requirements of Oracle 11gR2
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
EOF</code>

Tell the kernel to re-read the kernel parameter configuration file.
<code>sysctl -p</code>

====Set Shell Limits====
Increase the shell limits for the oracle user to improve the performance of the software.
<code>cat << EOF >> /etc/security/limits.conf
oracle           soft    nproc   2047
oracle           hard    nproc   16384
oracle           soft    nofile  1024
oracle           hard    nofile  65536
EOF</code>

====Configure PAM====
Modify PAM configuration
<code>cat << EOF >> /etc/pam.d/login
session    required     pam_limits.so
EOF</code>

====Edit Profile Scripts====
Tweak the default profile script.
<code>cat << EOF >> /etc/profile
if [ $USER = "oracle" ]; then
        if [ $SHELL = "/bin/ksh" ]; then
              ulimit -p 16384
              ulimit -n 65536
        else
              ulimit -u 16384 -n 65536
        fi
fi
EOF</code>

Ensure the 'oracle' user bash scripts can run
<code>chmod u+x ~oracle/.bash_profile
chmod u+x ~oracle/.bash_logout
chmod u+x ~oracle/.bashrc</code>
Set 'oracle' user default umask
<code>cat << EOF >> ~oracle/.bashrc
umask 022
EOF</code>

Edit the Bash profile for the Oracle user.
<code>FILENAME=~oracle/.bash_profile
echo "" >> $FILENAME
echo "# Oracle Settings" >> $FILENAME
echo "TMP=/tmp; export TMP" >> $FILENAME
echo "ORACLE_UNQNAME=database; export ORACLE_UNQNAME" >> $FILENAME
echo "ORACLE_BASE=/oracle/base; export ORACLE_BASE" >> $FILENAME
echo "ORACLE_HOME=\$ORACLE_BASE/home; export ORACLE_HOME" >> $FILENAME
echo "ORACLE_SID=sidney; export ORACLE_SID" >> $FILENAME
echo "ORACLE_TERM=xterm; export ORACLE_TERM" >> $FILENAME
echo "PATH=/usr/sbin:\$PATH:\$ORACLE_HOME/bin; export PATH" >> $FILENAME</code>

====Setup Oracle Disk====
Now we setup the extra disk (/dev/sdc).
<code># Create a new physical volume
pvcreate /dev/sdc

  - Create a new volume group.
vgcreate datavg /dev/sdc

  - Create the needed logical volumes.
lvcreate -L 6G -n base datavg
lvcreate -L 60G -n data datavg
lvcreate -L 8300 -n recovery datavg
lvcreate -L 75 -n inventory datavg

  - Format the newly created logical volumes.
mkfs -t ext4 /dev/mapper/datavg-base
mkfs -t ext4 /dev/mapper/datavg-data
mkfs -t ext4 /dev/mapper/datavg-recovery
mkfs -t ext4 /dev/mapper/datavg-inventory

  - Prepare a place to mount the oracle partitions.
mkdir -p /oracle/data
mkdir -p /oracle/base
mkdir -p /oracle/recovery
mkdir -p /oracle/inventory

  - Set the permissions/ownership for the oracle mount points.
chown -R oracle:oinstall /oracle
chmod -R 775 /oracle

  - Add entries for the new partitions in /etc/fstab
cat >> /etc/fstab <<'END_OF_TEXT'
/dev/mapper/datavg-base /oracle/base             ext4    defaults        1 2
/dev/mapper/datavg-data /oracle/data             ext4    defaults        1 2
/dev/mapper/datavg-recovery /oracle/recovery     ext4    defaults        1 2
/dev/mapper/datavg-inventory /oracle/inventory   ext4    defaults        1 2
END_OF_TEXT

  - Mount the new partitions
mount -a

  - Blanket set the permissions on all the newly mounted partitions.
chown -R oracle:oinstall /oracle
chmod -R 775 /oracle

  - Now we have blanket changed permissions for everything under /oracle, we need to correct the permissions on the lost+found dirs.
chown -R root:root /oracle/data/lost+found
chown -R root:root /oracle/base/lost+found
chown -R root:root /oracle/recovery/lost+found
chown -R root:root /oracle/inventory/lost+found
chmod -R 700 /oracle/data/lost+found
chmod -R 700 /oracle/base/lost+found
chmod -R 700 /oracle/recovery/lost+found
chmod -R 700 /oracle/inventory/lost+found</code>

====Open Firewall====
The database listens on 1521 and the web 'enterprise manager' is on port 1158.
<code>iptables -I INPUT -m state --state NEW -m tcp -p tcp --dport 1158 -j ACCEPT
iptables -I INPUT -m state --state NEW -m tcp -p tcp --dport 1521 -j ACCEPT
service iptables save
service iptables restart</code>

=====Install Oracle=====
====Silent Install====
===Create Response File===
Before installing silently, you will need to setup a response file. Copy and paste the following into a file called /tmp/dbresponse.rsp
<code>####################################################################
  -# Copyright(c) Oracle Corporation 1998,2011. All rights reserved.##
  -#                                                                ##
  -# Specify values for the variables listed below to customize     ##
  -# your installation.                                             ##
  -#                                                                ##
  -# Each variable is associated with a comment. The comment        ##
  -# can help to populate the variables with the appropriate        ##
  -# values.                                                        ##
  -#                                                                ##
  -# IMPORTANT NOTE: This file contains plain text passwords and    ##
  -# should be secured to have read permission only by oracle user  ##
  -# or db administrator who owns this installation.                ##
  -#                                                                ##
  -###################################################################

  --------------------------------------------------------------------------------
  - Do not change the following system generated value. 
  --------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

  --------------------------------------------------------------------------------
  - Specify the installation option.
  - It can be one of the following:
  - 1. INSTALL_DB_SWONLY
  - 2. INSTALL_DB_AND_CONFIG
  - 3. UPGRADE_DB
  --------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_AND_CONFIG

  --------------------------------------------------------------------------------
  - Specify the hostname of the system as set during the install. It can be used
  - to force the installation to use an alternative hostname rather than using the
  - first hostname found on the system. (e.g., for systems with multiple hostnames 
  - and network interfaces)
  --------------------------------------------------------------------------------
ORACLE_HOSTNAME=templatedb.example.com

  --------------------------------------------------------------------------------
  - Specify the Unix group to be set for the inventory directory.  
  --------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall

  --------------------------------------------------------------------------------
  - Specify the location which holds the inventory files.
  - This is an optional parameter if installing on
  - Windows based Operating System.
  --------------------------------------------------------------------------------
INVENTORY_LOCATION=/oracle/inventory/inventory

  --------------------------------------------------------------------------------
  - Specify the languages in which the components will be installed.             
  - 
  - en   : English                  ja   : Japanese                  
  - fr   : French                   ko   : Korean                    
  - ar   : Arabic                   es   : Latin American Spanish    
  - bn   : Bengali                  lv   : Latvian                   
  - pt_BR: Brazilian Portuguese     lt   : Lithuanian                
  - bg   : Bulgarian                ms   : Malay                     
  - fr_CA: Canadian French          es_MX: Mexican Spanish           
  - ca   : Catalan                  no   : Norwegian                 
  - hr   : Croatian                 pl   : Polish                    
  - cs   : Czech                    pt   : Portuguese                
  - da   : Danish                   ro   : Romanian                  
  - nl   : Dutch                    ru   : Russian                   
  - ar_EG: Egyptian                 zh_CN: Simplified Chinese        
  - en_GB: English (Great Britain)  sk   : Slovak                    
  - et   : Estonian                 sl   : Slovenian                 
  - fi   : Finnish                  es_ES: Spanish                   
  - de   : German                   sv   : Swedish                   
  - el   : Greek                    th   : Thai                      
  - iw   : Hebrew                   zh_TW: Traditional Chinese       
  - hu   : Hungarian                tr   : Turkish                   
  - is   : Icelandic                uk   : Ukrainian                 
  - in   : Indonesian               vi   : Vietnamese                
  - it   : Italian                                                   
  -
  - all_langs   : All languages
  -
  - Specify value as the following to select any of the languages.
  - Example : SELECTED_LANGUAGES=en,fr,ja
  -
  - Specify value as the following to select all the languages.
  - Example : SELECTED_LANGUAGES=all_langs  
  --------------------------------------------------------------------------------
SELECTED_LANGUAGES=en,en_GB

  --------------------------------------------------------------------------------
  - Specify the complete path of the Oracle Home. 
  --------------------------------------------------------------------------------
ORACLE_HOME=/oracle/base/home

  --------------------------------------------------------------------------------
  - Specify the complete path of the Oracle Base. 
  --------------------------------------------------------------------------------
ORACLE_BASE=/oracle/base

  --------------------------------------------------------------------------------
  - Specify the installation edition of the component.                     
  -                                                             
  - The value should contain only one of these choices.        
  - EE     : Enterprise Edition                                
  - SE     : Standard Edition                                  
  - SEONE  : Standard Edition One
  - PE     : Personal Edition (WINDOWS ONLY)
  --------------------------------------------------------------------------------
oracle.install.db.InstallEdition=SEONE

  --------------------------------------------------------------------------------
  - This variable is used to enable or disable custom install and is considered
  - only if InstallEdition is EE.
  -
  - true  : Components mentioned as part of 'optionalComponents' property
  -         are considered for install.
  - false : Value for 'optionalComponents' is not considered.
  --------------------------------------------------------------------------------
oracle.install.db.EEOptionsSelection=false

  --------------------------------------------------------------------------------
  - This property is considered only if 'EEOptionsSelection' is set to true 
  -
  - Description: List of Enterprise Edition Options you would like to enable.
  -
  -              The following choices are available. You may specify any
  -              combination of these choices.  The components you choose should
  -              be specified in the form "internal-component-name:version"
  -              Below is a list of components you may specify to enable.
  -        
  -              oracle.oraolap:11.2.0.3.0 - Oracle OLAP
  -              oracle.rdbms.dm:11.2.0.3.0 - Oracle Data Mining RDBMS Files
  -              oracle.rdbms.dv:11.2.0.3.0- Oracle Database Vault option
  -              oracle.rdbms.lbac:11.2.0.3.0 - Oracle Label Security
  -              oracle.rdbms.partitioning:11.2.0.3.0 - Oracle Partitioning
  -              oracle.rdbms.rat:11.2.0.3.0 - Oracle Real Application Testing
  --------------------------------------------------------------------------------
oracle.install.db.optionalComponents=

  -##############################################################################
  -                                                                             #
  - PRIVILEGED OPERATING SYSTEM GROUPS                                          #
  - ------------------------------------------                                  #
  - Provide values for the OS groups to which OSDBA and OSOPER privileges       #
  - needs to be granted. If the install is being performed as a member of the   #
  - group "dba", then that will be used unless specified otherwise below.       #
  -                                                                             #
  - The value to be specified for OSDBA and OSOPER group is only for UNIX based #
  - Operating System.                                                           #
  -                                                                             #
  -##############################################################################

  -------------------------------------------------------------------------------
  - The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
  --------------------------------------------------------------------------------
oracle.install.db.DBA_GROUP=dba

  -------------------------------------------------------------------------------
  - The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
  - The value to be specified for OSOPER group is optional.
  -------------------------------------------------------------------------------
oracle.install.db.OPER_GROUP=oper

  --------------------------------------------------------------------------------
  - Specify the cluster node names selected during the installation.                                      
  - Example : oracle.install.db.CLUSTER_NODES=node1,node2
  --------------------------------------------------------------------------------
oracle.install.db.CLUSTER_NODES=

  -------------------------------------------------------------------------------
  - This variable is used to enable or disable RAC One Node install.
  -
  - true  : Value of RAC One Node service name is used.
  - false : Value of RAC One Node service name is not used.
  -
  - If left blank, it will be assumed to be false.
  -------------------------------------------------------------------------------
oracle.install.db.isRACOneInstall=false

  -------------------------------------------------------------------------------
  - Specify the name for RAC One Node Service. 
  -------------------------------------------------------------------------------
oracle.install.db.racOneServiceName=

  --------------------------------------------------------------------------------
  - Specify the type of database to create.
  - It can be one of the following:
  - - GENERAL_PURPOSE/TRANSACTION_PROCESSING                       
  - - DATA_WAREHOUSE                                
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

  --------------------------------------------------------------------------------
  - Specify the Starter Database Global Database Name. 
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.globalDBName=database.example.com

  --------------------------------------------------------------------------------
  - Specify the Starter Database SID.
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.SID=sidney

  --------------------------------------------------------------------------------
  - Specify the Starter Database character set.
  -                                               
  -  One of the following
  -  AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,
  -  EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,
  -  BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,
  -  AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,
  -  IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,
  -  KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,
  -  ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.characterSet=AL32UTF8

  -------------------------------------------------------------------------------
  - This variable should be set to true if Automatic Memory Management 
  - in Database is desired.
  - If Automatic Memory Management is not desired, and memory allocation
  - is to be done manually, then set it to false.
  -------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryOption=true

  --------------------------------------------------------------------------------
  - Specify the total memory allocation for the database. Value(in MB) should be
  - at least 256 MB, and should not exceed the total physical memory available 
  - on the system.
  - Example: oracle.install.db.config.starterdb.memoryLimit=512
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryLimit=751

  --------------------------------------------------------------------------------
  - This variable controls whether to load Example Schemas onto
  - the starter database or not.
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.installExampleSchemas=false

  --------------------------------------------------------------------------------
  - This variable includes enabling audit settings, configuring password profiles
  - and revoking some grants to public. These settings are provided by default. 
  - These settings may also be disabled.     
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.enableSecuritySettings=true

  -##############################################################################
  -                                                                             #
  - Passwords can be supplied for the following four schemas in the	      #
  - starter database:      						      #
  -   SYS                                                                       #
  -   SYSTEM                                                                    #
  -   SYSMAN (used by Enterprise Manager)                                       #
  -   DBSNMP (used by Enterprise Manager)                                       #
  -                                                                             #
  - Same password can be used for all accounts (not recommended) 		      #
  - or different passwords for each account can be provided (recommended)       #
  -                                                                             #
  -##############################################################################

  -------------------------------------------------------------------------------
  - This variable holds the password that is to be used for all schemas in the
  - starter database.
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.ALL=

  --------------------------------------------------------------------------------
  - Specify the SYS password for the starter database.
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYS=DATABASE_PASSWORD_HOLDER

  --------------------------------------------------------------------------------
  - Specify the SYSTEM password for the starter database.
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYSTEM=DATABASE_PASSWORD_HOLDER

  --------------------------------------------------------------------------------
  - Specify the SYSMAN password for the starter database.
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYSMAN=DATABASE_PASSWORD_HOLDER

  --------------------------------------------------------------------------------
  - Specify the DBSNMP password for the starter database.
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.DBSNMP=DATABASE_PASSWORD_HOLDER

  --------------------------------------------------------------------------------
  - Specify the management option to be selected for the starter database. 
  - It can be one of the following:
  - 1. GRID_CONTROL
  - 2. DB_CONTROL
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.control=DB_CONTROL

  --------------------------------------------------------------------------------
  - Specify the Management Service to use if Grid Control is selected to manage 
  - the database.      
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

  -##############################################################################
  -                                                                             #
  - SPECIFY BACKUP AND RECOVERY OPTIONS                                 	      #
  - ------------------------------------		                              #
  - Out-of-box backup and recovery options for the database can be mentioned    #
  - using the entries below.						      #	
  -                                                                             #
  -##############################################################################

  -------------------------------------------------------------------------------
  - This variable is to be set to false if automated backup is not required. Else 
  - this can be set to true.
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.automatedBackup.enable=true

  -------------------------------------------------------------------------------
  - Regardless of the type of storage that is chosen for backup and recovery, if 
  - automated backups are enabled, a job will be scheduled to run daily to backup 
  - the database. This job will run as the operating system user that is 
  - specified in this variable.
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.automatedBackup.osuid=oracle

  --------------------------------------------------------------------------------
  - Regardless of the type of storage that is chosen for backup and recovery, if 
  - automated backups are enabled, a job will be scheduled to run daily to backup 
  - the database. This job will run as the operating system user specified by the 
  - above entry. The following entry stores the password for the above operating 
  - system user.
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.automatedBackup.ospwd=ORACLE_USER_PASSWORD_HOLDER

  --------------------------------------------------------------------------------
  - Specify the type of storage to use for the database.
  - It can be one of the following:
  - - FILE_SYSTEM_STORAGE
  - - ASM_STORAGE
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE

  --------------------------------------------------------------------------------
  - Specify the database file location which is a directory for datafiles, control
  - files, redo logs.         
  -
  - Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE 
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/oracle/data

  --------------------------------------------------------------------------------
  - Specify the backup and recovery location.
  -
  - Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE 
  --------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/oracle/recovery

  --------------------------------------------------------------------------------
  - Specify the existing ASM disk groups to be used for storage.
  -
  - Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE
  --------------------------------------------------------------------------------
oracle.install.db.config.asm.diskGroup=

  --------------------------------------------------------------------------------
  - Specify the password for ASMSNMP user of the ASM instance.                 
  -
  - Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE 
  --------------------------------------------------------------------------------
oracle.install.db.config.asm.ASMSNMPPassword=

  -------------------------------------------------------------------------------
  - Specify the My Oracle Support Account Username.
  -
  -  Example   : MYORACLESUPPORT_USERNAME=abc@oracle.com
  -------------------------------------------------------------------------------
MYORACLESUPPORT_USERNAME=my_oracle_account@example.com

  -------------------------------------------------------------------------------
  - Specify the My Oracle Support Account Username password.
  -
  - Example    : MYORACLESUPPORT_PASSWORD=password
  -------------------------------------------------------------------------------
MYORACLESUPPORT_PASSWORD=ONLINE_PORTAL_PASSWORD

  -------------------------------------------------------------------------------
  - Specify whether to enable the user to set the password for
  - My Oracle Support credentials. The value can be either true or false.
  - If left blank it will be assumed to be false.
  -
  - Example    : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
  -------------------------------------------------------------------------------
SECURITY_UPDATES_VIA_MYORACLESUPPORT=true

  -------------------------------------------------------------------------------
  - Specify whether user doesn't want to configure Security Updates.
  - The value for this variable should be true if you don't want to configure
  - Security Updates, false otherwise.
  -
  - The value can be either true or false. If left blank it will be assumed
  - to be false.
  -
  - Example    : DECLINE_SECURITY_UPDATES=false
  -------------------------------------------------------------------------------
DECLINE_SECURITY_UPDATES=false

  -------------------------------------------------------------------------------
  - Specify the Proxy server name. Length should be greater than zero.
  -
  - Example    : PROXY_HOST=proxy.domain.com 
  -------------------------------------------------------------------------------
PROXY_HOST=

  -------------------------------------------------------------------------------
  - Specify the proxy port number. Should be Numeric and atleast 2 chars.
  -
  - Example    : PROXY_PORT=25
  -------------------------------------------------------------------------------
PROXY_PORT=

  -------------------------------------------------------------------------------
  - Specify the proxy user name. Leave PROXY_USER and PROXY_PWD
  - blank if your proxy server requires no authentication.
  -
  - Example    : PROXY_USER=username
  -------------------------------------------------------------------------------
PROXY_USER=

  -------------------------------------------------------------------------------
  - Specify the proxy password. Leave PROXY_USER and PROXY_PWD  
  - blank if your proxy server requires no authentication.
  -
  - Example    : PROXY_PWD=password
  -------------------------------------------------------------------------------
PROXY_PWD=

  -------------------------------------------------------------------------------
  - Specify the proxy realm. 
  -
  - Example    : PROXY_REALM=metalink
  -------------------------------------------------------------------------------
PROXY_REALM=
  -------------------------------------------------------------------------------
  - Specify the Oracle Support Hub URL. 
  - 
  - Example    : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/
  -------------------------------------------------------------------------------
COLLECTOR_SUPPORTHUB_URL=

  -------------------------------------------------------------------------------
  - Specify the auto-updates option. It can be one of the following:
  - a.MYORACLESUPPORT_DOWNLOAD
  - b.OFFLINE_UPDATES
  - c.SKIP_UPDATES
  -------------------------------------------------------------------------------
oracle.installer.autoupdates.option=SKIP_UPDATES
  -------------------------------------------------------------------------------
  - In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where
  - the updates are to be downloaded.
  - In case OFFLINE_UPDATES option is chosen, specify the location where the updates 
  - are present.
oracle.installer.autoupdates.downloadUpdatesLoc=
  -------------------------------------------------------------------------------
  - Specify the My Oracle Support Account Username which has the patches download privileges  
  - to be used for software updates.
  -  Example   : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com
  -------------------------------------------------------------------------------
AUTOUPDATES_MYORACLESUPPORT_USERNAME=my_oracle_account@example.com

  -------------------------------------------------------------------------------
  - Specify the My Oracle Support Account Username password which has the patches download privileges  
  - to be used for software updates.
  -
  - Example    : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password
  -------------------------------------------------------------------------------
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=ONLINE_ORACLE_ACCOUNT_PASSWORD_HOLDER</code>

===Edit Response File===
We need to set various passwords in the default response file given above. Assuming the file is /tmp/dbresponse.rsp.
<code>echo "Enter the password for the Oracle system account:"
read -s ORA_PASSWORD
echo "Enter the password for the Oracle db accounts:"
read -s ORA_SYS_PASSWORD
echo "Enter the password for my_oracle_account@example.com:"
read -s ONLINE_PORTAL_PASSWORD

sed -i "s/ORACLE_USER_PASSWORD_HOLDER/$ORA_PASSWORD/g" /tmp/dbresponse.rsp
sed -i "s/DATABASE_PASSWORD_HOLDER/$ORA_SYS_PASSWORD/g" /tmp/dbresponse.rsp
sed -i "s/ONLINE_ORACLE_ACCOUNT_PASSWORD_HOLDER/$ONLINE_PORTAL_PASSWORD/g" /tmp/dbresponse.rsp</code>

===Run Silent Install===
<code>su - oracle
/mnt/share/database/runInstaller -silent -responseFile /tmp/dbresponse.rsp</code>

Now wait until you are told that the Database is installed and configured. This will take at least ten minutes. The "The installation of Oracle Database 11g was successful" message does not mean the installation is finished. After another eight minutes or so, you will see the following text.
<code>As a root user, execute the following script(s):
        1. /oracle/inventory/inventory/orainstRoot.sh
        2. /oracle/base/home/root.sh</code>
This indicates that the installation has finished. Now move onto the post installation section of this guide which will include running the scripts mentioned (orainstRoot.sh and root.sh).

====Manual Installation====
Log into the GUI on the local console as the user 'oracle'. Open a terminal and run the following.
<code>/mnt/share/database/runInstaller</code>

The Oracle wizard should appear. Run through it setting the values as follows.

**Configure Security Updates**
  * Email: my_oracle_account@example.com
  * Password: See Keypass
  * Tick 'I wish to receive security updates via My Oracle Support'.

**Download Sofwtare Updates** 
  * Select 'Skip software updates'.

**Installation Option**
  * Create and configure a database

**System Class**
  * Server Class

**Grid Installation Options**
  * Single Instance Database Installation

**Install Type**
  * Advanced Install

**Product Languages**
  * English (United Kingdom)

**Database Edition**
  * Standard Edition One (4.42 GB)

**Installation Location**
  * Oracle Base: /oracle/base
  * Software Location: /oracle/base/home

**Create Inventory**
  * Inventory Directory: /oracle/inventory/inventory
  * oraInventory Group Name: oinstall

**Configure Type**
  * General Purpose/Transaction Processing

**Database Identifiers**
  * NOTE: Change 'template' in both fields to the name of the server you are setting up.
  * Global database name: database.example.com
  * Oracle Service Identifier: sidney

**Configuration Options**
  * Defaults (I assume it can be changed later)

**Management Options**
  * Use Oracle Enterprise Manager database control for database management.

**Database Storage**
NOTE: Notice that the default value needs to be changed to the one listed here.
  * Specify Database file location /oracle/data

**Backup and Recovery**
  * Enable automated backups
  * Recovery area: /oracle/recovery
  * username: oracle
  * password: <the password> e.g. the password you set for the user 'oracle' earlier

**Schema Passwords**
  * Tick the "Use the same password for all accounts" radio button
  * Set the password to the standard database admin password. 

**Operating System Groups**
  * Database administrator group: dba
  * Database operator group: oper

**Prerequisite Checks**
  * For 11.2.0.3, the only warning will be the absence of pdksh. This can be ignored because we installed the "ksh" package in its place. For more details, see [http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-6.php here].
  * Tick 'Ignore all'.
  * Click 'Next'. and click next

**Summary**
  * Click 'Finish'.

**Install Product**
  * Watch as Oracle installs.

**Install Summary**
  * After taking some time of installing, you will get a summary screen. On this screen is a button called "Password Management". You don't need to do anything here as SYS and SYSTEM are already unlocked.
  * Ignore any popup windows telling you that 'Oracle Configuration Manager Configuration' failed.
  * You then get taken to a "Execute Configuration Scripts" window. DO NOT PRESS OK YET.
  * Seriously: DO NOT PRESS OK YET.
  * Follow the instructions and run the scripts specified. This usually means "run the following from a root prompt"
<code>/oracle/inventory/orainstRoot.sh
/oracle/base/home/root.sh</code>
  * Once the scripts have run, press 'OK'.
  * Click 'Next'.
  * Click 'Close'.
  * If the configuration assistants failed, say Yes to continuing.

=====Post Installation=====

If you installed Oracle silently using the response file, you must now run these as root. If you installed Oracle using the GUI, you have probably already run these as root and should not run them again.
<code>su -
/oracle/inventory/inventory/orainstRoot.sh
/oracle/base/home/root.sh</code>

Set oracle to start on boot<code>sed -i "s/:N/:Y/g" /etc/oratab</code>
Create the oracle init script (/etc/init.d/oracle)
<code>cat < EOF >> /etc/init.d/oracle
  -!/bin/bash
  - chkconfig: 2345 95 20
  - /etc/rc.d/init.d/oracle
  - Description: Starts and stops the Oracle database, listeners and Enterprise Manager

  - We need this next line to get the PATH variable setup correctly
. ~oracle/.bash_profile

case $1 in
start)
echo "Starting Oracle"
echo "--------------------" >> /var/log/oracle
date +"! %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle
echo "--------------------" >> /var/log/oracle
echo -n "Starting Oracle Databases: "
su - oracle -c "dbstart" >> /var/log/oracle
echo "Done."
echo -n "Starting Oracle Listeners: "
su - oracle -c "lsnrctl start" >> /var/log/oracle
echo "Done."
echo -n "Starting Oracle Enterprise Manager: "
su - oracle -c "emctl start dbconsole" >> /var/log/oracle
echo "Done."
echo ""
echo "--------------------" >> /var/log/oracle
date +"! %T %a %D : Finished." >> /var/log/oracle
echo "--------------------" >> /var/log/oracle
touch /var/lock/subsys/oracle
;;
stop)
echo "Shutting Down Oracle"
echo "--------------------" >> /var/log/oracle
date +"! %T %a %D : Shutting Down Oracle Databases as part of system down." >> /var/log/oracle
echo "--------------------" >> /var/log/oracle
echo -n "Shutting Down Oracle Enterprise Manager: "
su - oracle -c "emctl stop dbconsole" >> /var/log/oracle
echo "Done."
echo -n "Shutting Down Oracle Listeners: "
su - oracle -c "lsnrctl stop" >> /var/log/oracle
echo "Done."
rm -f /var/lock/subsys/oracle
echo -n "Shutting Down Oracle Databases: "
su - oracle -c "dbshut" >> /var/log/oracle
echo "Done."
echo ""
echo "--------------------" >> /var/log/oracle
date +"! %T %a %D : Finished." >> /var/log/oracle
echo "--------------------" >> /var/log/oracle
;;
restart)
echo "Restarting Oracle"
echo "--------------------" >> /var/log/oracle
date +"! %T %a %D : Restarting Oracle Databases as part of system up." >> /var/log/oracle
echo "--------------------" >> /var/log/oracle
echo -n "Restarting Oracle Databases: "
su - oracle -c "dbshut" >> /var/log/oracle
su - oracle -c "dbstart" >> /var/log/oracle
echo "Done."
echo -n "Restarting Oracle Listeners: "
su - oracle -c "lsnrctl stop" >> /var/log/oracle
su - oracle -c "lsnrctl start" >> /var/log/oracle
echo "Done."
echo -n "Restarting Oracle Enterprise Manager: "
su - oracle -c "emctl stop dbconsole" >> /var/log/oracle
su - oracle -c "emctl start dbconsole" >> /var/log/oracle
echo "Done."
echo ""
echo "--------------------" >> /var/log/oracle
date +"! %T %a %D : Finished." >> /var/log/oracle
echo "--------------------" >> /var/log/oracle
touch /var/lock/subsys/oracle
;;
  *)
echo "Usage: oracle {start|stop|restart}"
exit 1
esac
exit 0
EOF</code>
Set the oracle init script to run on boot automatically
<code>chmod u+x /etc/init.d/oracle
chkconfig --add oracle
chkconfig oracle on</code>
Reboot the machine
<code>init 6</code>
Once rebooted, leave the machine on the logon screen. On your own machine, go to the following page in your web browser (replace template with the name of the machine).
<code>https://templatedb.example.com:1158/em</code>

=====Get a Cloned/Deployed Oracle Server Running=====
It takes about eight minutes to deploy an Oracle VM.

The secret to cloning is to first make the 'clone' work as templatedb. Once the machine can boot and run oracle as 'templatedb', then you can change the hostname/IP address.

When you deploy from a VMware template, the machine name should be 'templatedb'. When you boot it for the first time, the network won't work. You will have to log into the local console as root and open up a terminal.

Before you rename the system, remember to change to root

  * Use the 'ifconfig -a' command to determine if the network card is called eth0, eth1, eth2, etc. 
  * Use the following command and look for a file called ifcfg-eth0, ifcfg-eth1, etc.<code>cd /etc/sysconfig/network-scripts; ls</code>
  * If the file name does not match the name of the network card, rename it as appropriate. Then edit the file and edit the top line as appropriate. Also, remove the MAC address line if it is present. Save and exit the text editor.
  * su to oracle and update gvm if needed.
  * Restart the computer.
  * If you can now ping other machines on the network, reboot the computer. e.g. <code>ping mail</code>
  * Make sure you can view and log into https://templatedb.example.com:1158/em/. Logging in is important as you will need to reset the passwords as they may be expiring
  * Log in to the web page as system. If prompted to change passwords, keep them all as they are now.
  * The machine will now working as templatedb on the network and you can run through the process for [[Useful_Oracle#Change_Hostname_and_IP changing|hostname and IP address ]].