Oracle DBA, How To, Error, Cause and Action

Installation Oracle 10g RAC with RedHat on VirtualBox


/Volumes/external_disk/VirtualBoxes/10g RAC POC/Primary/10gRACPrimaryOCR.vdi

 VBoxManage createhd -filename 10gRACPrimaryOCR.vdi -size 1024  -format VDI -variant Fixed
VBoxManage createhd -filename 10gRACPrimaryVotingDisk.vdi -size 1024  -format VDI -variant Fixed
VBoxManage createhd -filename 10gRACPrimaryASMData.vdi -size 10240  -format VDI -variant Fixed
VBoxManage createhd -filename 10gRACPrimaryASMFRA.vdi -size 10240  -format VDI -variant Fixed

 VBoxManage storageattach 10gN1P --storagectl "SATA" --port 1 --device 0 --type hdd --medium 10gRACPrimaryOCR.vdi --mtype shareable
VBoxManage storageattach 10gN1P --storagectl "SATA" --port 2 --device 0 --type hdd --medium 10gRACPrimaryVotingDisk.vdi --mtype shareable
VBoxManage storageattach 10gN1P --storagectl "SATA" --port 3 --device 0 --type hdd --medium 10gRACPrimaryASMData.vdi --mtype shareable
VBoxManage storageattach 10gN1P --storagectl "SATA" --port 4 --device 0 --type hdd --medium 10gRACPrimaryASMFRA.vdi --mtype shareable

 VBoxManage storageattach 10gN2P --storagectl "SATA" --port 1 --device 0 --type hdd --medium 10gRACPrimaryOCR.vdi --mtype shareable
VBoxManage storageattach 10gN2P --storagectl "SATA" --port 2 --device 0 --type hdd --medium 10gRACPrimaryVotingDisk.vdi --mtype shareable
VBoxManage storageattach 10gN2P --storagectl "SATA" --port 3 --device 0 --type hdd --medium 10gRACPrimaryASMData.vdi --mtype shareable
VBoxManage storageattach 10gN2P --storagectl "SATA" --port 4 --device 0 --type hdd --medium 10gRACPrimaryASMFRA.vdi --mtype shareable




[root@10gn1db1 network-scripts]# more ifcfg-eth0
DEVICE="eth0"
BOOTPROTO="static"
BROADCAST="192.68.1.255"
DNS1="192.68.1.2"
HOSTNAME="10gn1db1.sinardy.com"
HWADDR="08:00:27:4B:E7:BB"
IPADDR="192.68.1.21"
NETMASK="255.255.255.0"
NM_CONTROLLED="yes"
ONBOOT="yes"
TYPE="Ethernet"

 [root@10gn1db1 network-scripts]# more route-eth0
192.68.1.0/24 via 192.68.1.1 dev eth0

 [root@10gn1db1 network-scripts]# more ifcfg-eth1
DEVICE="eth1"
BOOTPROTO="static"
IPADDR="10.10.10.21"
BROADCAST="10.10.10.255"
HWADDR="08:00:27:22:EC:AF"
NM_CONTROLLED="yes"
ONBOOT="yes"
TYPE="Ethernet"

 [root@10gn1db1 network-scripts]# more route-eth1
10.10.10.0/24 via 10.10.10.1 dev eth1

 [root@10gn1db1 network-scripts]# more ifcfg-eth2
DEVICE="eth2"
BOOTPROTO="dhcp"
HWADDR="08:00:27:F6:B9:64"
NM_CONTROLLED="yes"
ONBOOT="yes"
TYPE="Ethernet"

 [root@10gn1db1 sysconfig]# more network
NETWORKING=yes
HOSTNAME=10gn1db1.sinardy.com
#GATEWAY=192.68.1.1
NOZEROCONF=YES
NETWORKING_IPV6=NO
IPV6INIT=NO

 [root@10gn1db1 sysconfig]# ip route show
