| 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
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 |
>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_1
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 1: Choose the Software Only install option |
 |
| Step 2: For a standalone database choose the first option. For a RAC cluster 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 10.2.0.2 through 10.2.0.4 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 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. |
|
