ORACLE RAC-INFO

ORACLE_GRID_INSTALLATION FOR STANDALONE SERVER

server ip = 10.65.127.37 LINUX

Step 1: Download Oracle Software for grid 12c

Download and unzip the software

Step 2: check Memory, Swap & kernel

[root@localhost ~]# grep MemTotal /proc/meminfo

MemTotal: 2075468 kB

Memory Min : 1.5 GB need.

[root@localhost ~]# grep SwapTotal /proc/meminfo

SwapTotal: 4128760 kB

[root@localhost ~]# df -h /tmp

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VolGroup00-LogVol00

21G 4.4G 15G 23% /

[root@localhost ~]# gedit /etc/sysctl.conf

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 2147483648

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

net.core.wmem_max=1048576

[root@localhost ~]#/sbin/sysctl -p

[root@localhost ~]# gedit /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

[root@localhost ~]# gedit /etc/pam.d/login

session required /lib/security/pam_limits.so

session required pam_limits.so

Selinux =Disabled

[root@localhost ~]# gedit /etc/selinux/config

SELINUX=disabled

[root@RCFNEWDRDB 12c]# cat /etc/oracle-release

Oracle Linux Server release 5.6

[root@RCFNEWDRDB 12c]# lsb_release -id

Distributor ID: EnterpriseEnterpriseServer

Description: Enterprise Linux Enterprise Linux Server release 5.6 (Carthage)

[root@RCFNEWDRDB 12c]# uname -r

2.6.32-100.26.2.el5

Step 3: Install RPM Package

compat-libstdc++-33-3.2.3-63.i386.rpm

elfutils-libelf-devel-0.137-3.el5.i386.rpm

elfutils-libelf-devel-static-0.137-3.el5.i386.rpm

gcc-4.1.2-48.el5.i386.rpm

gcc-c++-4.1.2-48.el5.i386.rpm

glibc-devel-2.5-49.i386.rpm

glibc-headers-2.5-49.i386.rpm

kernel-headers-2.6.18-194.el5.i386.rpm

libaio-devel-0.3.106-3.2.i386.rpm

libgomp-4.4.0-6.el5.i386.rpm

libstdc++-devel-4.1.2-48.el5.i386.rpm

sysstat-7.0.2-3.el5.i386.rpm

unixODBC-2.2.11-7.1.i386.rpm

unixODBC-devel-2.2.11-7.1.i386.rpm

note : install mandatatory packages required for asm.

[root@RCFNEWDRDB 12c]# hostname

RCFNEWDRDB

[root@RCFNEWDRDB 12c]# cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 RCFNEWDRDB localhost.localdomain localhost

::1 localhost6.localdomain6 localhost6

10.65.127.37 RCFNEWDRDB.reliancecapital.com RCFNEWDRDB

Step 4: ADD User, Group using root

/usr/sbin/groupadd -g 701 oinstall

/usr/sbin/groupadd -g 702 dba

/usr/sbin/groupadd -g 703 oper

/usr/sbin/groupadd -g 1102 asmdba

/usr/sbin/groupadd -g 1103 asmadmin

/usr/sbin/groupadd -g 1104 asmoper

/usr/sbin/useradd -u 902 -m -d /home/oracle -g oinstall -G dba,oper,asmdba -s /bin/bash -c "Oracle Home 11gR2 Owner" oracle

root@localhost ~]# passwd oracle

Step 5 :Make Directory respectively

create the Oracle Inventory Directory

mkdir -p /oracle/app/oraInventory

chown -R oracle:oinstall /oracle/app/oraInventory

chmod -R 775 /oracle/app/oraInventory

Creating the Oracle Base Directory for Oracle Grid installation

mkdir -p /oracle/app/grid

chown -R oracle:oinstall /oracle/app/grid

chmod -R 775 /oracle/app/grid

Creating the Oracle Grid Infrastructure Home Directory

mkdir -p /oracle/app/grid/product/12.1.0.2/grid

chown -R oracle:oinstall /oracle/app/grid

chmod -R 775 /oracle/app/grid

Creating the Oracle Base Directory for Oracle Database installation

mkdir -p /oracle/app/oracle

chown -R oracle:oinstall /oracle/app/oracle

chmod -R 775 /oracle/app/oracle

Creating the Oracle RDBMS Home Directory

for 11g

mkdir -p /oracle/app/oracle/product/11.2.0.3

chown -R oracle:oinstall /oracle/app/oracle/product/11.2.0.3

chmod -R 775 /u01/app/oracle/product/11.2.0.3

for 12c

mkdir -p /oracle/app/oracle/product/12.1.0.2

chown -R oracle:oinstall /oracle/app/oracle/product/12.1.0.2

chmod -R 775 /oracle/app/oracle/product/12.1.0.2