192.168.2.0/24 dev eth2  proto kernel  scope link  src 192.168.2.127 
10.10.10.0/24 via 10.10.10.1 dev eth1 
192.68.1.0/24 dev eth0  proto kernel  scope link  src 192.68.1.21 
10.0.0.0/8 dev eth1  proto kernel  scope link  src 10.10.10.21 
default via 192.168.2.1 dev eth2 
vi /etc/hosts

 127.0.0.1 localhost

 #Public
192.68.1.21 10gn1db1.sinardy.com     10gn1db1
192.68.1.23 10gn2db1.sinardy.com 10gn2db1

 #Virtual 
192.68.1.22     10gn1db1-vip.sinardy.com        10gn1db1-vip
192.68.1.24     10gn2db1-vip.sinardy.com        10gn2db1-vip

 #Private
10.10.10.21 10gn1db1-priv.sinardy.com 10gn1db1-priv
10.10.10.22 10gn2db1-priv.sinardy.com 10gn2db1-priv
vi /etc/sysctl.conf

 fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.core_uses_pid = 1
kernel.msgmax = 65536
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 128
kernel.sem = 250 32000 100 128
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sysrq = 0
net.core.netdev_max_backlog=2500
net.core.optmem_max=524287
net.core.rmem_default = 1048576
net.core.rmem_max = 16777216
net.core.wmem_default = 524288
net.core.wmem_max = 16777216
net.ipv4.conf.all.accept_redirects = 0
net.ipv4.conf.all.accept_source_route = 0
net.ipv4.conf.all.log_martians = 1
net.ipv4.conf.all.rp_filter = 1
net.ipv4.conf.all.secure_redirects = 0
net.ipv4.conf.all.send_redirects = 0
net.ipv4.conf.default.accept_redirects = 0
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.secure_redirects = 0
net.ipv4.conf.default.send_redirects = 0
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.ip_forward = 0
net.ipv4.ip_local_port_range = 1024 65000
net.ipv4.ipfrag_high_thresh=524288
net.ipv4.ipfrag_low_thresh=393216
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.tcp_mem=16384 16384 16384
net.ipv4.tcp_rmem=4096 524288 16777216
net.ipv4.tcp_sack=0
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_timestamps=0
net.ipv4.tcp_window_scaling=1
net.ipv4.tcp_wmem=4096 524288 16777216
sunrpc.tcp_slot_table_entries=128
sunrpc.udp_slot_table_entries=128
vi /etc/security/limits.conf 

 #oracle hard memlock 7000000
#oracle soft memlock 7000000
#oracle hard nproc 16384
#oracle soft nofile 65536
#oracle soft nproc 16384
#oracle hard nofile 65536
#oracle soft stack 10240

 *  soft    nproc   2047
*  hard    nproc   16384
*  soft    nofile  1024
*  hard    nofile  65536
vi /etc/modprobe.conf

 options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180
Create password less

 node1

 mkdir ~/.ssh
chmod 700 ~/.ssh
/usr/bin/ssh-keygen -t rsa # Accept the default settings.
cd ~/.ssh
cat id_rsa.pub >> authorized_keys
scp authorized_keys rac2:/home/oracle/.ssh/

 node2
su - oracle
cd ~/.ssh
cat id_rsa.pub >> authorized_keys
scp authorized_keys rac1:/home/oracle/.ssh/

 node1 and node2
su - oracle
ssh rac1 date
ssh rac2 date
ssh rac1.localdomain date
ssh rac2.localdomain date
exec /usr/bin/ssh-agent $SHELL
/usr/bin/ssh-add

 [root@10gn2db1 /]# mkdir -p /u01/app/oracle/product/10.2.0/db_1
