Oracle Linux Configuration for Database Installation

>As root: Append servers to hosts file
General Information Resources
Links of Interest Download CDs

Installation Documents
Operating System Oracle Enterprise Linux 5.2
Operating System Configuration
As root: Install missing RPMs --mount CD3
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
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

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 = 1048576
net.ipv4.ip_local_port_range = 9000 65000

-- 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

--modify /etc/pam.d/ login
session required
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
    ulimit -u 16384 -n 65536
  umask 022
Optimize TCP/IP Stack Handling -- enable TCP kernel auto_tuning
/proc/sys/net/ipv4/tcp_moderate_rcvbuf (1=on)



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

-- ensure

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

Note: the line:   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 alpha1 alpha2 beta1 beta2 gamma1 gamma2 delta1 delta2 eta1 eta2

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

vi .bashrc

-- append the following
umask 022


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 1: Choose the Software Only install option
Step 2: For a standalone database choose the first option. For RAC the second
Step 3: Accept the default
Step 4A: Accept the default. Before selecting "Next" examine the "Select Options" choices
Step 4B: Review the "Select Options" Choices
Step 5: Accept the defaults ... they are based on the environment variables set in your shell
Step 6: Accept the default
Step 7: Accept the defaults
Step 8: This is a typical result if you didn't read and follow the docs.
Step 9: If Windows find a copy of Oracle Database through 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 of the 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
Linux Install for Oracle
Linux Install for Oracle 11gR1
Unix & vi
What's New In 12cR1
What's New In 12cR2
  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-2017 Daniel A. Morgan All Rights Reserved