Oracle Universal Installer
Version 11.2.0.2
 
General Information
Links of Interest OTN Download
Installation Docs http://docs.oracle.com reference
 
Operating System Installation and Configuration
As root: Create DBA Group and Oracle User

Do this on all servers
$ /usr/sbin/groupadd oinstall
$ /usr/sbin/groupadd dba
$ /usr/sbin/useradd -m -g oinstall -G dba oracle
$id oracle

$passwd oracle
-- set the password to oracle1

# Verify group membership
$ groups oracle

$ id nobody
-- if nobody does not exist then
$ /usr/sbin/useradd nobody
As root: Create Installation Directories

Do this on all servers
mkdir -p /app/oracle
chown -R oracle:dba /app/oracle
chmod -R 775 /app/oracle

mkdir /stage
chown -R oracle:dba /stage
As root: Alter Kernel Parameters in sysctl.conf by appending the highlighted text.

Do this on all servers
cd /etc

vi sysctl.conf
fs.file-max = 65536
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.ip_local_port_range = 1024 65000

-- Activate changes
/sbin/sysctl -p
As root: Set Shell Limits

Do this on all servers
cd /etc/security

-- Modify limits.conf
cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536
EOF

-- Modify login
-- must NOT be the last line in the file
session required /lib/security/pam_limits.so
As root: Change Default Profile

Do this on all servers
cd /etc