[root@10gn2db1 /]# mkdir -p /u01/app/crs/product/10.2.0/crs
[root@10gn2db1 /]# mkdir -p /u01/app/oracle/product/10.2.0/db_1
[root@10gn2db1 /]# mkdir -p /u01/oradata
[root@10gn2db1 /]# mkdir -p /u01/shared_config
[root@10gn2db1 /]# chown -R oracle:oinstall /u01/app /u01/app/oracle /u01/oradata /u01/shared_config
[root@10gn2db1 /]# chmod -R 775 /u01/app /u01/app/oracle /u01/oradata /u01/shared_config
[root@10gn2db1 ~]# /sbin/scsi_id -g -u -d /dev/sdb
1ATA_VBOX_HARDDISK_VBd7b645d7-518b35d5
[root@10gn2db1 ~]# /sbin/scsi_id -g -u -d /dev/sdc
1ATA_VBOX_HARDDISK_VB83e1557b-2bc3afa6
[root@10gn2db1 ~]# /sbin/scsi_id -g -u -d /dev/sdd
1ATA_VBOX_HARDDISK_VBa945dab2-bbc917e6
[root@10gn2db1 ~]# /sbin/scsi_id -g -u -d /dev/sde
1ATA_VBOX_HARDDISK_VB495e602b-6653d675
[root@10gn1db1 ~]# more /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBd7b645d7-518b35d5", NAME="rac-ocr-disk1", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB83e1557b-2bc3afa6", NAME="rac-votedisk-disk1", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBa945dab2-bbc917e6", NAME="rac-asm-data-disk1", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB495e602b-6653d675", NAME="rac-asm-fra-disk1", OWNER="oracle", GROUP="dba", MODE="0660"















>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1. Check Hostname and Network Setting

 # vi /etc/sysconfig/network

 NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=rac10gn2db1
NOZEROCONF=yes

 # vi /etc/sysconfig/network-scripts/ifcfg-eth0

 # Intel Corporation 82540EM Gigabit Ethernet Controller
DEVICE=eth0
BOOTPROTO=static
BROADCAST=192.68.1.255
HWADDR=08:00:27:4B:E7:BB
IPADDR=192.68.1.23
NETMASK=255.255.255.0
NETWORK=192.68.1.0
ONBOOT=yes

 If required static route

 # more /etc/sysconfig/network-scripts/route-eth0 
192.68.1.0/24 via 192.68.1.1 dev eth0

 Make sure interfaces eth are corresponded to each other
#  ip route show
192.168.0.0/24 dev eth2  proto kernel  scope link  src 192.168.0.112 
10.10.10.0/24 dev eth1  proto kernel  scope link  src 10.10.10.21 
192.68.1.0/24 dev eth0  proto kernel  scope link  src 192.68.1.21 
169.254.0.0/16 dev eth2  scope link 
default via 192.168.0.1 dev eth2 
2. Create /etc/hosts entry

 # vi /etc/hosts

 127.0.0.1 localhost.localdomain localhost
#Public
192.68.1.21     rac10gn1db1   localhost
192.68.1.23     rac10gn2db1

 #Virtual 
192.68.1.22     rac10gn1db1-vip
192.68.1.24     rac10gn2db1-vip

 #Private
10.10.10.21     rac10gn1db1-priv
10.10.10.23     rac10gn2db1-priv

 3. Modify /etc/sysctl.conf

 vi /etc/sysctl.conf

 fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.core_uses_pid = 1
kernel.msgmax = 65536
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 128
kernel.sem = 250 32000 100 128
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sysrq = 0
net.core.netdev_max_backlog=2500
net.core.optmem_max=524287
net.core.rmem_default = 524288
net.core.rmem_max = 16777216
net.core.wmem_default = 524288
net.core.wmem_max = 16777216
net.ipv4.conf.all.accept_redirects = 0
net.ipv4.conf.all.accept_source_route = 0
net.ipv4.conf.all.log_martians = 1
net.ipv4.conf.all.rp_filter = 1
net.ipv4.conf.all.secure_redirects = 0
net.ipv4.conf.all.send_redirects = 0
net.ipv4.conf.default.accept_redirects = 0
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.secure_redirects = 0
net.ipv4.conf.default.send_redirects = 0
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.ip_forward = 0
net.ipv4.ip_local_port_range = 1024 65000
net.ipv4.ipfrag_high_thresh=524288
net.ipv4.ipfrag_low_thresh=393216
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.tcp_mem=16384 16384 16384
net.ipv4.tcp_rmem=4096 524288 16777216
net.ipv4.tcp_sack=0
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_timestamps=0
net.ipv4.tcp_window_scaling=1
net.ipv4.tcp_wmem=4096 524288 16777216
sunrpc.tcp_slot_table_entries=128
sunrpc.udp_slot_table_entries=128
4. Modify /etc/security/limits.conf 

 # vi /etc/security/limits.conf 

 #oracle hard memlock 7000000
