databases:install_oracle_11gr2
This is an old revision of the document!
Table of Contents
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 “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
/tmp
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.
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
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
groupadd oinstall -g 200 groupadd dba -g 201 groupadd oper -g 202 useradd -g oinstall -G dba,oper -u 440 oracle
Set the password for the user 'oracle'.
passwd oracle
Set Kernel Parameters
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
Tell the kernel to re-read the kernel parameter configuration file.
sysctl -p
Set Shell Limits
Increase the shell limits for the oracle user to improve the performance of the software.
cat << EOF >> /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 EOF
Configure PAM
Modify PAM configuration
cat << EOF >> /etc/pam.d/login session required pam_limits.so EOF
Edit Profile Scripts
Tweak the default profile script.
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
Ensure the 'oracle' user bash scripts can run
chmod u+x ~oracle/.bash_profile chmod u+x ~oracle/.bash_logout chmod u+x ~oracle/.bashrc
Set 'oracle' user default umask
cat << EOF >> ~oracle/.bashrc umask 022 EOF
Edit the Bash profile for the Oracle user.
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
Setup Oracle Disk
Now we setup the extra disk (/dev/sdc).
# 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
Open Firewall
The database listens on 1521 and the web 'enterprise manager' is on port 1158.
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
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
#################################################################### -# 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
Edit Response File
We need to set various passwords in the default response file given above. Assuming the file is /tmp/dbresponse.rsp.
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
Run Silent Install
su - oracle /mnt/share/database/runInstaller -silent -responseFile /tmp/dbresponse.rsp
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.
As a root user, execute the following script(s):
1. /oracle/inventory/inventory/orainstRoot.sh
2. /oracle/base/home/root.sh
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.
/mnt/share/database/runInstaller
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”
/oracle/inventory/orainstRoot.sh /oracle/base/home/root.sh
- 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.
su - /oracle/inventory/inventory/orainstRoot.sh /oracle/base/home/root.sh
Set oracle to start on boot
sed -i "s/:N/:Y/g" /etc/oratab
Create the oracle init script (/etc/init.d/oracle)
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
Set the oracle init script to run on boot automatically
chmod u+x /etc/init.d/oracle chkconfig --add oracle chkconfig oracle on
Reboot the machine
init 6
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).
https://templatedb.example.com:1158/em
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.
cd /etc/sysconfig/network-scripts; ls
- 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.
ping mail
- 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 hostname and IP address .
databases/install_oracle_11gr2.1590328867.txt.gz · Last modified: (external edit)