Thursday, June 14, 2012

Oracle Database 11g Release 2 Installation On Oracle Linux 5

Oracle Database 11g Release 2 Installation On Oracle Linux 5


This article describes the installation of Oracle Database 11g Release 2 on Oracle Linux 5 . The article is based on a server installation with a minimum of 2G swap, secure Linux disabled.

Download Software

Download the following software.

Download the Oracle software from OTN or edilevery depending on your support status.

Oracle Database 11g Release 2 (11.2.0.1) Software

Unpack Files

Unzip the files.



unzip 11gR2_database_1of2.zip

unzip 11gR2_database_2of2.zip



You should now have a single directory called "database" containing installation files.

Hosts File

The "/etc/hosts" file must contain a fully qualified name for the server.



For example.

127.0.0.1 localhost.localdomain localhost

192.168.16.1 shoaib-11gr2 shoaib-11gr2

Oracle recommend the following minimum parameter settings.

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

The current values can be tested using the following command.

/sbin/sysctl -a
grep

Add or amend the following lines in the "/etc/sysctl.conf" file.

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=4194304

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max=1048586

Run the following command to change the current kernel parameters.

/sbin/sysctl -p

Add the following lines to the "/etc/security/limits.conf" file.

* soft nproc 2047

* hard nproc 16384

* soft nofile 4096

* hard nofile 65536

* soft stack 10240

Install the following packages if they are not already present.

rpm -Uvh binutils-2.*

rpm -Uvh compat-libstdc++-33*

rpm -Uvh compat-libstdc++-33*.i386.rpm

rpm -Uvh elfutils-libelf*

rpm -Uvh gcc-4.*

rpm -Uvh gcc-c++-4.*

rpm -Uvh glibc-2.*

rpm -Uvh glibc-common-2.*

rpm -Uvh glibc-devel-2.*

rpm -Uvh glibc-headers-2.*

rpm -Uvh ksh*

rpm -Uvh libaio-0.*

rpm -Uvh libaio-devel-0.*

rpm -Uvh libgomp-4.*

rpm -Uvh libgcc-4.*

rpm -Uvh libstdc++-4.*

rpm -Uvh libstdc++-devel-4.*

rpm -Uvh make-3.*

rpm -Uvh sysstat-7.*

rpm -Uvh unixODBC-2.*

rpm -Uvh unixODBC-devel-2.*

rpm -Uvh numactl-devel-*



Create the new groups and users.

groupadd oinstall

groupadd dba

groupadd oper

groupadd asmadmin



useradd -g oinstall -G dba,oper,asmadmin oracle

passwd oracle

Note. We are not going to use the "asmadmin" group, since this installation will not use ASM.

Additional Setup

The following setup tasks must be performed regardless of which setup method you used previously.

Disable secure linux by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.

SELINUX=disabled

Create the directories in which the Oracle software will be installed.

mkdir -p /u01/app/oracle/product/11.2.0/db_1

chown -R oracle:oinstall /u01

chmod -R 775 /u01

Login as root and issue the following command.

xhost +

Login as the oracle user and add the following lines at the end of the ".bash_profile" file, remembering to adjust them for your specific installation.

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR



ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME

ORACLE_SID=SHODB11G; export ORACLE_SID

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/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.

DISPLAY=:0.0; export DISPLAY

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.

./runInstaller

Post Installation

Edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.

SHODB11G:/u01/app/oracle/product/11.2.0/db_1:Y





*************************************

rpm -qa | grep binutils-2.*

rpm -qa | grep compat-libstdc++-33*

rpm -qa | grep compat-libstdc++-33*

rpm -qa | grep elfutils-libelf*

rpm -qa | grep gcc-4.*

rpm -qa | grep gcc-c++-4.*

rpm -qa | grep glibc-2.*

rpm -qa | grep glibc-common-2.*

rpm -qa | grep glibc-devel-2.*

rpm -qa | grep glibc-headers-2.*

rpm -qa | grep ksh*

rpm -qa | grep libaio-0.*

rpm -qa | grep libaio-devel-0.*

rpm -qa | grep libgomp-4.*

rpm -qa | grep libgcc-4.*

rpm -qa | grep libstdc++-4.*

rpm -qa | grep libstdc++-devel-4.*

rpm -qa | grep make-3.*

rpm -qa | grep sysstat-7.*

rpm -qa | grep unixODBC-2.*

rpm -qa | grep unixODBC-devel-2.*

rpm -qa | grep numactl-devel-*









rpm -ivh binutils-2.*

rpm -ivh compat-libstdc++-33*

rpm -ivh elfutils-libelf*

rpm -ivh gcc-4.*

rpm -ivh gcc-c++-4.*

rpm -ivh glibc-2.*

rpm -ivh glibc-common-2.*

rpm -ivh kernel-headers-2.6.18-53.el5.i386.rpm

rpm -ivh glibc-headers-2.5-18.i386.rpm

rpm -ivh gcc-4.1.2-14.el5.i386.rpm

rpm -ivh gcc-c++-4.1.2-14.el5.i386.rpm

rpm -ivh --force compat-libstdc++-33*.i386.rpm

rpm -ivh --force glibc-devel-2.*

rpm -ivh --force glibc-headers-2.*

rpm -ivh ksh*

rpm -ivh libaio-0.*

rpm -ivh libaio-devel-0.*

rpm -ivh libgomp-4.*

rpm -ivh libgcc-4.*

rpm -ivh libstdc++-4.*

rpm -ivh libstdc++-devel-4.*

rpm -ivh make-3.*

rpm -ivh sysstat-7.*

rpm -ivh unixODBC-2.*

rpm -ivh unixODBC-devel-2.*

rpm -ivh numactl-devel-*

rpm -ivh --force elfutils-libelf-devel-*

No comments:

Post a Comment

ORA-12519: TNS:no appropriate service handler found error

ORA-12519: TNS: no appropriate service handler found error The real problem lies in the PROCESSES parameter All you need ...