Oracle Database 11g Installation on Redhat Linux 5

Check Physical Memory

 (At least 1GB of physical Memory (RAM) is required. EX: 2059516 kB) 

$ grep MemTotal /proc/meminfo

Check Swap Space.

(RAM is 2GB, so you have 3GB of Swap Size EX: 3148732 kB)

$ grep SwapTotal /proc/meminfo

If you don’t have a swap size 3gb. so you need to add one more swap file.

Check space available in /tmp

(You need to have at least 150M to 200M of space in the /tmp directory.)

$ df -h /tmp

Create new Usergroup and User Account

Login to root

/usr/sbin/groupadd oinstall

/usr/sbin/groupadd dba

/usr/sbin/useradd -g oinstall -G dba oracle

/usr/bin/passwd oracle

Create directories where the Oracle Software and database will be installed.

$ mkdir -p /u01 or (/u01/app/oracle/product/11.2.0/dbhome_1)

$ chown -R oracle:oinstall /u01

$ chmod -R 775 /u01

Disk space requirements in /U01

(You need to have at least 10BG to 20GB of space in the /U01 directory.)

# df -h /u01

Next we need to adjust the Linux Kernel Parameters to support Oracle.

Open /etc/sysctl.conf and add the following lines:

fs.file-max = 65536

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 1024 65500

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

Make the kernel parameters changes effective immediately

$ /sbin/sysctl -p

Now set the shell limits for the user Oracle.

Open /etc/security/limits.confand add these lines.

oracle           soft    nproc   2047

oracle           hard    nproc   16384

oracle           soft    nofile  1024

oracle           hard    nofile  65536

Where "nproc" is the maximum number of processes available to the user and "nofiles" is the number of open file descriptors.

Open /etc/pam.d/login and add the following line if it is already not there.

session    required     pam_limits.so

Disable secure linux

Open  /etc/selinux/configfile, making sure the SELINUX flag is set as follows:

SELINUX=disabled

Now switch to the user oracle.

$ su – oracle

$ echo $SHELL

If the returned shell is bash then open ~/.bash_profile and add these lines:

# Oracle settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

# If /tmp doesn't have 200M space free then you can workaround it by

# pointing the variables TMP AND TMPDIR to a location where you have 

# sufficient space.

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

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

ORACLE_SID=ora11g; export ORACLE_SID

ORACLE_TERM=xterm; export ORACLE_TERM

PATH=$ORACLE_HOME/bin:/usr/sbin:$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

umask 022

Now run the following command to make these changes effective in the current session of user oracle.

-- for bash shell

$ source ~/.bash_profile

Once the unzip is finished go to the "database" directory unzipped in the previous step and start the Oracle Universal Installer.
Copy into database to /u01 directory

$ cd u01/database

$ ./runInstaller

Open another console and login as root. Execute following two scripts once logged in successfully.

$ /u01/app/oraInventory/orainstRoot.sh

$ /u01/app/oracle/product/11.2.0/dbhome_1/root.sh

After that login to Oracle user and connect sqlplus

$ sqlplus / as sysdba

Check oracle installed version using below query.

SQL> select * from v$version;

If Database not yet started use below commands to start database.

SQL>startup

And check listener status if u want to connect oracle tools (EX: Toad..)

SQL>lsnrctl status

Start Listener

----------------

SQL>lsnrctl start

Check Listener.ora file for host and port no.

/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/

L1 =

  (ADDRESS_LIST =

     (ADDRESS= (PROTOCOL= TCP)(Host= localhost)(Port= 1521))

  )

SID_LIST_L1 =

  (SID_LIST =

    (SID_DESC =

      (ORACLE_HOME= $ORACLE_HOME)

      (SID_NAME = orcl)

    )

  )

If u have more than one listener when starting listener services use listener name:

EX:

SQL> lsnrctl start L1



SQL> lsnrctl status L1



SQL> lsnrctl stop L1

If u want to connect to TOAD

Find the ip address using   

$ip addr

EX:

Connect to toad 192.168.48.134 and SID: ORCL

Colour view error :

loginto root and

$   xhost location or  ( Ip Address ex:198.168.48.134)

$ xhost +

set DISPLAY your Domain and host.

$ DISPLAY=localhost.localdomain:0.0

$ export DISPLAY

$echo $DISPLAY

Add swap file space

Login to Root User in LINUX:

Determine the size of the new swap file and multiple by 1024 to determine the block size. For example, the block size of a 64 MB swap file is 65536.

At a shell prompt as root, type the following command with count being equal to the desired block size:

$ dd if=/dev/zero of=/swapf bs=1024 count=65536

Setup the swap file with the command:

$ mkswap /swapf

To enable the swap file immediately but not automatically at boot time:

$ swapon /swapf

Edit and add blow line in /etc/fstab

/swapf swap swap defaults 0 0

Restart your system and its will effect new swap file.

After that check that the swap file size is added or not using below command

$cat /proc/swaps

Then if u wants to remove or disable your added swap file use below commands.

Login to root user

$su – root

Disable swap file.

$swapoff swapfile

Removing swap file.

$ rm swapfile

JAVA HOSTSPOT VM client Error

Download below patch no( 8670579) this is oracle 11G R2 in linux 32 bit bub.

[applmgr@centos53server ~]$ dbua

#

# An unexpected error has been detected by HotSpot Virtual Machine:

#

#  SIGSEGV (0xb) at pc=0x9fdf64d4, pid=3662, tid=3086928080

#

# Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode)

# Problematic frame:

# C  [libnnz11.so+0x3c4d4]

#

# An error report file with more information is saved as hs_err_pid3662.log

#

# If you would like to submit a bug report, please visit:

#   http://java.sun.com/webapps/bugreport/crash.jsp

#

Aborted

we can apply this patch two ways

extract the zip file and copy config folder into your oracle home config folder

and lib folder all files into oracle home lib folder replace it.

and xml folder direct copy into your oracle home dir.

or

unzip above folder ( 8670579) and copy into oracle_home/OPatch/8670579

in linux

$ 8670579>opatch apply