-- if Bourne, Korn or Bash shell
cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ]; then
  if [ \$SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi
EOF
Verify ports in use # verify availability of port 1521

$ netstat -an | grep 15
As root: Append servers to hosts file

Do this on all servers
cd /etc

vi hosts
192.168.1.254 bigdog bigdog.mlib.org

-- ping all hosts (substitute actual node names for the "omega")
ping 192.168.1.1
ping www.oracle.com
ping omega1
ping omega1.mlib.org
Prepare files for installation -- as Linux user oracle

$ cd /stage

$ ls -al

$ unzip l*zip

$ ls -al
 
Screen Shots
Start runInstaller program
Step 1: Install Option Selection
Step 2: System Class Selection
Step 3: Single Instance or RAC Build Selection
Step 4: Installation Type Selection

For all classes select Advanced Install
Step 5: Installation Language Selection

Note that multiple languages can be selected on this screen
Step 6: Product Edition Selection

All classes are always taught using Enterprise Edition

Before clicking on [ Next ] click on [Select Options] and view those available.
Step 7: Install Location Screen

On this screen enter the paths for the environment variables ORACLE_BASE and ORACLE_HOME.

If what you entered is different from what is in your shell (.bash_profile and/or .bashrc) modify those file entries before continuing with the installation. Even though there is a browse button there is no reason to create the physical directories in advance: OUI will create them as long as the operating system user has permission on the selected location off the root file system.
Step 8: Inventory Selection Screen

The Oracle inventory can be placed anywhere but based on the ORACLE_BASE selection above the location shown is recommended.

If you have created the recommended three operating system groups, OINSTALL, DBA, and OSOPER you typically chose the OINSTALL group. If on Windows everything is typically done as the DBA group. If you have not read up on why multiple groups are recommended this would be a good time to hit the docs.
Step 9: Configuration Type Selection

For any class, other than one on Data Warehousing choose "General Purpose"
Step 10: Database Identifiers Screen

Give serious consideration at this point as to how and where this database will be deployed.

Oracle uses a lot of terminology that initially sounds like the same thing, global name, unique name, SID, service name, ....

They are not the same and have very different meanings depending on what you are doing.

If you are not familiar with these terms this is the time to open a browser and clarify their meaning and proper usage.
Step 11A: Memory, Character Sets, Security and Sample Schemas Selection

Be sure that you click on each tab and understand the options available. This first screen shot is based on the default selection enabling AMM.
Step 11B: Memory, Character Sets, Security and Sample Schemas Selection

This second tab page allows the selection of the character sets enabled during installation.
For most classes choose the default but if the class involves globalization, or your database may be used to store multiple languages you will most likely want to select Unicode.
Step 11C: Memory, Character Sets, Security and Sample Schemas Selection

Very simply select this option: Always. You may not want some of them, for example, case sensitive passwords at first. But consider the implications of explaining to a judge, while on the stand and under oath, your logic for disabling a security setting. It isn't pretty. So leave this checked and change your behavior instead.
Step 11D: Memory, Character Sets, Security and Sample Schemas Selection

If creating a database for a class be sure you select sample schema installation. If for a test or product environment do not make this selection.
Step 12:Management Options Selection

This is the new way to decide whether you wish to deploy the OEM Database Control

The first radio button will be selected by default if the server already has an agent installed on it for use with the OEM Grid Control.

The second option, selected here, is what you will see during installation on which an OEM Grid agent has not been installed. If you wish to use the email notification system obtain the correct SMTP server information from your network or system admin. The email address is the address to which you want notification emails sent.
Step 13: Storage Option Selection

If you do not have an ASM instance already installed choose File System.
Step 14: Backup and Recovery Options Screen

If installing for a class do not enable automated backups. The point of the class is to teach you how to do this so you understand what is happening.

If doing this for a production database don't enable it but for a different reason. That reason being that Oracle's default backup is a long way from optimal. Good decision making involves making decisions with respect to backupset versus imagecopy and full versus incremental.
Step 15: Management Password Screen

For any class use the single password recommended in the class book. Do not get creative as doing so may well cause other issues if the class involves multiple instances such as RAC, Data Guard, Streams, or AQ.

If this is for a production database by all means choose separate passwords and make sure they are complex ... both upper and lower case, at least one number, and at least one special character.
Step 16: Configuration Management Screen

For classes we never enable this and for customers with serious security issues, military, aerospace, banking, etc. I would recommend pressing the [ Next ] button and moving directly to step 17.

This may be perfectly safe but, as I write this, I remain unconvinced.
Step 17: Operating System Groups Selection

Take a quick look back at the screen shot for Step 8. If you created all three groups then OINSTALL was previously selected and the defaults, displayed, logically follow. It is equally possible to set everything up with only a single group.

What guides your decision making is the number of DBAs and System Administrators and the maturity of your IT group with respect to separation of duties and compliance with "best practices" for auditing.
Step 18A: Prerequisite Checks Screen

If there is a single feature about the new 11gR2 that most impresses me it is encapsulated on this screen. Finally we have a way to fix issues with kernel parameters without having to exit the installer and restart the entire process from the beginning.

"Fix and Check Again" is a great new feature and a tremendous improvement over the past. Just one caution ... read the shell script it writes ... and if you know what you are doing you may want to perform a small edit or two.

To fix an item with a "Failed" status press the "Fix & Check Again" button review the instruction. Then open a terminal window, su to root, review the script, and run it.

In this screenshot note that I have highlighted "Package glibc" and the bottom panel provides error details.
Step 18B: This screenshot is just here so that you can view more information about this screen.
Step 18C: Run the Fixup Script Created with the "Fix & Check Again" button
Step 19: Installation Summary Screen

Review the components that will be installed.
It is recommended that you save the response file so that you can easily duplicate a successful install without having to resort to the GUI.
Step 20A: Installation Progress Screen
Step 20B: Installation Progress Details Screen
Step 17E: Operating System Verification and Repair

The configuration is now fixed
Step 17F: Operating System Verification and Repair

The configuration is now fixed. Note that the Kernel Parameter errors are gone. I want to ignore the Run Level and ODBC mesage so I click the "Ignore All" check box in the upper right-hand corner.
Step 23: Run root.sh shell script
Installation Complete  
 
Oracle Home
OMR/OMS Server .bashrc as root (check out .profile file)

For classes this goes on the "1" machine (alpha1, beta1) only.
# cd /home/oracle

vi .bashrc

-- append the following:
ORACLE_BASE=/app/oracle/product/
ORACLE_HOME=/app/oracle/product/11.2.0/db_1
ORACLE_SID=<your SID here>
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
TMP=/tmp
TEMP=/tmp
TMPDIR=/tmp
PATH=$ORACLE_HOME/bin:$PATH
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID TMP TEMP TMPDIR LD_LIBRARY_PATH

alias oh='cd $ORACLE_HOME'
alias sql='sqlplus "/ as sysdba"'
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved