Thursday 2 July 2015


Operating System(Linux)  Level (Oracle Related)Setup before you actually install Oracle Clusterware for your RAC setup:




[root@MYINSLGGNSBIDB6 ~]# groupadd -g 1001 oinstall
[root@MYINSLGGNSBIDB6 ~]# groupadd -g 1200 dba
[root@MYINSLGGNSBIDB6 ~]# groupadd -g 205 oper
[root@MYINSLGGNSBIDB6 ~]# groupadd -g 203 asmdba
[root@MYINSLGGNSBIDB6 ~]# groupadd -g 204 asmoper
[root@MYINSLGGNSBIDB6 ~]# groupadd -g 206 asmadmin

useradd -u 1100 -g oinstall -G dba grid
useradd -u 1101 -g oinstall -G dba oracle
usermod -u 1101 -g 1001 -G 1200,203,205,206 oracle
usermod -u 1100 -g 1001 -G 1200,203,204,206 grid

Node1

[oracle@SRVTLPYRDORA02 ~]$ id
uid=1101(oracle) gid=1001(oinstall) groups=1001(oinstall),203(asmdba),205(oper),206(asmadmin),1200(dba)
[grid@SRVTLPYRDORA02 ~]$ id
uid=1100(grid) gid=1001(oinstall) groups=1001(oinstall),203(asmdba),204(asmoper),206(asmadmin),1200(dba)

Node2

[oracle@SRVTLPYRDORA03 ~]$ id
uid=1101(oracle) gid=1001(oinstall) groups=1001(oinstall),203(asmdba),205(oper),206(asmadmin),1200(dba)
[grid@SRVTLPYRDORA03 ~]$ id
uid=1100(grid) gid=1001(oinstall) groups=1001(oinstall),203(asmdba),204(asmoper),206(asmadmin),1200(dba)

On Both Node================

mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
chown -R oracle:oinstall /u01/
chmod -R 775 /u01/

mkdir -p /u02/grid/app/11.2.0/grid
chown -R grid:oinstall /u02/
chmod -R 775 /u02/


ORACLEASMCONFIGURE@SRVTLPYRDORA02<mailto:CONFIGURE@SRVTLPYRDORA02


[root@SRVTLPYRDORA02 ~]#  /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 <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.
Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]


[root@SRVTLPYRDORA02 ~]# cat /etc/sysconfig/oracleasm-_dev_oracleasm
#
# This is a configuration file for automatic loading of the Oracle
# Automatic Storaee Manaeement library kernel driver.  It is eenerated
# By running /etc/init.d/oracleasm configure.  Please use that method
# to modify this file
#
# ORACLEASM_ENABLED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true
# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=grid
# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=asmadmin
# ORACLEASM_SCANBOOT: 'true' means scan for ASM disks on boot.
ORACLEASM_SCANBOOT=true
# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER=""
# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE=""
# ORACLEASM_USE_LOGICAL_BLOCK_SIZE: 'true' means use the logical block size
# reported by the underlying disk instead of the physical. The default
# is 'false'
ORACLEASM_USE_LOGICAL_BLOCK_SIZE=false


[root@SRVTLPYRDORA02 ~]# vi /etc/sysconfig/oracleasm-_dev_oracleasm


[root@SRVTLPYRDORA02 ~]# cat /etc/sysconfig/oracleasm-_dev_oracleasm
#
# This is a configuration file for automatic loading of the Oracle
# Automatic Storaee Manaeement library kernel driver.  It is eenerated
# By running /etc/init.d/oracleasm configure.  Please use that method
# to modify this file
#
# ORACLEASM_ENABLED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true
# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=grid
# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=asmadmin
# ORACLEASM_SCANBOOT: 'true' means scan for ASM disks on boot.
ORACLEASM_SCANBOOT=true
# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER="dm"
# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE="sd"
# ORACLEASM_USE_LOGICAL_BLOCK_SIZE: 'true' means use the logical block size
# reported by the underlying disk instead of the physical. The default
# is 'false'
ORACLEASM_USE_LOGICAL_BLOCK_SIZE=false


[root@SRVTLPYRDORA02 ~]# cat /etc/sysconfig/oracleasm
#
# This is a configuration file for automatic loading of the Oracle
# Automatic Storaee Manaeement library kernel driver.  It is eenerated
# By running /etc/init.d/oracleasm configure.  Please use that method
# to modify this file
#
# ORACLEASM_ENABLED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true
# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=grid
# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=asmadmin
# ORACLEASM_SCANBOOT: 'true' means scan for ASM disks on boot.
ORACLEASM_SCANBOOT=true
# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER="dm"
# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE="sd"
# ORACLEASM_USE_LOGICAL_BLOCK_SIZE: 'true' means use the logical block size
# reported by the underlying disk instead of the physical. The default
# is 'false'
ORACLEASM_USE_LOGICAL_BLOCK_SIZE=false
[root@SRVTLPYRDORA02 ~]# service oracleasm stop
Dropping Oracle ASMLib disks:                              [  OK  ]
Shutting down the Oracle ASMLib driver:                    [  OK  ]
[root@SRVTLPYRDORA02 ~]# service oracleasm start
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]



DISK CREATION@SRVTLPYRDORA02<mailto:CREATION@SRVTLPYRDORA02>-------------

oracleasm createdisk OCRDATA1  /dev/rout/rawdisk5
oracleasm createdisk OCRDATA2  /dev/rout/rawdisk6
oracleasm createdisk VOTEDATA1 /dev/rout/rawdisk7
oracleasm createdisk VOTEDATA2 /dev/rout/rawdisk8


[root@SRVTLPYRDORA02 ~]# oracleasm createdisk OCRDATA1  /dev/rout/rawdisk5
Writing disk header: done
Instantiating disk: done

[root@SRVTLPYRDORA02 ~]# oracleasm createdisk OCRDATA2  /dev/rout/rawdisk6
Writing disk header: done
Instantiating disk: done

[root@SRVTLPYRDORA02 ~]#
[root@SRVTLPYRDORA02 ~]# oracleasm createdisk VOTEDATA1 /dev/rout/rawdisk7
Writing disk header: done
Instantiating disk: done

[root@SRVTLPYRDORA02 ~]#
[root@SRVTLPYRDORA02 ~]# oracleasm createdisk VOTEDATA2 /dev/rout/rawdisk8
Writing disk header: done
Instantiating disk: done

[root@SRVTLPYRDORA02 ~]# oracleasm listdisks
OCRDATA1
OCRDATA2
VOTEDATA1
VOTEDATA2

[root@SRVTLPYRDORA02 ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...

[root@SRVTLPYRDORA02 ~]# oracleasm listdisks
OCRDATA1
OCRDATA2
VOTEDATA1
VOTEDATA2


[root@SRVTLPYRDORA02 ~]# ls -l /dev/rout/raw*
lrwxrwxrwx 1 root root 7 Nov 15 17:47 /dev/rout/rawdisk1 -> ../dm-7
lrwxrwxrwx 1 root root 7 Nov 15 17:47 /dev/rout/rawdisk2 -> ../dm-5
lrwxrwxrwx 1 root root 7 Nov 15 17:47 /dev/rout/rawdisk3 -> ../dm-4
lrwxrwxrwx 1 root root 7 Nov 15 17:47 /dev/rout/rawdisk4 -> ../dm-2
lrwxrwxrwx 1 root root 7 Nov 15 17:47 /dev/rout/rawdisk5 -> ../dm-6
lrwxrwxrwx 1 root root 7 Nov 15 17:47 /dev/rout/rawdisk6 -> ../dm-9
lrwxrwxrwx 1 root root 8 Nov 15 17:47 /dev/rout/rawdisk7 -> ../dm-10
lrwxrwxrwx 1 root root 7 Nov 15 17:47 /dev/rout/rawdisk8 -> ../dm-8



------------------------SRVTLPYRDORA03---------------------------------------------


[root@SRVTLPYRDORA03 ~]# /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 <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.
Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]


[root@SRVTLPYRDORA03 ~]# vi /etc/sysconfig/oracleasm-_dev_oracleasm

[root@SRVTLPYRDORA03 ~]# cat /etc/sysconfig/oracleasm-_dev_oracleasm
#
# This is a configuration file for automatic loading of the Oracle
# Automatic Storaee Manaeement library kernel driver.  It is eenerated
# By running /etc/init.d/oracleasm configure.  Please use that method
# to modify this file
#
# ORACLEASM_ENABELED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true
# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=grid
# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=asmadmin
# ORACLEASM_SCANBOOT: 'true' means scan for ASM disks on boot.
ORACLEASM_SCANBOOT=true
# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER="dm"
# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE="sd"


[root@SRVTLPYRDORA03 ~]# cat /etc/sysconfig/oracleasm
#
# This is a configuration file for automatic loading of the Oracle
# Automatic Storaee Manaeement library kernel driver.  It is eenerated
# By running /etc/init.d/oracleasm configure.  Please use that method
# to modify this file
#
# ORACLEASM_ENABELED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true
# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=grid
# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=asmadmin
# ORACLEASM_SCANBOOT: 'true' means scan for ASM disks on boot.
ORACLEASM_SCANBOOT=true
# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER="dm"
# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE="sd"
[root@SRVTLPYRDORA03 ~]# service oracleasm stop
Dropping Oracle ASMLib disks:                              [  OK  ]
Shutting down the Oracle ASMLib driver:                    [  OK  ]
[root@SRVTLPYRDORA03 ~]# service oracleasm start
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]



DISK CREATION@SRVTLPYRDORA03<mailto:CREATION@SRVTLPYRDORA03>-------------

[root@SRVTLPYRDORA03 ~]# ls -l /dev/rout/raw*
lrwxrwxrwx 1 root root 8 Nov 15 17:47 /dev/rout/rawdisk1 -> ../dm-13
lrwxrwxrwx 1 root root 8 Nov 15 17:47 /dev/rout/rawdisk2 -> ../dm-12
lrwxrwxrwx 1 root root 8 Nov 15 17:47 /dev/rout/rawdisk3 -> ../dm-14
lrwxrwxrwx 1 root root 8 Nov 15 17:47 /dev/rout/rawdisk4 -> ../dm-11
lrwxrwxrwx 1 root root 8 Nov 15 17:47 /dev/rout/rawdisk5 -> ../dm-16
lrwxrwxrwx 1 root root 8 Nov 15 17:47 /dev/rout/rawdisk6 -> ../dm-15
lrwxrwxrwx 1 root root 8 Nov 15 17:47 /dev/rout/rawdisk7 -> ../dm-17
lrwxrwxrwx 1 root root 8 Nov 15 17:47 /dev/rout/rawdisk8 -> ../dm-18

[root@SRVTLPYRDORA03 ~]# oracleasm listdisks

[root@SRVTLPYRDORA03 ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "OCRDATA2"
Instantiating disk "OCRDATA1"
Instantiating disk "VOTEDATA1"
Instantiating disk "VOTEDATA2"

[root@SRVTLPYRDORA03 ~]# oracleasm listdisks
OCRDATA1
OCRDATA2
VOTEDATA1
VOTEDATA2

[root@SRVTLPYRDORA02 ~]# uname -a
Linux SRVTLPYRDORA02 2.6.39-***.24.1.el6uek.x86_64 #1 SMP Sat Jun 23 02:39:07 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
[root@SRVTLPYRDORA03 ~]# uname -a
Linux SRVTLPYRDORA03 2.6.39-***.24.1.el6uek.x86_64 #1 SMP Sat Jun 23 02:39:07 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

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


------------Node 1


[oracle@SRVTLPYRDORA02 ~]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
1.141.76.210    SRVTLPYRDORA02.in.telephony.ee.com SRVTLPYRDORA02
######Public IP###################
1.***.76.210    SRVTLPYRDORA02.in.telephony.ee.com SRVTLPYRDORA02
1.***.76.211    SRVTLPYRDORA01.in.telephony.ee.com SRVTLPYRDORA03
######Virtual IP###################
1.***.76.213    SRVTLPYRDORA02-vip.in.telephony.ee.com     SRVTLPYRDORA02-vip
1.***.76.214    SRVTLPYRDORA03-vip.in.telephony.ee.com     SRVTLPYRDORA03-vip
####### Private IP #########################
187.***.2.2     SRVTLPYRDORA02-priv.in.telephony.ee.com SRVTLPYRDORA02-priv
187.***.2.3     SRVTLPYRDORA03-priv.in.telephony.ee.com SRVTLPYRDORA03-priv

[oracle@SRVTLPYRDORA02 ~]$ nslookup eesbidr-scan.in.telephony.ee.com
Server:         1.***.76.134
Address:        1.***.76.134#53
Name:   eeyoudr-scan.in.telephony.ee.com
Address: 1.***.76.216
Name:   eeyoudr-scan.in.telephony.ee.com
Address: 1.***.76.217
Name:   eeyoudr-scan.in.telephony.ee.com
Address: 1.***.76.215



---------Node 2


[root@SRVTLPYRDORA03 ~]#  cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
1.141.76.211    SRVTLPYRDORA01.in.telephony.ee.com SRVTLPYRDORAO3
######Public IP###################
1.141.76.210    SRVTLPYRDORA02.in.telephony.ee.com SRVTLPYRDORA02
1.141.76.211    SRVTLPYRDORA01.in.telephony.ee.com SRVTLPYRDORA03
######Virtual IP###################
1.141.76.213    SRVTLPYRDORA02-vip.in.telephony.ee.com SRVTLPYRDORA02-vip
1.141.76.214    SRVTLPYRDORA03-vip.in.telephony.ee.com SRVTLPYRDORA03-vip
####### Private IP #########################
192.168.2.2     SRVTLPYRDORA02-priv.in.telephony.ee.com SRVTLPYRDORA02-priv
192.168.2.3     SRVTLPYRDORA03-priv.in.telephony.ee.com SRVTLPYRDORA03-priv


[root@SRVTLPYRDORA03 ~]# nslookup eeyoudr-scan.in.telephony.ee.com
Server:         1.141.76.134
Address:        1.141.76.134#53
Name:   eeyoudr-scan.in.telephony.ee.com
Address: 1.141.76.216
Name:   eeyoudr-scan.in.telephony.ee.com
Address: 1.141.76.217
Name:   eeyoudr-scan.in.telephony.ee.com
Address: 1.141.76.215

All three SCAN IP should not be pinged.

On Node 1 : Grid software installation for CRS
Login Grid
./runInstaller

No comments:

Post a Comment