#oracle soft memlock 7000000
#oracle hard nproc 16384
#oracle soft nofile 65536
#oracle soft nproc 16384
#oracle hard nofile 65536
#oracle soft stack 10240

 *  soft    nproc   2047
*  hard    nproc   16384
*  soft    nofile  1024
*  hard    nofile  65536

 5. Create Oracle User

 # groupadd -g 501 oinstall
# groupadd -g 502 dba
# useradd -m -u 501 -g oinstall -G dba oracle
# passwd oracle

 verify id oracle and configure .bash_profile

 # .bash_profile

 # Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

 # User specific environment and startup programs
umask 022

 #Default path

 export ORACLE_BASE=/u01/app
export DB_HOME=/u01/app/oracle/product/10.2.0/db_1
export ASM_HOME=/u01/app/oracle/product/10.2.0/asm
export CRS_HOME=/u01/crs/oracle/product/10.2.0/crs
export OPATCH_HOME=/u01/app/oracle/opatch/11.1.0/OPatch

 export DEFAULT_PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/usr/sbin:/usr/bin:/bin:$CRS_HOME/bin:.

 # Golden Gate
export GG_HOME=$ORACLE_BASE/GG_HOME_$ORACLE_SID

 export PS1="\n[$?]\e[1;37m[\e[0;32m\u\e[0;35m@\e[0;32m\h\e[1;37m]\e[1;37m[\e[0;31m\w\e[1;37m]($SHLVL:\!)\n\[\033[0m\]\$ "

 export ASM_DB=+ASM
export ASM_SID=+ASM1
export DB_DB=a10g
export DB_SID=a10g1

 alias dbhome='cd $ORACLE_HOME'
alias crshome='cd $CRS_HOME'
alias alertlog='cd $ORACLE_BASE'
alias tasmlog='tail -f /u01/app/admin/$ASM_DB/bdump/alert_$ASM_SID.log'

 alias asmenv='export ORACLE_SID=$ASM_SID; export ORACLE_HOME=$ASM_HOME; export LD_LIBRARY_PATH=$ORACLE_HOME/lib; export PATH=$DEFAULT_PATH:$ORACLE_HOME/bin'
alias dbenv='export ORACLE_SID=$DB_SID; export ORACLE_HOME=$DB_HOME; export LD_LIBRARY_PATH=$ORACLE_HOME/lib; export PATH=$DEFAULT_PATH:$ORACLE_HOME/bin'

6. Create Passwordless

 rm -r ~/.ssh; mkdir ~/.ssh; chmod 700 ~/.ssh
/usr/bin/ssh-keygen -t rsa # Accept the default settings.
/usr/bin/ssh-keygen -t dsa 
cd ~/.ssh; 
cat id_rsa.pub > authorized_keys  
cat id_dsa.pub >> authorized_keys
### change hostname: scp authorized_keys rac2:/home/oracle/.ssh/
### change hostname: ssh rac2
/usr/bin/ssh-keygen -t rsa # Accept the default settings.
/usr/bin/ssh-keygen -t dsa 
cd ~/.ssh
cat id_rsa.pub >> authorized_keys
cat id_dsa.pub >> authorized_keys
### change hostname: scp authorized_keys rac1:/home/oracle/.ssh/
ssh rac1 date
ssh rac2 date
node1 and node2 user equivalency (Important to execute following command because it will asked for the confirmation of Key Safe)
su - oracle
ssh rac1 date
ssh rac2 date
ssh rac1.localdomain date
ssh rac2.localdomain date
exec /usr/bin/ssh-agent $SHELL; /usr/bin/ssh-add

# vi /etc/ssh/sshd_config


7. Create Oracle and CRS Home

 # mkdir -p /u01/app/oracle/product/10.2.0/db_1;
