Wednesday, June 6, 2012

Oracle 10g Release 2 Installation On RHEL5

Oracle Database 10g Release 2 Installation On Red Hat Enterprise Linux 5 (RHEL5)

In installation we require a minimum of 2G swap, secure Linux disabled and the following package groups installed.

 GNOME Desktop Environment
 Editors * Graphical Internet
 Text-based Internet
 Development Libraries
 Development Tools
 Legacy Software Development
 Server Configuration Tools
 Administration Tools
 Base Legacy Software Support
 System Tools
 X Window System

Unzip the Installation files.

unzip 10201_database_linux32.zip

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

Hosts File

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

Set Kernel Parameters

Add the following lines to the "/etc/sysctl.conf" file.

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

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 1024
* hard nofile 65536

Add the following line to the "/etc/pam.d/login" file, if it does not already exist.

session required pam_limits.so

Disable secure linux by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows. SELINUX=disabled
Alternatively, this alteration can be done using the GUI tool (System > Administration > Security Level and Firewall). Click on the SELinux tab and disable the feature.

Setup Install the following packages. cd /media/cdrom/Server

rpm -ivh setarch-2*
rpm -ivh make-3*
rpm -ivh glibc-2*
rpm -ivh libaio-0*
rpm -ivh compat-libstdc++-33-3*
rpm -ivh compat-gcc-34-3*
rpm -ivh compat-gcc-34-c++-3*
rpm -ivh gcc-4*
rpm -ivh libXp-1*
rpm -ivh openmotif-2*
rpm -ivh compat-db-4*

To check whether the package is already installed or not

rpm -qa | grep

Create the new groups and users.

groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle

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

mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01

Login as root and issue the following command. xhost +

Edit the "/etc/redhat-release" file replacing the current release information (Red Hat Enterprise Linux Server release 5 (Tikanga)) with the following: redhat-4

Login as the oracle user and add the following lines at the end of the ".bash_profile" file.

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME ORACLE_SID=shoaib;
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/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
                 ulimit -n 65536
       fi
fi

Installation Log into the oracle user.
If you are using X emulation (Xmanager or VNC) 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/redhat-release" file restoring the original release information. Red Hat Enterprise Linux Server release 5 (Tikanga) Edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.

shoaib:/u01/app/oracle/product/10.2.0/db_1:Y

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