Home > oracle-install > Installation of Oracle 10g R2 (10.2.0.4) on RedHat EL 5

Installation of Oracle 10g R2 (10.2.0.4) on RedHat EL 5

This article describes step-by-step installation of Oracle 10g R2 database software on RedHat Enterprise Linux 5.

Pre-Instalation Tasks:
Step1)Create oracle dba group and user account.

Log in as root and create oracle user account which belongs to dba group.
 su –
[root@oral01 ~]# groupadd -g 1000 dba
[root@oral01 ~]# echo $?
0
[root@oral01 ~]# useradd -m -s /bin/ksh -g dba -u 1000 oracle
[root@oral01 ~]# echo $?
0
[root@oral01 ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@oral01 ~]# id oracle
uid=1000(oracle) gid=1000(dba) groups=1000(dba)

Login as the oracle user and add the following lines .profile :

#########################################
export VISUAL=vi
export EDITOR=/usr/bin/vi
ENV=$HOME/.kshrc
export ENV
umask 022
stty erase ^?
export HOST=`hostname`
export PS1=’$HOST:$PWD>’
export PS2=”$HOST:`pwd`>>”
export PS3=”$HOST:`pwd`==”
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0.4/db_1
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
unalias ls

############################

Set Kernel Parameters

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

fs.file-max=327679
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 142
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4294967295
net.core.rmem_default = 262144
net.core.rmem_max=2097152
net.core.wmem_default = 262144
net.core.wmem_max=262144
fs.aio-max-nr = 3145728
net.ipv4.ip_local_port_range=1024 65000

[root@oral01 ~]# sysctl -p

Add the following lines to the /etc/security/limits.conf file:
oracle   soft   nofile    131072
oracle   hard   nofile    131072
oracle   soft   nproc    131072
oracle   hard   nproc    131072
oracle   soft   core    unlimited
oracle   hard   core    unlimited
oracle   soft   memlock    3500000
oracle   hard   memlock    3500000

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

SELINUX=disabled

mkdir -p /u01/app/oracle

Configure oracleasm :
[root@oral01 tmp]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets (‘[]’).  Hitting without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]

[root@oral01 tmp]# oracleasm createdisk ASM1 /dev/sdc1
Writing disk header: done
Instantiating disk: done
[root@oral01 tmp]# oracleasm listdisks
ASM1

Installation:

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

DISPLAY=:0.0; export DISPLAY

We are installing oracle 10.2.0.1 on RHEL5 and you will get os not certified and you can safely ignore it.

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

./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3,

SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed

All installer requirements met.

Preparing to launch Oracle Universal  
Installer from /tmp/OraInstall2011-02-05_11-19-20PM. 

 Please wait …oral01.ukatru.com:/u01/database>Oracle Universal Installer, Version 10.2.0.1.0 Production

Copyright (C) 1999, 2005, Oracle. All rights reserved

 [root@oral01 oraInventory]# ./orainstRoot.sh
Changing permissions of /u01/app/oraInventory to 770.
Changing groupname of /u01/app/oraInventory to dba.
The execution of the script is complete

[root@oral01 asm]# /u01/app/oracle/product/10.2.0/asm/root.sh
Running Oracle10 root.sh script…

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/asm

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin …
   Copying oraenv to /usr/local/bin …
   Copying coraenv to /usr/local/bin …

Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed

Step 2:Install Database home.

  /u01/app/oracle/product/10.2.0.4/db_1/root.sh
Running Oracle10 root.sh script…

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0.4/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file “dbhome” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file “oraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file “coraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

 Step 3:Applying oracle 10g R2  patch set 3 on both Asm and Database homes.

Step 3:Create and start ASM instance.
oral01.ukatru.com:/u01/app/oracle/product/10.2.0/asm>export ORACLE_HOME=/u01/app/oracle/product/10.2.0/asm
oral01.ukatru.com:/u01/app/oracle/product/10.2.0/asm>export ORACLE_SID=+ASM
oral01.ukatru.com:/u01/app/oracle/product/10.2.0/asm/bin>./dbca &
[1]     25327

[root@oral01 bin]# ./localconfig add
/etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process…
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
        oral01
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)

oral01.ukatru.com:/u01/app/oracle/product/10.2.0/asm/bin>ps -ef | grep asmoracle   25626     1  0 00:06 ?        00:00:00 /u01/app/oracle/product/10.2.0/asm/bin/ocssd.bin
oracle   25887     1  0 00:08 ?        00:00:00 asm_pmon_+ASM
oracle   25889     1  0 00:08 ?        00:00:00 asm_psp0_+ASM
oracle   25891     1  0 00:08 ?        00:00:00 asm_mman_+ASM
oracle   25893     1  0 00:08 ?        00:00:00 asm_dbw0_+ASM
oracle   25895     1  0 00:08 ?        00:00:00 asm_lgwr_+ASM
oracle   25897     1  0 00:08 ?        00:00:00 asm_ckpt_+ASM
oracle   25899     1  0 00:08 ?        00:00:00 asm_smon_+ASM
oracle   25901     1  0 00:08 ?        00:00:00 asm_rbal_+ASM
oracle   25903     1  0 00:08 ?        00:00:00 asm_gmon_+ASM

Step 4:Create Database
export ORACLE_HOME=/u01/app/oracle/product/10.2.0.4/db_1

 

SQL> select INSTANCE_NAME,HOST_NAME,VERSION from v$instance;

INSTANCE_NAME
—————-
HOST_NAME
—————————————————————-
VERSION
—————–
oradv1
oral01.ukatru.com
10.2.0.4.0

Advertisements
Categories: oracle-install
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: