Oracle-10g RAC Installing on Redhat as 3

七七

-------Oracle-10g RAC Installing Document By Zhijun Yu---------



1、Add hostname into /etc/hosts on each nodes

192.168.1.252           vdbp

192.168.1.253           vdbs

192.168.1.250           db1

192.168.1.251           db2

10.168.1.250            pdb1

10.168.1.251            pdb2



2、Add Oracle's user and groups on each nodes  

[root@db1 root]# groupadd oinstall

[root@db1 root]# groupadd dba

[root@db1 root]# groupadd oper

[root@db1 root]#useradd -g oinstall -G dba,oper oracle

[root@db1 root]#id oracle

uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba),502(oper)

[root@db1 root]#passwd oracle

[root@db1 root]# id nobody

uid=99(nobody) gid=99(nobody) groups=99(nobody)



3、Change linux kernel to 2.4.21-15 on each nodes

   (Get kernel-2.4.21-15.EL.i686.rpm)

   [root@db1 admin]#rpm -ivh --nodeps kernel-2.4.21-15.EL.i686.rpm

   Edit /boot/grub/grub.conf  change default=1 to default=0

   reboot all nodes's machines

4、Add oracleasm's packages on each nodes

[root@db1 admin]# rpm -Uvh oracleasm-support-1.0.2-1.i386.rpm

[root@db1 admin]# rpm -Uvh oracleasm-2.4.21-EL-smp-1.0.0-1.i686.rpm

[root@db1 admin]# rpm -Uvh oracleasmlib-1.0.0-1.i386.rpm



--Do following tasks on each nodes

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

  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

  Fix permissions of Oracle ASM disks on boot (y/n) [y]: y



5、Testing oracleasm on each nodes

  [root@db1 rc3.d]# lsmod |grep oracleasm

  oracleasm              14224   1

  [root@db1 rc3.d]# dmesg |grep oracleasm

  ASM: oracleasmfs mounted with options: <defaults>;



6、Config rlogin and rsh on each nodes:

   Check rsh-0.17-5 and rsh-server-0.17-5 rpm

   #rpm -qa |grep rsh

   If none,pls adding packages into system.



   Change /etc/pam.d/rlogin on each nodes

   (1)comment  #auth reqired pam_securetty.so  which is in the /etc/pam.d/rlogin file  

   (2)change /etc/xinetd.d/rlogin to "disable no"

   (3)change /etc/xinetd.d/rsh to "disable no"

   (4)echo rsh>;>;/etc/securetty

   (5)create /etc/hosts.equiv and add following lines into the file：

    db1

    db2

    pdb1

    pdb2

   

   (6)create .rhosts for root and oracle

     root user:

      db1    root

      db2    root

   

     oracle user:

      db1    oracle

      db2    oracle

   (7)testing rlogin and rsh



7、add following lines into /etc/sysctl.conf on each nodes,then reboot machines



kernel.shmall = 2097152

kernel.shmmax = 526499840 (526499840=內(nèi)存總數(shù)/2)

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000





--check configuration

#/sbin/sysctl -p  



8、Add the following lines to /etc/security/limits.conf file on each nodes



*               soft    nproc            2047

*               hard    nproc            16384

*               soft    nofile           1024

*               hard    nofile           65536





9、Add the following line to the /etc/pam.d/login file on each nodes:

session    required     /lib/security/pam_limits.so



10、For oracle user ,see if it is bash..add the following line to /etc/profile



if [ $USER = "oracle" ]; then

       if [ $SHELL = "/bin/ksh" ]; then

            ulimit -p 16384

            ulimit -n 65536

       else

            ulimit -u 16384 -n 65536

       fi

fi



11、Create directory for installing oracle on each nodes



[root@db1 root]# mkdir -p /u01/app/oracle

[root@db1 root]# chown -R oracleinstall /u01/app

[root@db1 root]# chmod -R 755 /u01/app



12、Add following lines to the /home/oracle/.bash_profile for oracle-users on each nodes:



ORACLE_HOME=/u01/app/oracle; export ORACLE_HOME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_SID=bill1; export ORACLE_SID

LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH

PATH=$PATHORACLE_HOME/binHOME/bin

export PATH



13、change /dev/sda patition on db1 (only one node)

fdisk /dev/sda

sda1: 200M

sda2:100M

sda3:all free spaces



14、add following lines to the /etc/sysconfig/rawdevices on each nodes

/dev/raw/raw1 /dev/sda1

/dev/raw/raw2 /dev/sda2

/dev/raw/raw3 /dev/sda3



-then do following changing on each nodes

[root@db1 sysconfig]# chown oracle:dba /dev/raw/raw1

[root@db1 sysconfig]# chown oracle:dba /dev/raw/raw2

[root@db1 sysconfig]# chown oracle:dba /dev/raw/raw3

[root@db1 sysconfig]# chmod 660 /dev/raw/raw1

[root@db1 sysconfig]# chmod 660 /dev/raw/raw2

[root@db1 sysconfig]# chmod 660 /dev/raw/raw3

[root@db1 sysconfig]# /sbin/service rawdevices restart



15、Installing CRS(Cluster Ready Services) on db1 ,this will be installed on db2 at same time



[root@db1 root]# gzip -d ship.crs.cpio.gz

[root@db1 root]# cpio -idmv < ship.crs.cpio

  (2)Create directory on each nodes

[oracle@db1]$mkdir /u01/app/oracle/crs

[oracle@db1]$mkdir /u01/app/oracle/css

[oracle@db1]$mkdir /u01/app/oracle/bin

  (3)runInstaller in Xterm

/home/oracle/oraInventory

Name:OraCr10g_home1

path:/u01/app/oracle/crs



Specify OCR Location :/dev/raw/raw1

enter voting disk file name: /dev/raw/raw2

/u01/app/oracle/root.sh as root running on node(s) db1 ,db2





--/etc/init.d/init* are start-shell

ps ax |grep oracle

4511 ?        S      0:00 /u01/app/oracle/crs/bin/ocssd.bin

4584 ?        S      0:00 /u01/app/oracle/crs/bin/evmd.bin

18967 ?        S      0:00 /u01/app/oracle/crs/bin/crsd.bin

5174 ?        S      0:00 /u01/app/oracle/opmn/bin/ons -d





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

16、Installing DB without creating database



[root@db1 root]# gzip -d ship.crs.cpio.gz

[root@db1 root]# cpio -idmv < ship.db.cpio



$runInstaller

(1)installing cluster database,select db1 and db2

(2)run root.sh ,and add "vdbp and vdps" to eth0

#ifconfig |more

check vdbp and vdps on both machines



17、run dbca by oracle user

(1)select db1 and db2

(2)databa name:billing

(3)ID prefix:bill

(4)all user's passwdxxxxx
(5)Select Automatic Storage Management(ASM)

(6)Create new DISKGROUP with /dev/raw/raw3  and groupname: VOL

  --on db2 do following tasks

  $cd /u01/app/oracle/dbs

  $ln -s /u01/app/oracle/admin/+ASM/pfile/init.ora init+ASM2.ora

  $orapwd file=orapw+ASM2 password=xxxxxx
  $export ORACLE_SID=+ASM2

  $ sqlplus / as sysdba

    SQL>; startup

       ASM instance started

       Total System Global Area 100663296 bytes

       Fixed Size 777616 bytes

       Variable Size 99885680 bytes

       Database Buffers 0 bytes

       Redo Buffers 0 bytes

       ASM diskgroups mounted

    SQL>; create spfile from pfile;

    SQL>; shutdown immediate;

    SQL>; startup;

   Next.....................

(7)Use Oracle-Managed Files :+VOL

(mem:80%

(9)charset:zhsgb16



17:Check database status

srvctl config database -d billing

srvctl status database -d billing

srvctl start database -d billing

srvctl stop database -d billing



------------------Finish