mkdir -p /u01/crs/product/10.2.0/crs;
mkdir -p /u01/app/oracle/product/10.2.0/db_1;
mkdir -p /u01/oradata;
mkdir -p /u01/shared_config;
chown -R oracle:oinstall /u01/crs /u01/app /u01/app/oracle /u01/oradata /u01/shared_config;
chmod -R 775 /u01/crs /u01/app /u01/app/oracle /u01/oradata /u01/shared_config;

 8. Discover all disk

 # fdisk -l

 Create partition

 # fdisk /dev/sdb

 n
p
1
[Enter]
w

 Repeat for all disks

 9. Identify the scsi id

 RedHat 5 on VMware using following command

 # /sbin/scsi_id -g -u -s /block/sdb
SATA_VBOX_HARDDISK_VB76aa54d9-b0a7d47a_
10. ftp media and oracleasm, oracle-asmlib, oracle-support
11. Create Persistent disk and mapping raw devices (at both nodes) This applicable for RedHat 5 the scsi command is diff for red hat 6

 # vi  /etc/udev/rules.d/55-oracle-asmdevices.rules
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s /block/$parent", RESULT=="SATA_VBOX_HARDDISK_VB76aa54d9-b0a7d47a_", NAME="ocr-disk1", OWNER="root", GROUP="dba", MODE="0660"
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s /block/$parent", RESULT=="SATA_VBOX_HARDDISK_VBd2e4dfff-d873de54_", NAME="votedisk-disk1", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s /block/$parent", RESULT=="SATA_VBOX_HARDDISK_VB53769136-7c1a4648_", NAME="asm-data-disk1", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s /block/$parent", RESULT=="SATA_VBOX_HARDDISK_VB75a58d2e-bda27333_", NAME="asm-fra-disk1", OWNER="oracle", GROUP="dba", MODE="0660"

 # vi /etc/udev/rules.d/61-oracle-asmdevices.rules
ACTION=="add" KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s /block/$parent", RESULT=="SATA_VBOX_HARDDISK_VB76aa54d9-b0a7d47a_", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add" KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s /block/$parent", RESULT=="SATA_VBOX_HARDDISK_VBd2e4dfff-d873de54_", RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add" KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s /block/$parent", RESULT=="SATA_VBOX_HARDDISK_VB53769136-7c1a4648_", RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add" KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s /block/$parent", RESULT=="SATA_VBOX_HARDDISK_VB75a58d2e-bda27333_", RUN+="/bin/raw /dev/raw/raw4 %N"
# vi /etc/udev/rules.d/65-oracle-raw-permission.rules 
KERNEL=="raw1", OWNER="root", GROUP="oinstall", MODE="640"
KERNEL=="raw2", OWNER="oracle", GROUP="oinstall", MODE="660"
KERNEL=="raw3", OWNER="oracle", GROUP="oinstall", MODE="660"
KERNEL=="raw4", OWNER="oracle", GROUP="oinstall", MODE="660"

 # start_udev

 12. Create soft link at both nodes with oracle account

 ln -s /dev/raw/raw1 /u01/oradata/ocr-disk1
ln -s /dev/raw/raw2 /u01/oradata/vote-disk1
ln -s /dev/raw/raw3 /u01/oradata/asm-data-disk1
ln -s /dev/raw/raw4 /u01/oradata/asm-fra-disk1

 13. Extract CVU and install cvu disk util

 Download latest Cluster verification from Oracle web
extract into /home/oracle/cvu, the rpm will be there

 # rpm -ivh /home/oracle/cvu/cv/remenv/cvuqdisk-1.0.9-1.rpm 

 14. Perform shared disk test

 /bin/cluvfy comp ssa -n rac10gn1db1,rac10gn2db1 -verbose

 15. Install Oracle ASM rpm, in following order

 # rpm -ivh oracleasm-support-2.1.8-1.el5.x86_64.rpm # rpm -ivh oracleasm-2.6.18-128.el5-2.0.5-1.el5.x86_64.rpm
