Oracle Linux Configuration for Database Installation
Version 11.2.0.3

Resources
Note: Oracle has changed the nature of how they released this version and have made available at MyOracleSupport 7 zip files. Here are their descriptions
Zip File # Description
1 Database 1 of 2
2 Database 2 of 2
3 OEM Grid Control
4 Client
5 Gateways
6 Examples
7 Uninstall
Operating System Oracle Enterprise Linux 5.2 or above
 
Operating System Configuration
As root: Install missing RPMs --mount CD3 (may be a different CD with your distro)

cd /media/cdrom/Enterprise/RPMS

rpm -Uvh libaio-0 [Tab]
rpm -Uvh libaio-devel-0.3.105-2.i386.rpm

cd /

eject cdrom

-- mount CD4 (may be a different CD with your distro)

cd /media/cdrom/Enterprise/RPMS

rpm -Uvh elfutils-libelf-0 [Tab]
rpm -Uvh elfutils-libelf-devel-0.91.1-3.i386.rpm

cd /

eject cdrom

-- mount CD1 (may be a different CD with your distro)

cd /media/cdrom/Enterprise/RPMS

rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
As root: Create DBA Group and Oracle User /usr/sbin/groupadd -g 500 oinstall
/usr/sbin/groupadd -g 501 dba
/usr/sbin/groupadd -g 502 oper
/usr/sbin/useradd -u 500 -m -g oinstall -G dba,oper oracle
id oracle

-- set the password to oracle1
passwd oracle

id nobody
-- if nobody does not exist then
/usr/sbin/useradd nobody
As root: Create Installation Directories 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 cat >> /etc/sysctl.conf <<EOF
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
tcp.ipv4.tcp_wmem = 262144 262144 262144
tcp.ipv4.tcp_rmem = 4194304 4194304 4194304
fs.aio-max-nr = 3145728
net.ipv4.ip_local_port_range = 9000 65000
EOF

-- activate changes
/sbin/sysctl -p
As root: Set Shell Limits -- modify limits.conf
cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

-- modify /etc/pam.d/ login
session required pam_limits.so
As root: Change Default Profile -- if Bourne, Korn or Bash shell. Check the install docs if C 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
  umask 022
fi
EOF
Optimize TCP/IP Stack Handling --enable TCP kernel auto-tuning
/proc/sys/net/ipv4/tcp_moderate_rcvbuf (1=on)

-- tune TCP max memory: tune to 2xBDP (Bandwidth x Delay Product)
-- For example, with 40 Mbits/sec bandwidth, 25 msec delay,
-- BDP = (40 x 1000 / 8 Kbytes/sec) x (0.025 sec) ~ 128 Kbytes

/proc/sys/net/ipv4/tcp_rmem and tcp_wmem 4096 87380 174760

-- tune the socket buffer sizes by setting to 2xBDP
/proc/sys/net/core/rmem_max and wmem_max

-- ensure that TCP Performance features are enabled
/proc/sys/net/ipv4/tcp_sack
/proc/sys/net/ipv4/tcp_window_scaling
/proc/sys/net/ipv4/tcp_timestamps

-- additionally be sure NIC cards have TCP off-loading capability
As root: Append servers to hosts file cd /etc

Note: the line:
127.0.0.1   omega#.mlib.org   omega#   localhost.localadmin localhost
delete the first two entries but do not delete localhost.localadmin
and local host or nothing will work properly.


vi hosts
vi command help
Append Esc A
Insert Esc I
Abort and quit Esc q!
Save and quit Esc wq

192.168.1.211 alpha1 alpha1.mlib.org
192.168.1.212 alpha2 alpha2.mlib.org
192.168.1.221 beta1 beta1.mlib.org
192.168.1.222 beta2 beta2.mlib.org
192.168.1.231 gamma1 gamma1.mlib.org
192.168.1.232 gamma2 gamma2.mlib.org
192.168.1.241 delta1 delta1.mlib.org
192.168.1.242 delta2 delta2.mlib.org
192.168.1.251 eta1 eta1.mlib.org
192.168.1.252 eta2 eta2.mlib.org

-- ping all hosts (substitute actual node names for the "omega")
ping 192.168.1.1
ping www.oracle.com
ping omega1
ping omega2
ping omega1.mlib.org
ping omega2.mlib.org
As root: Modify .bashrc # cd /home/oracle

vi .bashrc

-- append the following:
umask 022

ORACLE_HOSTNAME=?.mlib.org
ORACLE_BASE=/app/oracle/product
ORACLE_HOME=/app/oracle/product/11.2.0/db_2
ORACLE_SID=?
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 LD_LIBRARY_PATH
export TMP TEMP TMPDIR

alias oh='cd $ORACLE_HOME'
alias sql='sqlplus "/ as sysdba"'

