Get a Free iPhone 4 from Xpango - click here

Friday, October 8, 2010

Oracle 11g Release 2 Installation on Linux


Installation of Oracle 11g Release 2 on Linux.

Supported Operating Systems

on 32-bit Linux:

Asianux 2 Update 7 (Kernel 2.6.9 or later)
Asianux 3 (Kernel 2.6.18 or later)
Oracle Enterprise Linux 4 Update 7 (Kernel 2.6.9 or later)
Oracle Enterprise Linux 5 Update 2 (Kernel 2.6.18 or later)
Red Hat Enterprise Linux 4 Update 7 (Kernel 2.6.9 or later)
Red Hat Enterprise Linux 5 Update 2 (Kernel 2.6.18 or later)
SUSE Linux Enterprise Server 10 SP2 (Kernel 2.6.16.21 or later)
SUSE Linux Enterprise Server 11 (2.6.27.19 or later)

Oracle Database 11g Release 2 is not certified on fedora 13.I will show you the workaround to install on Fedora 13.

Set Kernel Parameters.
Edit /etc/sysctl.conf file to add these kernel parameters.The file should reflect this value

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

Execute the following command to update the parameters

# /sbin/sysctl -p

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

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle 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

For Fedora 13
Edit /etc/redhat-release file as follows:

redhat release 5


Some additional packages are required for succesful installation of Oracle software. To check whether required packages are installed on your operating system use following command:

rpm -q binutils elfutils elfutils-libelf gcc gcc-c++ glibc glibc-common glibc-devel compat-libstdc++-33 cpp make compat-db sysstat libaio libaio-devel unixODBC unixODBC-devel| ksh sysstat make
Create new groups and users:

groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin

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

Create Directories in which Oracle software will be installed:

mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 755 /u01


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

# Oracle Settings
ORACLE_HOSTNAME=localhost; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; 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


Login as root and enter the following command:
xhost +

Download Oracle Database 11g R2 from Oracle and place the two file into the same directory:
unzip linux_11gR2_database_1of2.zip
unzip linux_11gR2_database_2of2.zip
You should now have a single directory called database.

Run the Oracle Universal Installer
cd database
./runInstaller


In Fedora 13 ,you will get link error:
Error invoking target 'agent nmhs' of make file

To fix it:
Edit $ORACLE_HOME/sysman/lib/ins_emagent.mk,
Search for the line $(MK_EMAGENT_NMECTL) and replace the line with $(MK_EMAGENT_NMECTL) -lnnz11
Make sure Installer is open.Once file is saved click retry.





1 comment:

  1. thanks for your help, but have a question : for the " -lnnz11 " is it a "-1" or a "-l" because i've tried an "-l..." it was wrong but when i tried out the " -1.." it was ok!

    ReplyDelete