Introduction
This article covers the Installation of Oracle Database 11g Release 2 on Enterprise Linux 5 and Suse 11.
Oracle 11g Release 2 was launched in August 2009. Now, the product is available on all platforms. There are almost 400 additional functionalities added by Oracle 11g. After going through the Oracle webcast 11g Release 2, I feel Oracle 11g Rel. 2 focuses more on High Availability (easy RAC installation and implementation), Compressing Data, Security, etc.
11g Release 2 required minimum 1gb RAM for the installation. I would recommend minimum 4gb RAM will be ideally better. Swap should have double of physical RAM.
I recommend the following Server Configuration:
- Intel Xeon Processor
- 3.20ghz
- L3 8mb Cache
- 1 Quad Core
- 4 to 8gb Ram (an ideal configuration)
- 146gb HDD (default) - This configuration can be changed, based on various factors.
The following packages are mandatory for Enterprise Linux:
- GNOME Desktop Environment
- Graphical Internet
- X Window System
- Editors
- Development Tools
- Server Configuration Tools
- System Tools and Administration Tools
You can download the software, subject to Oracle Licensing.
http://www.oracle.com/technology/software/products/database/index.html
- Standard Edition One – support upto 2 CPU
- Standard Edition – support upto 4 CPU
- Enterprise Edition – unlimited
- (11.2.0.1.0)
- Linux x86 | Disk 1, Disk 2 (2.1 GB)
Change the parameters:
Copy sysctl.conf
cp sysctl.conf sysctl.confold
Cd /etc
Vi sysctl.conf
Add the following:
kernel.shmmax = 2147483648
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536 # 512 * PROCESSES
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
net.ipv4.ip_local_port_range = 1024 65000
Press Esc :wq
Change the Hosts File Entry
Cd /etc
Cp hosts hostsold
Vi hosts
IP-address Machinename.domainname Hostname
Press Esc and :wq
Go to /etc/security (cd /etc/security)
Vi limits.conf
Add or change /etc/security/limits.conf file:
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
to save Esc :wq
Go to /etc/pam.d (cd /etc/pam.d)
Vi login
Add or change line to the /etc/pam.d/login file
session required pam_limits.so
session required /lib/security/pam_limits.so
to save Esc :wq
Very Important Steps
Secure linux has to be disabled:
Go to /etc/selinux(cd /etc/selinux)
Vi config
Change or add
SELINUX=disabled
to save Esc :wq
The following packages(rpm) are required for Enterprise Linux 5.0 on various cds:
Insert the cd and mount the same.
Go to cd /media/cdrom/Server (cd /media/cdrom/Server).
(carefully use –force and –nodeps)
rpm -Uvh binutils-2.17.50.0.6
rpm -Uvh compat-libstdc++-33-3.2.3
rpm -Uvh elfutils-libelf-0.125
rpm -Uvh elfutils-libelf-devel-0.125
rpm -Uvh elfutils-libelf-devel-static-0.125
rpm -Uvh gcc-4.1.2
rpm -Uvh gcc-c++-4.1.2
rpm -Uvh glibc-2.5-24
rpm -Uvh glibc-common-2.5
rpm -Uvh glibc-devel-2.5
rpm -Uvh glibc-headers-2.5
rpm -Uvh kernel-headers-2.6.18
rpm -Uvh ksh-20060214
rpm -Uvh libaio-0.3.106
rpm -Uvh libaio-devel-0.3.106
rpm -Uvh libgcc-4.1.2
rpm -Uvh libgomp-4.1.2
rpm -Uvh libstdc++-4.1.2
rpm -Uvh libstdc++-devel-4.1.2
rpm -Uvh make-3.81
rpm -Uvh sysstat-7.0.2
rpm -Uvh unixODBC-2.2.11
rpm -Uvh unixODBC-devel-2.2.11
eject or unmount
Linux Enterprise Server 11 - SUSE:
rpm -Uvh binutils-2.19
rpm -Uvh gcc-4.3
rpm -Uvh gcc-c++-4.3
rpm -Uvh glibc-2.9
rpm -Uvh glibc-devel-2.9
rpm -Uvh ksh-93t
rpm -Uvh libstdc++33-3.3.3
rpm -Uvh libstdc++43-4.3.3_20081022
rpm -Uvh libstdc++43-devel-4.3.3_20081022
rpm -Uvh libaio-0.3.104
rpm -Uvh libaio-devel-0.3.104
rpm -Uvh libgcc43-4.3.3_20081022
rpm -Uvh libstdc++-devel-4.3
rpm -Uvh make-3.81
rpm -Uvh sysstat-8.1.5
Create user and groups
Adding groups:
groupadd oinstall
groupadd dba
groupadd asmadmin
groupadd oper
Adding user and assigning the group:
useradd -g oinstall -G dba,oper,asmadmin oracle
Add password for Oracle user
passwd oracle
I would like to light on the "asmadmin" group is used for ASM.
Make directories in which the Oracle Binary to be installed
mkdir -p /data1/app/oracle/product/11.2/db_1
chown -R oracle:oinstall /data1/app/oracle/product/11.2/db_1
chmod -R 777 /data1/
Shutdown or reboot the machine
- Login as Oracle
- Change/add user environment
- Go to /home/oracle
- Vi .bash_profile
Add the following:
ORACLE_HOSTNAME=machinename.domainname
ORACLE_BASE=/data1/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11/db_1; export ORACLE_HOME
ORACLE_SID=orcl11g; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
Press Esc key :wq
Log out
Login as Oracle user
Run Install Steps
Set the Display first:
export DISPLAY=hostname:0.0
Or:
DISPAY=HOSTNAME:0.0
export DISPLAY
Go setup Disk directory
Cd Disk1
./runInstaller
Rest follow the GUI provided by Oracle.
Issue: 01. Both files(installation binary 1 and 2 should be 1 directory)
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-11-30_12-47-24AM. Please wait ...
Invalid source path '../stage/Components/oracle.jdk/1.5.0.17.0/1/DataFiles' specified for unzip. Unzip command failed. Please check oraparam.ini and specify a valid source path.
mkdir /data1/Disk1
Copy both binaries to this /data1/Disk1Unzip