# rpm -ivh oracleasmlib-2.0.4-1.el5.x86_64.rpm

 16. stop the avahi-daemon

 # service avahi-daemon stop; chkconfig avahi-daemon off; chkconfig --list avahi-daemon

 17. start ntpd service

 # vi /etc/sysconfig/ntpd

 # Drop root to id 'ntp:ntp' by default.
OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"

 # Set to 'yes' to sync hw clock after successful ntpdate
SYNC_HWCLOCK=yes

 # Additional options for ntpdate
NTPDATE_OPTIONS=""
# chkconfig ntpd on; service ntpd start

 # service ntpd stop; ntpdate; service ntpd start
18. run cluvfy to check what required

 ./cluvfy stage -pre crsinst -n rac10gn1db2,rac10gn2db2 -verbose > /tmp/precrsinst.txt

 If required to add package use following method:

 mkdir /etc/yum.repos.d/old_repo; mv -f /etc/yum.repos.d/*.repo /etc/yum.repos.d/old_repo
rm /etc/yum.repos.d/local.repo
> /etc/yum.repos.d/local.repo
echo "[base]" >> /etc/yum.repos.d/local.repo
echo "name=Red Hat Enterprise Linux $releasever - $basearch - Base" >> /etc/yum.repos.d/local.repo
echo "baseurl=file:///media/Server" >> /etc/yum.repos.d/local.repo
echo "gpgcheck=0" >> /etc/yum.repos.d/local.repo
echo "enabled=1" >> /etc/yum.repos.d/local.repo
mount /dev/cdrom /media
yum clean all; yum repolist

  # this is for runInstaller to work

 yum install xorg-x11-deprecated-libs

 then perform the yum install as normal once done umount /media; eject

 19. If complain regarding the tmpfs /dev/shm that is because PGA and SGA may not have enough space

 mount -t tmpfs shmfs -o size=2g /dev/shm

 # vi /etc/fstab

 tmpfs   /dev/shm   tmpfs   size=2g   0 0
20. Once everything is clear try the ./runInstaller cluster ware
before run the root.sh

 Uncomment this 
vi /u01/crs/oracle/product/10.2.0/crs/vin/vipa

 #       if [ "$arch" = "i686" -o "$arch" = "ia64" -o "$arch" = "x86_64" ]
#       then
#            LD_ASSUME_KERNEL=2.4.19
#            export LD_ASSUME_KERNEL
#       fi
       #End workaround
vi /u01/crs/oracle/product/10.2.0/crs/vin/srvctl

 #LD_ASSUME_KERNEL=2.4.19
make sure modify vipca and srvctl and comment out the LD_ASSUME_KERNEL
21. When we have error post configuration, ONS failed because is already configured we can continue and skip it

 22. We run vipca as root and configure the VIP

 23. run 

 $ cluvfy stage -post crsinst -n rac10gn1db1,rac10gn2db1 -verbose
24. The final output of oifcfg

 $ oifcfg getif
eth0  192.68.1.0  global  public
eth1  10.10.10.0  global  cluster_interconnect
wrong oifcfg

 $ oifcfg getif
eth0  192.68.1.0  global  public
eth0  192.68.1.23  global  public
eth1  10.10.10.0  global  cluster_interconnect
eth1  10.10.10.23  global  cluster_interconnect
$ oifcfg deli -global eth0:192.68.1.23
$ oifcfg deli -global eth1:10.10.10.23

 25.
$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....db1.gsd application    ONLINE    ONLINE    rac10gn1db1 
ora....db1.ons application    ONLINE    ONLINE    rac10gn1db1 
ora....db1.vip application    ONLINE    ONLINE    rac10gn1db1 
ora....db1.gsd application    ONLINE    ONLINE    rac10gn2db1 
ora....db1.ons application    ONLINE    ONLINE    rac10gn2db1 
ora....db1.vip application    ONLINE    ONLINE    rac10gn2db1 

>>>>>>>>

 ASM Home Install 10.2.0
DB Home Install 10.2.0

 CRS Home Install 10.2.0.5
ASM Home Install 10.2.0.5
DB Home Install 10.2.0.5

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)