-- close all open terminal windows and open new ones

$ set

-- validate the environment
 
Database Software-Only Installation
After unzipping the installation files change to the directory containing runInstaller

You must be the oracle user (not root) and you must verify your shell is set correctly
Step 1A: Unless you want to put in your MyOracleSupport (metalink) service identifier uncheck the box and click [Next].
Step 1B: If you decided not to provide your service identifier Oracle wants to know if you need had a few too many beers. Answer yes and remain as ignorant as the rest of us.
Step 2: Click "Skip software updates" and click [Next].
Step 3: Accept the default or click on "Create and configure a database" as shown and click [Next]
Step 4: Select "Server Class" and click [Next]
Step 5: Select stand-alone or RAC install and click [Next]
Step 6: Accept the default and click [Next]
Step 7: Accept the defaults and click [Next]
Step 8A: For any class accept the default, Enterprise Edition, and click [ Next ]. If installing for your company be sure to install only those features covered by your license agreement.
Step 8B: Additional license options if you've chosen Enterprise Edition. Be sure only those features that have been licensed are checked.
Step 9: Verify the environment variables you set up in .bashrc are correctly reflected. If they are not fix the environment variables and restart the installation in a new terminal window.

Click [Next]

Note to Oracle: This would be a great place to pop up a dialog box from which we could fix and reset them rather than canceling the install.
Step 10: Verify the Inventory directory is correct and is owned by the correct Linux group.

Click [Next]
Step 11: Select General Purpose and click [Next]
Step 12: These values are based on the environment variables you created. If they are not correct fix them here and restart the installation in a new terminal window.

Click [Next]
Step 13A: Accept the default and click [Next] unless you have a reason to not use AMM.
Step 13B: Select the character set appropriate for your globalization requirements. If you are not familiar with the choices read first and then continue the installation.

Click [Next]
Step 13C: Accept the default "new" security settings and click [Next]
Step 13D: If this is a production installation do not install the sample schemas. If the database will be used for training accept them.

Click [Next]
Step 14: Accept the default unless you have an OEM Grid installation in place and click [Next]
Step 15: Select File System and click [Next]
Step 16: Oracle's "automated backups" are unsuitable for a production environment and, if enabled, get in the way to teaching yourself how backups should be done. Do not enable these and click [Next].
Step 17: Select "Use the same password for all accounts" and choose some very simple password such as "Oracle1" then click [Next].

As soon as installation and configuration are completed set real passwords, with a high degree of complexity, for all required accounts and lock any others.
Step 18: Set Operating System Groups as demonstrated in the screen capture and click [Next].
Step 19A: Unless you have substantial installation experience with database 11gR2 do not select the "Ignore All" checkbox. Ignoring failures is a reasonably good way to have further failures.

It is certainly true that some failures can be ignored but definitely not all of them or even most of them.

If you have failures click the "Fix & Check Again" button. If no failures click [Next].
Step 19B: This screenshot is here solely do demonstrate the [Next] button being activated by clicking the "Ignore All" checkbox.
Step 20: This screen is informational only though you can use it to save a response file for recreating the database. Click [Install].
Step 21: Installation progress at 8%
Step 22: Getting near the end of the installation the Database Configuration Assistant pops up to allow for GUI password management. We recommend clicking [Ok] and performing password management in SQL*Plus.
Step 23: At this point open a terminal window, which as indicated must be as root, and run these two scripts in the order indicated (first 1, then 2). When both have been run close the terminal window and clock [OK].
Step 24: The screen from Step 23 showing the open terminal window after running orainstRoot.sh.
Step 25: Installation is complete. Copy this information into your browser and bookmark it

Click [Close]
Step 9: If Windows find a copy of Oracle Database 10.2.0.4 or 10.2.0.5 and follow these steps to get SQL*Plus Windows
Step # Description
1 Copy the following DDL files from the $ORACLE_HOME/bin directory of the 10gR2 database to $ORACLE_HOME\bin iofthe 11.2.0.1 install.
ltscsn10.dll oraldapclnt10.dll oranldap10.dll oraocr10.dll orasql10.dll
oraclient10.dll oran10.dll oranls10.dll oraocrb10.dll oraunls10.dll
oracommon10.dll orancds10.dll orannzsbb10.dll oraplp10.dll oravsn10.dll
oracore10.dll orancrypt10.dll oranro10.dll orapls10.dll oraxml10.dll
orageneric10.dll oranhost10.dll orantcp10.dll ORASLAX10.dll sqlplusw.exe
orahasgen10.dll oranl10.dll orantns10.dll orasnls10.dll  
2 Copy the file spwus.msb from $ORACLE_HOME\sqlplus\mesg to the corresponding directory in the 11gR2 file system.

Related Topics
cron jobs
Linux Install for Oracle 12cR1
Unix & vi
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