[root@RCFNEWDRDB ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda2 29G 4.8G 23G 18% /

/dev/sda8 965M 194M 722M 22% /var

/dev/sda7 965M 18M 898M 2% /opt

/dev/sda6 48G 180M 45G 1% /oracle

/dev/sda5 95G 7.5G 83G 9% /oradata

/dev/sda1 965M 60M 856M 7% /boot

tmpfs 16G 0 16G 0% /dev/shm

[root@RCFNEWDRDB ~]# cat /etc/pam.d/login

[root@RCFNEWDRDB ~]# uname -a

Linux RCFNEWDRDB 2.6.32-100.26.2.el5 #1 SMP Tue Jan 18 20:11:49 EST 2011 x86_64 x86_64 x86_64 GNU/Linux

[root@RCFNEWDRDB ~]# cat /proc/partitions

major minor #blocks name

8 0 292421632 sda

8 1 1020096 sda1

8 2 30716280 sda2

8 3 16386300 sda3

8 4 1 sda4

8 5 102398278 sda5

8 6 51199123 sda6

8 7 1020096 sda7

8 8 1020096 sda8

[root@RCFNEWDRDB ~]# cd /dev

[root@RCFNEWDRDB dev]# ls -lrt sda*

brw-r----- 1 root disk 8, 0 May 23 20:29 sda

brw-r----- 1 root disk 8, 3 May 23 20:29 sda3

brw-r----- 1 root disk 8, 4 May 23 20:29 sda4

brw-r----- 1 root disk 8, 2 May 23 20:29 sda2

brw-r----- 1 root disk 8, 8 May 23 20:29 sda8

brw-r----- 1 root disk 8, 7 May 23 20:29 sda7

brw-r----- 1 root disk 8, 6 May 23 20:29 sda6

brw-r----- 1 root disk 8, 5 May 23 20:29 sda5

brw-r----- 1 root disk 8, 1 May 23 20:29 sda1

[root@RCFNEWDRDB dev]# /sbin/fdisk -l

Disk /dev/sda: 299.4 GB, 299439751168 bytes

255 heads, 63 sectors/track, 36404 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/dev/sda1 * 1 127 1020096 83 Linux

/dev/sda2 128 3951 30716280 83 Linux

/dev/sda3 3952 5991 16386300 82 Linux swap / Solaris

/dev/sda4 5992 36404 244292422+ 5 Extended

/dev/sda5 5992 18739 102398278+ 83 Linux

/dev/sda6 18740 25113 51199123+ 83 Linux

/dev/sda7 25114 25240 1020096 83 Linux

/dev/sda8 25241 25367 1020096 83 Linux

step 5 : we create new partition for sda i.e sda9 and sda10

[root@RCFNEWDRDB ~]# /sbin/fdisk /dev/sda

The number of cylinders for this disk is set to 36404.

There is nothing wrong with that, but this is larger than 1024,

and could in certain setups cause problems with:

1) software that runs at boot time (e.g., old versions of LILO)

2) booting and partitioning software from other OSs

(e.g., DOS FDISK, OS/2 FDISK)

Command (m for help): m

Command action

a toggle a bootable flag

b edit bsd disklabel

c toggle the dos compatibility flag

d delete a partition

l list known partition types

m print this menu

n add a new partition

o create a new empty DOS partition table

p print the partition table

q quit without saving changes

s create a new empty Sun disklabel

t change a partition's system id

u change display/entry units

v verify the partition table

w write table to disk and exit

x extra functionality (experts only)

Command (m for help): n

First cylinder (25368-36404, default 25368): 25368

Last cylinder or +size or +sizeM or +sizeK (25368-36404, default 36404): 26000

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

WARNING: Re-reading the partition table failed with error 16: Device or resource busy.

The kernel still uses the old table.

The new table will be used at the next reboot.

Syncing disks.

[root@RCFNEWDRDB ~]# /sbin/fdisk -l

Disk /dev/sda: 299.4 GB, 299439751168 bytes

255 heads, 63 sectors/track, 36404 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/dev/sda1 * 1 127 1020096 83 Linux

/dev/sda2 128 3951 30716280 83 Linux

/dev/sda3 3952 5991 16386300 82 Linux swap / Solaris

/dev/sda4 5992 36404 244292422+ 5 Extended

/dev/sda5 5992 18739 102398278+ 83 Linux

/dev/sda6 18740 25113 51199123+ 83 Linux

/dev/sda7 25114 25240 1020096 83 Linux

/dev/sda8 25241 25367 1020096 83 Linux

/dev/sda9 25368 26000 5084541 83 Linux

/dev/sda10 26001 27000 8032468+ 83 Linux

[root@RCFNEWDRDB dev]# /sbin/partprobe

[root@RCFNEWDRDB dev]# rpm -qa |grep -i oracleasm

[root@RCFNEWDRDB dev]# /etc/init.d/oracleasm configure

[root@RCFNEWDRDB dev]#

[root@RCFNEWDRDB dev]# /etc/init.d/oracleasm status

STEP 6: CREATE DISKGROUP AT OS LEVEL

[DRDB dev]# /etc/init.d/oracleasm createdisk DATA_RCDB /dev/sda9

dev]# /etc/init.d/oracleasm createdisk RECO_RCDB /dev/sda10

RDB dev]# /etc/init.d/oracleasm listdisks

DATA_RCDB

RECO_RCDB

[root@RCFNEWDRDB dev]#

[root@RCFNEWDRDB dev]# ls -rlt /dev/oracleasm/disks/*

brw-rw---- 1 oracle oinstall 8, 9 May 24 12:22 /dev/oracleasm/disks/DATA_RCDB

brw-rw---- 1 oracle oinstall 8, 10 May 24 12:22 /dev/oracleasm/disks/RECO_RCDB

dev]# /etc/init.d/oracleasm querydisk -d -p /dev/sda*

STEP 7

Go to unzip path and start the ./runinstaller