User Tools

Site Tools


databases:install_oracle_11gr2

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
databases:install_oracle_11gr2 [2020/05/24 13:56] – created bstafforddatabases:install_oracle_11gr2 [2022/11/23 12:49] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ======Install Oracle 11gR2====== ======Install Oracle 11gR2======
-=Overview=+
 This page shows how to install 64bit Oracle 11gR2 SP3 on CentOS 6 64bit. This page shows how to install 64bit Oracle 11gR2 SP3 on CentOS 6 64bit.
  
-=Prerequisites= +=====Prerequisites====
-You must have a CentOS machine already set up in accordance with the "[[Install CentOS 6]]guide.+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. It is assumed that the system has a blank 80G+ disk attached to it at /dev/sdc.
  
-=Download Installers=+====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. 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.
  
Line 15: Line 15:
   * Main Oracle Database download page is [http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html here].   * Main Oracle Database download page is [http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html here].
  
-=Preparation=+=====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). 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. Unless otherwise specified, the following should be run as the root user.
  
-==Install Prerequisite Software==+====Install Prerequisite Software====
 Oracle 11gR2 requires the following software packages to be installed on CentOS 6.4. Oracle 11gR2 requires the following software packages to be installed on CentOS 6.4.
 <code>yum -y install \ <code>yum -y install \
Line 28: Line 28:
 unixODBC-devel.i686 xdpyinfo</code> unixODBC-devel.i686 xdpyinfo</code>
  
-==Create User and Groups==+====Create User and Groups====
 Create user 'oracle' and appropriate groups. Create user 'oracle' and appropriate groups.
   * oinstall (group) 200 - The Oracle Inventory group   * oinstall (group) 200 - The Oracle Inventory group
Line 42: Line 42:
 <code>passwd oracle</code> <code>passwd oracle</code>
  
-==Set Kernel Parameters==+====Set Kernel Parameters====
 <code>cat << EOF >> /etc/sysctl.conf <code>cat << EOF >> /etc/sysctl.conf
  
Line 60: Line 60:
 <code>sysctl -p</code> <code>sysctl -p</code>
  
-==Set Shell Limits==+====Set Shell Limits====
 Increase the shell limits for the oracle user to improve the performance of the software. Increase the shell limits for the oracle user to improve the performance of the software.
 <code>cat << EOF >> /etc/security/limits.conf <code>cat << EOF >> /etc/security/limits.conf
Line 69: Line 69:
 EOF</code> EOF</code>
  
-==Configure PAM==+====Configure PAM====
 Modify PAM configuration Modify PAM configuration
 <code>cat << EOF >> /etc/pam.d/login <code>cat << EOF >> /etc/pam.d/login
Line 75: Line 75:
 EOF</code> EOF</code>
  
-==Edit Profile Scripts==+====Edit Profile Scripts====
 Tweak the default profile script. Tweak the default profile script.
 <code>cat << EOF >> /etc/profile <code>cat << EOF >> /etc/profile
Line 109: Line 109:
 echo "PATH=/usr/sbin:\$PATH:\$ORACLE_HOME/bin; export PATH" >> $FILENAME</code> echo "PATH=/usr/sbin:\$PATH:\$ORACLE_HOME/bin; export PATH" >> $FILENAME</code>
  
-==Setup Oracle Disk==+====Setup Oracle Disk====
 Now we setup the extra disk (/dev/sdc). Now we setup the extra disk (/dev/sdc).
 <code># Create a new physical volume <code># Create a new physical volume
Line 164: Line 164:
 chmod -R 700 /oracle/inventory/lost+found</code> chmod -R 700 /oracle/inventory/lost+found</code>
  
-==Open Firewall==+====Open Firewall====
 The database listens on 1521 and the web 'enterprise manager' is on port 1158. 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 <code>iptables -I INPUT -m state --state NEW -m tcp -p tcp --dport 1158 -j ACCEPT
Line 171: Line 171:
 service iptables restart</code> service iptables restart</code>
  
-=Install Oracle= +=====Install Oracle====
-==Silent Install==+====Silent Install====
 ===Create Response File=== ===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 Before installing silently, you will need to setup a response file. Copy and paste the following into a file called /tmp/dbresponse.rsp
Line 670: Line 670:
 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). 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==+====Manual Installation====
 Log into the GUI on the local console as the user 'oracle'. Open a terminal and run the following. 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> <code>/mnt/share/database/runInstaller</code>
Line 676: Line 676:
 The Oracle wizard should appear. Run through it setting the values as follows. The Oracle wizard should appear. Run through it setting the values as follows.
  
-'''Configure Security Updates'''+**Configure Security Updates**
   * Email: my_oracle_account@example.com   * Email: my_oracle_account@example.com
   * Password: See Keypass   * Password: See Keypass
   * Tick 'I wish to receive security updates via My Oracle Support'.   * Tick 'I wish to receive security updates via My Oracle Support'.
  
-'''Download Sofwtare Updates''' +**Download Sofwtare Updates** 
   * Select 'Skip software updates'.   * Select 'Skip software updates'.
  
-'''Installation Option'''+**Installation Option**
   * Create and configure a database   * Create and configure a database
  
-'''System Class'''+**System Class**
   * Server Class   * Server Class
  
-'''Grid Installation Options'''+**Grid Installation Options**
   * Single Instance Database Installation   * Single Instance Database Installation
  
-'''Install Type'''+**Install Type**
   * Advanced Install   * Advanced Install
  
-'''Product Languages'''+**Product Languages**
   * English (United Kingdom)   * English (United Kingdom)
  
-'''Database Edition'''+**Database Edition**
   * Standard Edition One (4.42 GB)   * Standard Edition One (4.42 GB)
  
-'''Installation Location'''+**Installation Location**
   * Oracle Base: /oracle/base   * Oracle Base: /oracle/base
   * Software Location: /oracle/base/home   * Software Location: /oracle/base/home
  
-'''Create Inventory'''+**Create Inventory**
   * Inventory Directory: /oracle/inventory/inventory   * Inventory Directory: /oracle/inventory/inventory
   * oraInventory Group Name: oinstall   * oraInventory Group Name: oinstall
  
-'''Configure Type'''+**Configure Type**
   * General Purpose/Transaction Processing   * General Purpose/Transaction Processing
  
-'''Database Identifiers'''+**Database Identifiers**
   * NOTE: Change 'template' in both fields to the name of the server you are setting up.   * NOTE: Change 'template' in both fields to the name of the server you are setting up.
   * Global database name: database.example.com   * Global database name: database.example.com
   * Oracle Service Identifier: sidney   * Oracle Service Identifier: sidney
  
-'''Configuration Options'''+**Configuration Options**
   * Defaults (I assume it can be changed later)   * Defaults (I assume it can be changed later)
  
-'''Management Options'''+**Management Options**
   * Use Oracle Enterprise Manager database control for database management.   * Use Oracle Enterprise Manager database control for database management.
  
-'''Database Storage'''+**Database Storage**
 NOTE: Notice that the default value needs to be changed to the one listed here. NOTE: Notice that the default value needs to be changed to the one listed here.
   * Specify Database file location /oracle/data   * Specify Database file location /oracle/data
  
-'''Backup and Recovery'''+**Backup and Recovery**
   * Enable automated backups   * Enable automated backups
   * Recovery area: /oracle/recovery   * Recovery area: /oracle/recovery
Line 734: Line 734:
   * password: <the password> e.g. the password you set for the user 'oracle' earlier   * password: <the password> e.g. the password you set for the user 'oracle' earlier
  
-'''Schema Passwords'''+**Schema Passwords**
   * Tick the "Use the same password for all accounts" radio button   * Tick the "Use the same password for all accounts" radio button
   * Set the password to the standard database admin password.    * Set the password to the standard database admin password. 
  
-'''Operating System Groups'''+**Operating System Groups**
   * Database administrator group: dba   * Database administrator group: dba
   * Database operator group: oper   * Database operator group: oper
  
-'''Prerequisite Checks'''+**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].   * 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'.   * Tick 'Ignore all'.
   * Click 'Next'. and click next   * Click 'Next'. and click next
  
-'''Summary'''+**Summary**
   * Click 'Finish'.   * Click 'Finish'.
  
-'''Install Product'''+**Install Product**
   * Watch as Oracle installs.   * Watch as Oracle installs.
  
-'''Install Summary'''+**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.   * 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.   * Ignore any popup windows telling you that 'Oracle Configuration Manager Configuration' failed.
Line 766: Line 766:
   * If the configuration assistants failed, say Yes to continuing.   * If the configuration assistants failed, say Yes to continuing.
  
-=Post Installation=+=====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. 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.
Line 863: Line 863:
 <code>https://templatedb.example.com:1158/em</code> <code>https://templatedb.example.com:1158/em</code>
  
-=Get a Cloned/Deployed Oracle Server Running=+=====Get a Cloned/Deployed Oracle Server Running=====
 It takes about eight minutes to deploy an Oracle VM. It takes about eight minutes to deploy an Oracle VM.
  
databases/install_oracle_11gr2.1590328618.txt.gz · Last modified: (external edit)