This article assume that you have already installed OEL6 on your node1, setup virtualbox guest addition, downloaded the required 11.2.0.3 database / grid software.
Node 1 - ol6-112-rac1.localdomain (4G RAM)
Node 2 - ol6-112-rac2.localdomain (4g RAM)Adapter settings for node 1
for now note that i am using three adapters. We will dicuss more in later section
Adapter 1 (eth0) – for public ip
Adapter 2 (eth1) – for taking putty sessions
Adapter 3 (eth2) – this is for private ip
Once these changes are done start your node1 machine and verify ifconfig and see if you are able to connect to internet
[root@ol6-112-rac1 /]# ifconfig
eth0 Link encap:Ethernet HWaddr 08:00:27:61:2B:FA
inet addr:192.168.43.117 Bcast:192.168.43.255 Mask:255.255.255.0
inet6 addr: fe80::a00:27ff:fe61:2bfa/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:242031 errors:0 dropped:0 overruns:0 frame:0
TX packets:60825 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:343803092 (327.8 MiB) TX bytes:3674339 (3.5 MiB)
eth1 Link encap:Ethernet HWaddr 08:00:27:72:1C:E2
inet addr:192.168.189.121 Bcast:192.168.189.255 Mask:255.255.255.0
inet6 addr: fe80::a00:27ff:fe72:1ce2/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:21767 errors:0 dropped:0 overruns:0 frame:0
TX packets:27734 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:11749852 (11.2 MiB) TX bytes:32236985 (30.7 MiB)
eth2 Link encap:Ethernet HWaddr 08:00:27:F6:DA:36
inet6 addr: fe80::a00:27ff:fef6:da36/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:22 errors:0 dropped:0 overruns:0 frame:0
TX packets:118 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:7524 (7.3 KiB) TX bytes:38268 (37.3 KiB)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:18715 errors:0 dropped:0 overruns:0 frame:0
TX packets:18715 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:28131132 (26.8 MiB) TX bytes:28131132 (26.8 MiB)
[root@ol6-112-rac1 /]# ping google.com
PING google.com (172.217.166.206) 56(84) bytes of data.
64 bytes from del03s13-in-f14.1e100.net (172.217.166.206): icmp_seq=1 ttl=54 time=43.9 ms
64 bytes from del03s13-in-f14.1e100.net (172.217.166.206): icmp_seq=2 ttl=54 time=33.3 ms
64 bytes from del03s13-in-f14.1e100.net (172.217.166.206): icmp_seq=3 ttl=54 time=32.2 ms
^C
Automatic Setup for 11gr2 grid installation
[root@ol6-112-rac1 /]# yum install oracle-rdbms-server-11gR2-preinstall
Loaded plugins: refresh-packagekit, security, ulninfo
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-15.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================================================
Installing:
oracle-rdbms-server-11gR2-preinstall x86_64 1.0-15.el6 public_ol6_latest 21 k
Transaction Summary
=============================================================================================================================================================================================
Install 1 Package(s)
Total download size: 21 k
Installed size: 53 k
Is this ok [y/N]: y
Downloading Packages:
oracle-rdbms-server-11gR2-preinstall-1.0-15.el6.x86_64.rpm | 21 kB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : oracle-rdbms-server-11gR2-preinstall-1.0-15.el6.x86_64 1/1
Verifying : oracle-rdbms-server-11gR2-preinstall-1.0-15.el6.x86_64 1/1
Installed:
oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-15.el6
Complete!
Perform yum update (advisable)
[root@ol6-112-rac1 /]# yum update
Loaded plugins: refresh-packagekit, security, ulninfo
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package java-1.7.0-openjdk.x86_64 1:1.7.0.181-2.6.14.10.0.1.el6 will be updated
---> Package java-1.7.0-openjdk.x86_64 1:1.7.0.261-2.6.22.1.0.1.el6_10 will be an update
---> Package kernel.x86_64 0:2.6.32-754.29.2.el6 will be installed
---> Package kernel-devel.x86_64 0:2.6.32-754.29.2.el6 will be installed
---> Package kernel-headers.x86_64 0:2.6.32-754.29.1.el6 will be updated
---> Package kernel-headers.x86_64 0:2.6.32-754.29.2.el6 will be an update
---> Package kernel-uek.x86_64 0:4.1.12-124.39.2.el6uek will be installed
---> Package kernel-uek-devel.x86_64 0:4.1.12-124.39.2.el6uek will be installed
---> Package kernel-uek-firmware.noarch 0:4.1.12-124.39.2.el6uek will be installed
---> Package perf.x86_64 0:2.6.32-754.29.1.el6 will be updated
---> Package perf.x86_64 0:2.6.32-754.29.2.el6 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================================================
Installing:
kernel x86_64 2.6.32-754.29.2.el6 public_ol6_latest 32 M
kernel-devel x86_64 2.6.32-754.29.2.el6 public_ol6_latest 11 M
kernel-uek x86_64 4.1.12-124.39.2.el6uek public_ol6_UEKR4 42 M
kernel-uek-devel x86_64 4.1.12-124.39.2.el6uek public_ol6_UEKR4 11 M
kernel-uek-firmware noarch 4.1.12-124.39.2.el6uek public_ol6_UEKR4 2.6 M
Updating:
java-1.7.0-openjdk x86_64 1:1.7.0.261-2.6.22.1.0.1.el6_10 public_ol6_latest 27 M
kernel-headers x86_64 2.6.32-754.29.2.el6 public_ol6_latest 4.6 M
perf x86_64 2.6.32-754.29.2.el6 public_ol6_latest 4.8 M
Transaction Summary
=============================================================================================================================================================================================
Install 5 Package(s)
Upgrade 3 Package(s)
Total download size: 135 M
Is this ok [y/N]: y
Downloading Packages:
(1/8): java-1.7.0-openjdk-1.7.0.261-2.6.22.1.0.1.el6_10.x86_64.rpm | 27 MB 00:29
(2/8): kernel-2.6.32-754.29.2.el6.x86_64.rpm | 32 MB 00:19
(3/8): kernel-devel-2.6.32-754.29.2.el6.x86_64.rpm | 11 MB 00:06
(4/8): kernel-headers-2.6.32-754.29.2.el6.x86_64.rpm | 4.6 MB 00:02
(5/8): kernel-uek-4.1.12-124.39.2.el6uek.x86_64.rpm | 42 MB 00:20
(6/8): kernel-uek-devel-4.1.12-124.39.2.el6uek.x86_64.rpm | 11 MB 00:06
(7/8): kernel-uek-firmware-4.1.12-124.39.2.el6uek.noarch.rpm | 2.6 MB 00:01
(8/8): perf-2.6.32-754.29.2.el6.x86_64.rpm | 4.8 MB 00:01
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 1.4 MB/s | 135 MB 01:36
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Error in PRETRANS scriptlet in rpm package 1:java-1.7.0-openjdk-1.7.0.261-2.6.22.1.0.1.el6_10.x86_64
error: lua script failed: /usr/libexec/copy_jdk_configs.lua:272: attempt to index global 'file' (a nil value)
Installing : kernel-uek-firmware-4.1.12-124.39.2.el6uek.noarch 1/11
Installing : kernel-2.6.32-754.29.2.el6.x86_64 2/11
Installing : kernel-uek-4.1.12-124.39.2.el6uek.x86_64 3/11
Updating : perf-2.6.32-754.29.2.el6.x86_64 4/11
Installing : kernel-uek-devel-4.1.12-124.39.2.el6uek.x86_64 5/11
Updating : kernel-headers-2.6.32-754.29.2.el6.x86_64 6/11
Installing : kernel-devel-2.6.32-754.29.2.el6.x86_64 7/11
Cleanup : perf-2.6.32-754.29.1.el6.x86_64 8/11
Cleanup : kernel-headers-2.6.32-754.29.1.el6.x86_64 9/11
VirtualBox Guest Additions: Building the modules for kernel
2.6.32-754.29.2.el6.x86_64.
VirtualBox Guest Additions: Building the modules for kernel
4.1.12-124.39.2.el6uek.x86_64.
Verifying : kernel-2.6.32-754.29.2.el6.x86_64 1/11
Verifying : kernel-uek-firmware-4.1.12-124.39.2.el6uek.noarch 2/11
Verifying : kernel-devel-2.6.32-754.29.2.el6.x86_64 3/11
Verifying : kernel-uek-4.1.12-124.39.2.el6uek.x86_64 4/11
Verifying : kernel-headers-2.6.32-754.29.2.el6.x86_64 5/11
Verifying : kernel-uek-devel-4.1.12-124.39.2.el6uek.x86_64 6/11
Verifying : perf-2.6.32-754.29.2.el6.x86_64 7/11
Verifying : 1:java-1.7.0-openjdk-1.7.0.261-2.6.22.1.0.1.el6_10.x86_64 8/11
1:java-1.7.0-openjdk-1.7.0.181-2.6.14.10.0.1.el6.x86_64 was supposed to be removed but is not!
Verifying : 1:java-1.7.0-openjdk-1.7.0.181-2.6.14.10.0.1.el6.x86_64 9/11
Verifying : perf-2.6.32-754.29.1.el6.x86_64 10/11
Verifying : kernel-headers-2.6.32-754.29.1.el6.x86_64 11/11
Installed:
kernel.x86_64 0:2.6.32-754.29.2.el6 kernel-devel.x86_64 0:2.6.32-754.29.2.el6 kernel-uek.x86_64 0:4.1.12-124.39.2.el6uek kernel-uek-devel.x86_64 0:4.1.12-124.39.2.el6uek
kernel-uek-firmware.noarch 0:4.1.12-124.39.2.el6uek
Updated:
kernel-headers.x86_64 0:2.6.32-754.29.2.el6 perf.x86_64 0:2.6.32-754.29.2.el6
Failed:
java-1.7.0-openjdk.x86_64 1:1.7.0.181-2.6.14.10.0.1.el6 java-1.7.0-openjdk.x86_64 1:1.7.0.261-2.6.22.1.0.1.el6_10
Complete!
Additional Setup – for oracle user
[root@ol6-112-rac1 /]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: it is based on a dictionary word
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.
[root@ol6-112-rac1 /]#
Software’s required
Unzip 1,2 and 3 file after that you will get database and grid directories
[root@ol6-112-rac1 11.2.0.3]# ls -l
total 15672192
drwxrwxrwx. 1 root root 0 Sep 22 2011 database
drwxrwxrwx. 1 root root 4096 Sep 22 2011 grid
-r-xr-xr-x. 1 root root 1358454646 Oct 13 2011 p10404530_112030_Linux-x86-64_1of7.zip
-r-xr-xr-x. 1 root root 1142195302 Oct 13 2011 p10404530_112030_Linux-x86-64_2of7.zip
-r-xr-xr-x. 1 root root 979195792 Oct 13 2011 p10404530_112030_Linux-x86-64_3of7.zip
-r-xr-xr-x. 1 root root 659229728 Oct 13 2011 p10404530_112030_Linux-x86-64_4of7.zip
-r-xr-xr-x. 1 root root 616473105 Oct 13 2011 p10404530_112030_Linux-x86-64_5of7.zip
-r-xr-xr-x. 1 root root 479890040 Oct 13 2011 p10404530_112030_Linux-x86-64_6of7.zip
-r-xr-xr-x. 1 root root 113915106 Oct 13 2011 p10404530_112030_Linux-x86-64_7of7.zip
-r-xr-xr-x. 1 root root 29758 Oct 14 2011 PatchSetNotes.htm
-rwxrwxrwx. 1 root root 3479941120 May 10 02:30 V28748-01.iso
-rwxrwxrwx. 1 root root 3479853941 May 10 02:29 V28748-01.zip
-rwxrwxrwx. 1 root root 1869606912 May 10 01:39 V28749-01.iso
-rwxrwxrwx. 1 root root 1869516366 May 10 01:01 V28749-01.zip
Install the following package from the Oracle grid media after you’ve defined groups.
[root@ol6-112-rac1 rpm]# pwd
/shared_dir/11.2.0.3/grid/rpm
[root@ol6-112-rac1 rpm]# ls
cvuqdisk-1.0.9-1.rpm
[root@ol6-112-rac1 rpm]# rpm -Uvh cvuqdisk*
Preparing... ########################################### [100%]
1:cvuqdisk ########################################### [100%]
Install dnsmasq if not present already. it will be used to configure scan
[root@ol6-112-rac1 rpm]# rpm -qa|grep dns
mod_dnssd-0.6-2.el6.x86_64
dnsmasq-2.48-18.el6_9.x86_64
[root@ol6-112-rac1 rpm]# service dnsmasq status
dnsmasq is stopped
[root@ol6-112-rac1 rpm]# service dnsmasq restart
Starting dnsmasq: [ OK ]
[root@ol6-112-rac1 rpm]# service dnsmasq status
dnsmasq (pid 18607) is running...
make these changes
[root@ol6-112-rac1 rpm]# cat /etc/security/limits.d/90-nproc.conf
# Default limit for number of user's processes to prevent
# accidental fork bombs.
# See rhbz #432903 for reasoning.
* - nproc 16384
root soft nproc unlimited
[root@ol6-112-rac1 rpm]#
set SELINUX to permissive
[root@ol6-112-rac1 rpm]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
#SELINUX=enforcing
SELINUX=permissive
# SELINUXTYPE= can take one of these two values:
# targeted - Targeted processes are protected,
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
If you have the Linux firewall enabled, you will need to disable
[root@ol6-112-rac1 rpm]# service iptables stop
[root@ol6-112-rac1 rpm]# chkconfig iptables off
[root@ol6-112-rac1 rpm]#
Either configure NTP, or make sure it is not configured so the Oracle Cluster Time Synchronization Service (ctssd) can synchronize the times of the RAC nodes. If you want to deconfigure NTP do the following
[root@ol6-112-rac1 rpm]# service ntpd stop
Shutting down ntpd: [ OK ]
[root@ol6-112-rac1 rpm]# chkconfig ntpd off
[root@ol6-112-rac1 rpm]# mv /etc/ntp.conf /etc/ntp.conf.orig
[root@ol6-112-rac1 rpm]# rm /var/run/ntpd.pid
rm: cannot remove `/var/run/ntpd.pid': No such file or directory
make below directories
[root@ol6-112-rac1 rpm]# mkdir -p /u01/app/11.2.0.3/grid
[root@ol6-112-rac1 rpm]# mkdir -p /u01/app/oracle/product/11.2.0.3/db_1
[root@ol6-112-rac1 rpm]# chown -R oracle:oinstall /u01
[root@ol6-112-rac1 rpm]# chmod -R 775 /u01/
Edit bash profile to have these settings
[oracle@ol6-112-rac1 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
# Oracle Settings
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=ol6-112-rac1.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=TROY; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
GRID_HOME=/u01/app/11.2.0.3/grid; export GRID_HOME
DB_HOME=$ORACLE_BASE/product/11.2.0.3/db_1; export DB_HOME
ORACLE_HOME=$DB_HOME; export ORACLE_HOME
ORACLE_SID=TROY1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
BASE_PATH=/usr/sbin:$PATH; export BASE_PATH
PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
alias grid_env='. /home/oracle/grid_env'
alias db_env='. /home/oracle/db_env'
create these additional env files
[oracle@ol6-112-rac1 ~]$ cat /home/oracle/grid_env
ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_HOME=$GRID_HOME; export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
[oracle@ol6-112-rac1 ~]$ cat /home/oracle/db_env
ORACLE_SID=TROY1; export ORACLE_SID
ORACLE_HOME=$DB_HOME; export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
You can now switch between ASM and DB env
[oracle@ol6-112-rac1 ~]$ source .bash_profile
[oracle@ol6-112-rac1 ~]$ env|grep ORA
ORACLE_UNQNAME=TROY
ORACLE_SID=TROY1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOSTNAME=ol6-112-rac1.localdomain
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/db_1
[oracle@ol6-112-rac1 ~]$ grid_env
[oracle@ol6-112-rac1 ~]$ env|grep ORA
ORACLE_UNQNAME=TROY
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOSTNAME=ol6-112-rac1.localdomain
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/11.2.0.3/grid
[oracle@ol6-112-rac1 ~]$ db_env
[oracle@ol6-112-rac1 ~]$ env|grep ORA
ORACLE_UNQNAME=TROY
ORACLE_SID=TROY1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOSTNAME=ol6-112-rac1.localdomain
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/db_1
[oracle@ol6-112-rac1 ~]$
shutdown the machine and Create Shared Disks
On the host server, create 4 sharable virtual disks and associate them as virtual media using the following commands. You can pick a different location, but make sure they are outside the existing VM directory.
Our host operating system is windows so we will use these commands.
C:\Users\SHALABH>cd D:\shared_asm_disk
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm1.vdi --size 5120 --format VDI --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 8ca20b54-d2be-4031-aafb-52867e43f0f2
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm2.vdi --size 5120 --format VDI --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 8fcd94fe-9995-4a14-b08a-4a3f87fea54a
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm3.vdi --size 5120 --format VDI --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 399e289c-6191-4fe0-8e10-766fd2bbd123
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm4.vdi --size 5120 --format VDI --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 62be42c3-a7c9-4428-a4a0-3cb5d6d1287e
Attach the disk to vm ol6-112-rac1
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach ol6-112-rac1 --storagectl "SATA" --port 1 --device 0 --type hdd --medium asm1.vdi --mtype shareable
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach ol6-112-rac1 --storagectl "SATA" --port 2 --device 0 --type hdd --medium asm2.vdi --mtype shareable
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach ol6-112-rac1 --storagectl "SATA" --port 3 --device 0 --type hdd --medium asm3.vdi --mtype shareable
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach ol6-112-rac1 --storagectl "SATA" --port 4 --device 0 --type hdd --medium asm4.vdi --mtype shareable
Make them sharable
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" modifyhd asm1.vdi --type shareable
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" modifyhd asm2.vdi --type shareable
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" modifyhd asm3.vdi --type shareable
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" modifyhd asm4.vdi --type shareable
Start the virtual machine. log in as the root user so you can configure the shared disks.
The current disks can be seen by issuing the following commands.
[root@ol6-112-rac1 ~]# cd /dev
[root@ol6-112-rac1 dev]# ls sd*
sda sda1 sda2 sdb sdc sdd sde
[root@ol6-112-rac1 dev]#
Use the “fdisk” command to partition the disks sdb to sde
[root@ol6-112-rac1 dev]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0x28d906ee.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-652, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-652, default 652):
Using default value 652
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@ol6-112-rac1 dev]# fdisk /dev/sdc
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0xd8714f73.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-652, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-652, default 652):
Using default value 652
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@ol6-112-rac1 dev]# fdisk /dev/sdd
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0x439a5281.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-652, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-652, default 652):
Using default value 652
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@ol6-112-rac1 dev]# fdisk /dev/sde
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0xafdf476a.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-652, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-652, default 652):
Using default value 652
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
Once all the disks are partitioned, the results can be seen by repeating the previous “ls” command.
[root@ol6-112-rac1 dev]# cd /dev
[root@ol6-112-rac1 dev]# ls sd*
sda sda1 sda2 sdb sdb1 sdc sdc1 sdd sdd1 sde sde1
Configure your UDEV rules
Add the following to the “/etc/scsi_id.config” file to configure SCSI devices as trusted. Create the file if it doesn’t already exist.
[root@ol6-112-rac1 dev]# vi /etc/scsi_id.config
[root@ol6-112-rac1 dev]# cat /etc/scsi_id.config
options=-g
[root@ol6-112-rac1 dev]#
Make a note of SCSI id
[root@ol6-112-rac1 dev]# /sbin/scsi_id -g -u -d /dev/sdb
1ATA_VBOX_HARDDISK_VB8ca20b54-f2f0437e
[root@ol6-112-rac1 dev]# /sbin/scsi_id -g -u -d /dev/sdc
1ATA_VBOX_HARDDISK_VB8fcd94fe-4aa5fe87
[root@ol6-112-rac1 dev]# /sbin/scsi_id -g -u -d /dev/sdd
1ATA_VBOX_HARDDISK_VB399e289c-23d1bbd2
[root@ol6-112-rac1 dev]# /sbin/scsi_id -g -u -d /dev/sde
1ATA_VBOX_HARDDISK_VB62be42c3-7e28d1d6
Using these values, edit the “/etc/udev/rules.d/99-oracle-asmdevices.rules” file adding the following 4 entries. All parameters for a single entry must be on the same line.
[root@ol6-112-rac1 dev]# cat /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_VB8ca20b54-f2f0437e", NAME="asm-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_VB8fcd94fe-4aa5fe87", NAME="asm-disk2", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB399e289c-23d1bbd2", NAME="asm-disk3", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB62be42c3-7e28d1d6", NAME="asm-disk4", OWNER="oracle", GROUP="dba", MODE="0660"
[root@ol6-112-rac1 dev]#
Load updated block device partition tables.
[root@ol6-112-rac1 dev]# /sbin/partprobe /dev/sdb1
[root@ol6-112-rac1 dev]# /sbin/partprobe /dev/sdc1
[root@ol6-112-rac1 dev]# /sbin/partprobe /dev/sdd1
[root@ol6-112-rac1 dev]# /sbin/partprobe /dev/sde1
[root@ol6-112-rac1 dev]#
Test the rules are working as expected.
/sbin/udevadm test /block/sdb/sdb1Reload the UDEV rules and start UDEV.
[root@ol6-112-rac1 dev]# /sbin/udevadm control --reload-rules
[root@ol6-112-rac1 dev]# /sbin/start_udev
Starting udev: [ OK ]
[root@ol6-112-rac1 dev]#
The disks should now be visible and have the correct ownership using the following command.
[root@ol6-112-rac1 dev]# ls -al /dev/asm*
brw-rw----. 1 oracle dba 8, 17 May 14 11:17 /dev/asm-disk1
brw-rw----. 1 oracle dba 8, 33 May 14 11:17 /dev/asm-disk2
brw-rw----. 1 oracle dba 8, 49 May 14 11:17 /dev/asm-disk3
brw-rw----. 1 oracle dba 8, 65 May 14 11:17 /dev/asm-disk4
Clone the Virtual Machine
Shutdown the ol6-112-rac1 machine and manually clone the VM so that shared disks are not cloned.
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" clonehd "D:\VM\ol6-112-rac1\ol6-112-rac1.vdi" "D:\VM\ol6-112-rac2\ol6-112-rac2.vdi"
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Clone medium created in format 'VDI'. UUID: d9d01c4f-be2f-41e9-a37f-e6056bf5bcf0
C:\Users\SHALABH>
Create the “ol6-112-rac2” virtual machine in VirtualBox in the same way as you did for “ol6-112-rac1”, with the exception of using an existing “ol6-112-rac2.vdi” virtual hard drive.
Select the vdi file you just cloned above
Remember to add the network adaptor same as you did on the “ol6-112-rac1” VM.
When the VM is created, attach the shared disks to this VM.
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach ol6-112-rac2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium asm1.vdi --mtype shareable
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach ol6-112-rac2 --storagectl "SATA" --port 2 --device 0 --type hdd --medium asm2.vdi --mtype shareable
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach ol6-112-rac2 --storagectl "SATA" --port 3 --device 0 --type hdd --medium asm3.vdi --mtype shareable
C:\Users\SHALABH>"c:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach ol6-112-rac2 --storagectl "SATA" --port 4 --device 0 --type hdd --medium asm4.vdi --mtype shareable
C:\Users\SHALABH>
Start the “ol6-112-rac2” virtual machine
Ignore these network errors
Log in to the “ol6-112rac2” virtual machine as the “root” user so we can reconfigure the network settings to match the following.
if you do ifconfig you will see eth3,eth4,eth5 instead of eth0,eth1,eth2 and hostname is same as node 1. To change hostname and eth3,eth4,eth5 as mentioned in this document
https://dbatracker.wordpress.com/2020/05/15/clone-oel-virtual-machine-in-oracle-virtual-box/
Once done you should be able to take putty session and hostname is also changed.
Setting up the /etc/hosts file and choosing ip addressed based on your network configuration.
I am connected through mobile hotspot and this is my ipconfig output
So I will choose below configuration considering this.
[root@ol6-112-rac2 ~]# cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
# Public
192.168.43.101 ol6-112-rac1.localdomain ol6-112-rac1
192.168.43.102 ol6-112-rac2.localdomain ol6-112-rac2
# Private
192.168.190.201 ol6-112-rac1-priv.localdomain ol6-112-rac1-priv
192.168.190.202 ol6-112-rac2-priv.localdomain ol6-112-rac2-priv
# Virtual
192.168.43.103 ol6-112-rac1-vip.localdomain ol6-112-rac1-vip
192.168.43.104 ol6-112-rac2-vip.localdomain ol6-112-rac2-vip
# SCAN
192.168.43.105 ol6-112-scan.localdomain ol6-112-scan
192.168.43.106 ol6-112-scan.localdomain ol6-112-scan
192.168.43.107 ol6-112-scan.localdomain ol6-112-scan
Now understand that we have 3 adapters.
Adapter1 (eth0) – for bridged connection (public ip 192.168.43.101 / 102 )
Adapter 2 (eth1)– Host only (this has nothing to do with RAC setup just for taking putty sessions 192.168.189.121 / 122)
Adapter 3 (eth2)– internal - this is for private ip (192.168.190.201 / 202)
So we will now make changes in eth0 and eth2 settings so that they contain fixed ip addresses as per our /etc/hosts file.
Refer this article to know more about setting RAC adapters
These setting are for ol6-112-rac2. Similarly, we will do for ol6-112-rac1
Once changes are done our ifconfig output should be this on ol6-112-rac2. Notice the ip address of eth0 and eth2.
[root@ol6-112-rac2 ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 08:00:27:7B:10:E7
inet addr:192.168.43.102 Bcast:192.168.43.255 Mask:255.255.255.0
inet6 addr: fe80::a00:27ff:fe7b:10e7/64 Scope:Link
inet6 addr: 2401:4900:170b:d84f:a00:27ff:fe7b:10e7/64 Scope:Global
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:4315 errors:0 dropped:0 overruns:0 frame:0
TX packets:3172 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:5553581 (5.2 MiB) TX bytes:225096 (219.8 KiB)
eth1 Link encap:Ethernet HWaddr 08:00:27:47:A3:46
inet addr:192.168.189.122 Bcast:192.168.189.255 Mask:255.255.255.0
inet6 addr: fe80::a00:27ff:fe47:a346/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:348 errors:0 dropped:0 overruns:0 frame:0
TX packets:260 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:34306 (33.5 KiB) TX bytes:57792 (56.4 KiB)
eth2 Link encap:Ethernet HWaddr 08:00:27:A2:EC:9B
inet addr:192.168.190.202 Bcast:192.168.190.255 Mask:255.255.255.0
inet6 addr: fe80::a00:27ff:fea2:ec9b/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:118 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 b) TX bytes:37140 (36.2 KiB)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:12 errors:0 dropped:0 overruns:0 frame:0
TX packets:12 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:720 (720.0 b) TX bytes:720 (720.0 b)
You may need to up down eth0 and eth2 if ip address are not changed automatically
Setting eth0 and eth2 on ol6-112-rac1
[root@ol6-112-rac1 ~]# ifdown eth0
Device state: 3 (disconnected)
[root@ol6-112-rac1 ~]# ifup eth0
Active connection state: activated
Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/7
[root@ol6-112-rac1 ~]# ifdown eth2
Device state: 3 (disconnected)
[root@ol6-112-rac1 ~]# ifup eth2
Active connection state: activated
Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/8
[root@ol6-112-rac1 ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 08:00:27:61:2B:FA
inet addr:192.168.43.101 Bcast:192.168.43.255 Mask:255.255.255.0
inet6 addr: 2401:4900:170b:d84f:a00:27ff:fe61:2bfa/64 Scope:Global
inet6 addr: fe80::a00:27ff:fe61:2bfa/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:603 errors:0 dropped:0 overruns:0 frame:0
TX packets:576 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:54268 (52.9 KiB) TX bytes:51422 (50.2 KiB)
eth1 Link encap:Ethernet HWaddr 08:00:27:72:1C:E2
inet addr:192.168.189.121 Bcast:192.168.189.255 Mask:255.255.255.0
inet6 addr: fe80::a00:27ff:fe72:1ce2/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:237 errors:0 dropped:0 overruns:0 frame:0
TX packets:218 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:23460 (22.9 KiB) TX bytes:32152 (31.3 KiB)
eth2 Link encap:Ethernet HWaddr 08:00:27:F6:DA:36
inet addr:192.168.190.201 Bcast:192.168.190.255 Mask:255.255.255.0
inet6 addr: fe80::a00:27ff:fef6:da36/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:39 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 b) TX bytes:9618 (9.3 KiB)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:30 errors:0 dropped:0 overruns:0 frame:0
TX packets:30 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:2272 (2.2 KiB) TX bytes:2272 (2.2 KiB)
host file on node 1
[root@ol6-112-rac1 ~]# cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
# Public
192.168.43.101 ol6-112-rac1.localdomain ol6-112-rac1
192.168.43.102 ol6-112-rac2.localdomain ol6-112-rac2
# Private
192.168.190.201 ol6-112-rac1-priv.localdomain ol6-112-rac1-priv
192.168.190.202 ol6-112-rac2-priv.localdomain ol6-112-rac2-priv
# Virtual
192.168.43.103 ol6-112-rac1-vip.localdomain ol6-112-rac1-vip
192.168.43.104 ol6-112-rac2-vip.localdomain ol6-112-rac2-vip
# SCAN
192.168.43.105 ol6-112-scan.localdomain ol6-112-scan
192.168.43.106 ol6-112-scan.localdomain ol6-112-scan
192.168.43.107 ol6-112-scan.localdomain ol6-112-scan
Edit .bash_profile of ol6-112-rac2 and make these changes.
[oracle@ol6-112-rac2 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
# Oracle Settings
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=ol6-112-rac2.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=TROY; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
GRID_HOME=/u01/app/11.2.0.3/grid; export GRID_HOME
DB_HOME=$ORACLE_BASE/product/11.2.0.3/db_1; export DB_HOME
ORACLE_HOME=$DB_HOME; export ORACLE_HOME
ORACLE_SID=TROY2; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
BASE_PATH=/usr/sbin:$PATH; export BASE_PATH
PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
alias grid_env='. /home/oracle/grid_env'
alias db_env='. /home/oracle/db_env'
test public and private ip are able to ping from both nodes
[oracle@ol6-112-rac1 ~]$ ping -c 3 ol6-112-rac1
PING ol6-112-rac1.localdomain (192.168.43.101) 56(84) bytes of data.
64 bytes from ol6-112-rac1.localdomain (192.168.43.101): icmp_seq=1 ttl=64 time=0.028 ms
64 bytes from ol6-112-rac1.localdomain (192.168.43.101): icmp_seq=2 ttl=64 time=0.035 ms
64 bytes from ol6-112-rac1.localdomain (192.168.43.101): icmp_seq=3 ttl=64 time=0.050 ms
--- ol6-112-rac1.localdomain ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2001ms
rtt min/avg/max/mdev = 0.028/0.037/0.050/0.011 ms
[oracle@ol6-112-rac1 ~]$ ping -c 3 ol6-112-rac1-priv
PING ol6-112-rac1-priv.localdomain (192.168.190.201) 56(84) bytes of data.
64 bytes from ol6-112-rac1-priv.localdomain (192.168.190.201): icmp_seq=1 ttl=64 time=0.019 ms
64 bytes from ol6-112-rac1-priv.localdomain (192.168.190.201): icmp_seq=2 ttl=64 time=0.036 ms
64 bytes from ol6-112-rac1-priv.localdomain (192.168.190.201): icmp_seq=3 ttl=64 time=0.075 ms
--- ol6-112-rac1-priv.localdomain ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2001ms
rtt min/avg/max/mdev = 0.019/0.043/0.075/0.024 ms
[oracle@ol6-112-rac1 ~]$ ping -c 3 ol6-112-rac2
PING ol6-112-rac2.localdomain (192.168.43.102) 56(84) bytes of data.
64 bytes from ol6-112-rac2.localdomain (192.168.43.102): icmp_seq=1 ttl=64 time=0.824 ms
64 bytes from ol6-112-rac2.localdomain (192.168.43.102): icmp_seq=2 ttl=64 time=0.569 ms
64 bytes from ol6-112-rac2.localdomain (192.168.43.102): icmp_seq=3 ttl=64 time=0.312 ms
--- ol6-112-rac2.localdomain ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2002ms
rtt min/avg/max/mdev = 0.312/0.568/0.824/0.209 ms
[oracle@ol6-112-rac1 ~]$ ping -c 3 ol6-112-rac2-priv
PING ol6-112-rac2-priv.localdomain (192.168.190.202) 56(84) bytes of data.
64 bytes from ol6-112-rac2-priv.localdomain (192.168.190.202): icmp_seq=1 ttl=64 time=1.04 ms
64 bytes from ol6-112-rac2-priv.localdomain (192.168.190.202): icmp_seq=2 ttl=64 time=0.670 ms
64 bytes from ol6-112-rac2-priv.localdomain (192.168.190.202): icmp_seq=3 ttl=64 time=0.693 ms
--- ol6-112-rac2-priv.localdomain ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2003ms
rtt min/avg/max/mdev = 0.670/0.801/1.041/0.171 ms
[oracle@ol6-112-rac1 ~]$
[oracle@ol6-112-rac2 ~]$ ping -c 3 ol6-112-rac1
PING ol6-112-rac1.localdomain (192.168.43.101) 56(84) bytes of data.
64 bytes from ol6-112-rac1.localdomain (192.168.43.101): icmp_seq=1 ttl=64 time=0.517 ms
64 bytes from ol6-112-rac1.localdomain (192.168.43.101): icmp_seq=2 ttl=64 time=0.593 ms
64 bytes from ol6-112-rac1.localdomain (192.168.43.101): icmp_seq=3 ttl=64 time=0.409 ms
--- ol6-112-rac1.localdomain ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2001ms
rtt min/avg/max/mdev = 0.409/0.506/0.593/0.077 ms
[oracle@ol6-112-rac2 ~]$ ping -c 3 ol6-112-rac1-priv
PING ol6-112-rac1-priv.localdomain (192.168.190.201) 56(84) bytes of data.
64 bytes from ol6-112-rac1-priv.localdomain (192.168.190.201): icmp_seq=1 ttl=64 time=0.542 ms
64 bytes from ol6-112-rac1-priv.localdomain (192.168.190.201): icmp_seq=2 ttl=64 time=0.732 ms
64 bytes from ol6-112-rac1-priv.localdomain (192.168.190.201): icmp_seq=3 ttl=64 time=0.614 ms
--- ol6-112-rac1-priv.localdomain ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2003ms
rtt min/avg/max/mdev = 0.542/0.629/0.732/0.080 ms
[oracle@ol6-112-rac2 ~]$ ping -c 3 ol6-112-rac2
PING ol6-112-rac2.localdomain (192.168.43.102) 56(84) bytes of data.
64 bytes from ol6-112-rac2.localdomain (192.168.43.102): icmp_seq=1 ttl=64 time=0.016 ms
64 bytes from ol6-112-rac2.localdomain (192.168.43.102): icmp_seq=2 ttl=64 time=0.032 ms
64 bytes from ol6-112-rac2.localdomain (192.168.43.102): icmp_seq=3 ttl=64 time=0.041 ms
--- ol6-112-rac2.localdomain ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2000ms
rtt min/avg/max/mdev = 0.016/0.029/0.041/0.012 ms
[oracle@ol6-112-rac2 ~]$ ping -c 3 ol6-112-rac2-priv
PING ol6-112-rac2-priv.localdomain (192.168.190.202) 56(84) bytes of data.
64 bytes from ol6-112-rac2-priv.localdomain (192.168.190.202): icmp_seq=1 ttl=64 time=0.026 ms
64 bytes from ol6-112-rac2-priv.localdomain (192.168.190.202): icmp_seq=2 ttl=64 time=0.036 ms
64 bytes from ol6-112-rac2-priv.localdomain (192.168.190.202): icmp_seq=3 ttl=64 time=0.029 ms
--- ol6-112-rac2-priv.localdomain ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2001ms
rtt min/avg/max/mdev = 0.026/0.030/0.036/0.006 ms
you are able to access internet from both nodes
[oracle@ol6-112-rac1 ~]$ ping google.com
PING google.com (172.217.167.206) 56(84) bytes of data.
64 bytes from del03s18-in-f14.1e100.net (172.217.167.206): icmp_seq=1 ttl=54 time=33.9 ms
64 bytes from del03s18-in-f14.1e100.net (172.217.167.206): icmp_seq=2 ttl=54 time=38.1 ms
^C
--- google.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1375ms
rtt min/avg/max/mdev = 33.999/36.060/38.122/2.070 ms
[oracle@ol6-112-rac2 ~]$ ping google.com
PING google.com (216.58.196.206) 56(84) bytes of data.
64 bytes from kul06s14-in-f206.1e100.net (216.58.196.206): icmp_seq=1 ttl=54 time=218 ms
64 bytes from kul06s14-in-f206.1e100.net (216.58.196.206): icmp_seq=2 ttl=54 time=195 ms
^C
--- google.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1590ms
rtt min/avg/max/mdev = 195.776/207.071/218.367/11.304 ms
[oracle@ol6-112-rac2 ~]$
For enabling nslookup using dnsmasq
Disable the firewall
[root@ol6-112-rac1 ~]# service iptables stop
[root@ol6-112-rac1 ~]# chkconfig iptables off
Start dnsmasq and make sure it is enabled for reboot
[root@ol6-112-rac1 ~]# service dnsmasq start
Starting dnsmasq:
[root@ol6-112-rac1 ~]# service dnsmasq status
dnsmasq (pid 12623) is running...
[root@ol6-112-rac1 ~]# chkconfig dnsmasq on
Make sure your resolv.conf look exactly like this. Order of nameserver is important if not make the changes and lock the file.
[root@ol6-112-rac1 ~]# cp /etc/resolv.conf /etc/resolv.conf.orig
[root@ol6-112-rac1 ~]# vi /etc/resolv.conf
[root@ol6-112-rac1 ~]# cat /etc/resolv.conf
# Generated by NetworkManager
search localdomain
nameserver 127.0.0.1
nameserver 192.168.189.1
nameserver 8.8.8.8
lock the file
[root@ol6-112-rac1 ~]# chattr +i /etc/resolv.confNow login as oracle and make sure nslookup resolve scan ip in round robin
[root@ol6-112-rac1 ~]# su - oracle
[oracle@ol6-112-rac1 ~]$ nslookup ol6-112-scan
Server: 127.0.0.1
Address: 127.0.0.1#53
Name: ol6-112-scan.localdomain
Address: 192.168.43.107
Name: ol6-112-scan.localdomain
Address: 192.168.43.105
Name: ol6-112-scan.localdomain
Address: 192.168.43.106
[oracle@ol6-112-rac1 ~]$ nslookup ol6-112-scan
Server: 127.0.0.1
Address: 127.0.0.1#53
Name: ol6-112-scan.localdomain
Address: 192.168.43.105
Name: ol6-112-scan.localdomain
Address: 192.168.43.106
Name: ol6-112-scan.localdomain
Address: 192.168.43.107
[oracle@ol6-112-rac1 ~]$ nslookup ol6-112-scan
Server: 127.0.0.1
Address: 127.0.0.1#53
Name: ol6-112-scan.localdomain
Address: 192.168.43.106
Name: ol6-112-scan.localdomain
Address: 192.168.43.107
Name: ol6-112-scan.localdomain
Address: 192.168.43.105
Make same changes on ol6-112-rac2 as well.
[root@ol6-112-rac2 ~]# service iptables stop
[root@ol6-112-rac2 ~]# chkconfig iptables off
[root@ol6-112-rac2 ~]# service dnsmasq start
Starting dnsmasq: [ OK ]
[root@ol6-112-rac2 ~]# service dnsmasq status
dnsmasq (pid 4790) is running...
[root@ol6-112-rac2 ~]# chkconfig dnsmasq on
[root@ol6-112-rac2 ~]# cp /etc/resolv.conf /etc/resolv.conf.orig
[root@ol6-112-rac2 ~]# vi /etc/resolv.conf
[root@ol6-112-rac2 ~]# cat /etc/resolv.conf
# Generated by NetworkManager
search localdomain
nameserver 127.0.0.1
nameserver 192.168.189.1
nameserver 8.8.8.8
[root@ol6-112-rac2 ~]# chattr +i /etc/resolv.conf
[root@ol6-112-rac2 ~]# su - oracle
[oracle@ol6-112-rac2 ~]$ nslookup ol6-112-scan
Server: 127.0.0.1
Address: 127.0.0.1#53
Name: ol6-112-scan.localdomain
Address: 192.168.43.107
Name: ol6-112-scan.localdomain
Address: 192.168.43.105
Name: ol6-112-scan.localdomain
Address: 192.168.43.106
[oracle@ol6-112-rac2 ~]$ nslookup ol6-112-scan
Server: 127.0.0.1
Address: 127.0.0.1#53
Name: ol6-112-scan.localdomain
Address: 192.168.43.105
Name: ol6-112-scan.localdomain
Address: 192.168.43.106
Name: ol6-112-scan.localdomain
Address: 192.168.43.107
[oracle@ol6-112-rac2 ~]$ nslookup ol6-112-scan
Server: 127.0.0.1
Address: 127.0.0.1#53
Name: ol6-112-scan.localdomain
Address: 192.168.43.106
Name: ol6-112-scan.localdomain
Address: 192.168.43.107
Name: ol6-112-scan.localdomain
Address: 192.168.43.105
[oracle@ol6-112-rac2 ~]$
Check asm disk visible on both nodes
[oracle@ol6-112-rac1 ~]$ ls -al /dev/asm*
brw-rw----. 1 oracle dba 8, 17 May 14 13:04 /dev/asm-disk1
brw-rw----. 1 oracle dba 8, 33 May 14 13:04 /dev/asm-disk2
brw-rw----. 1 oracle dba 8, 49 May 14 13:04 /dev/asm-disk3
brw-rw----. 1 oracle dba 8, 65 May 14 13:04 /dev/asm-disk4
[oracle@ol6-112-rac2 ~]$ ls -al /dev/asm*
brw-rw----. 1 oracle dba 8, 17 May 14 12:20 /dev/asm-disk1
brw-rw----. 1 oracle dba 8, 33 May 14 12:20 /dev/asm-disk2
brw-rw----. 1 oracle dba 8, 49 May 14 12:20 /dev/asm-disk3
brw-rw----. 1 oracle dba 8, 65 May 14 12:20 /dev/asm-disk4
Run the grid installation
[oracle@ol6-112-rac1 grid]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 37253 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4031 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-05-14_02-23-12PM. Please wait ...[oracle@ol6-112-rac1 grid]$
Enter the details of the second node in the cluster, then click the “OK” button.
Click the “SSH Connectivity…” button and enter the password for the “oracle” user. Click the “Setup” button to to configure SSH connectivity, and the “Test” button to test it once it is complete.
Now test
Click the “Identify network interfaces…” button and check the public and private networks are specified correctly. Once you are happy with them, click the “OK” button and the “Next” button on the previous screen. We need to check eth0 (public) and eth2 (private) for our case. It should look like this. Make sure you set eth1 to do not use because it is for putty connections only.
Click ok and next
Set the redundancy to “External”, click the “Change Discovery Path” button and set the path to “/dev/asm*”. Return the main screen and select all 4 disks and click the “Next” button.
Make these changes as root user on both nodes and go BACK and then click NEXT. CHECK AGAIN option doesn’t consider the changes done at os level and will keep throwing the same error message.
[root@ol6-112-rac1 ~]# mv /usr/bin/nslookup /usr/bin/nslookup.orig
[root@ol6-112-rac1 ~]# echo '#!/bin/bash
> /usr/bin/nslookup.orig $*
> exit 0' > /usr/bin/nslookup
[root@ol6-112-rac1 ~]# chmod a+x /usr/bin/nslookup
[root@ol6-112-rac2 ~]# mv /usr/bin/nslookup /usr/bin/nslookup.orig
[root@ol6-112-rac2 ~]# echo '#!/bin/bash
> /usr/bin/nslookup.orig $*
> exit 0' > /usr/bin/nslookup
[root@ol6-112-rac2 ~]# ls -ltr /usr/bin/nslookup
-rw-r--r--. 1 root root 45 May 14 15:05 /usr/bin/nslookup
This one warning can be ignored. so click on ignore all
If all good click install
When prompted run root.sh on both nodes and click ok. first run on local node and after it completes run on remote node.
Result of On ol6-112-rac1
[root@ol6-112-rac1 oracle]# /u01/app/11.2.0.3/grid/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/11.2.0.3/grid
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 script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
OLR initialization - successful
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding Clusterware entries to upstart
CRS-2672: Attempting to start 'ora.mdnsd' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.mdnsd' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.gpnpd' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'ol6-112-rac1'
CRS-2672: Attempting to start 'ora.gipcd' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.cssdmonitor' on 'ol6-112-rac1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'ol6-112-rac1'
CRS-2672: Attempting to start 'ora.diskmon' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.diskmon' on 'ol6-112-rac1' succeeded
CRS-2676: Start of 'ora.cssd' on 'ol6-112-rac1' succeeded
ASM created and started successfully.
Disk Group DATA created successfully.
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
Successful addition of voting disk 189a78a009d24fa8bf1815ad806d52cd.
Successfully replaced voting disk group with +DATA.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 189a78a009d24fa8bf1815ad806d52cd (/dev/asm-disk1) [DATA]
Located 1 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.asm' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.DATA.dg' on 'ol6-112-rac1' succeeded
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@ol6-112-rac1 oracle]#
On ol6-112-rac2
[root@ol6-112-rac2 ~]# /u01/app/11.2.0.3/grid/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/11.2.0.3/grid
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 script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
OLR initialization - successful
Adding Clusterware entries to upstart
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node ol6-112-rac1, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
at the end i receieved this error message. click ok and try to resolve it
From the logs shown in message I see that this is the error message.
INFO: ERROR:
INFO: PRVF-7617 : Node connectivity between "ol6-112-rac1 : 192.168.43.101" and "ol6-112-rac2 : 192.168.43.105" failed
INFO: TCP connectivity check failed for subnet "192.168.43.0"
When I checked ssh connectivity from my nodes it looks like passwordless ssh was not working from one ode to another as expected. It was prompting for oracle password during ssh
[oracle@ol6-112-rac2 sshsetup]$ ssh ol6-112-rac1
Last login: Thu May 14 18:49:53 2020 from ol6-112-rac2.localdomain
[oracle@ol6-112-rac1 ~]$ ssh ol6-112-rac2
oracle@ol6-112-rac2's password:
Last login: Thu May 14 18:54:29 2020 from ol6-112-rac1.localdomain
To fix this issue I did a manual ssh setup using https://oracle-base.com/articles/linux/user-equivalence-configuration-on-linux from both the nodes and ensure that ssh is working fine without password.
Node 1 perform this step.
[root@ol6-112-rac1 ~]# su - oracle
[oracle@ol6-112-rac1 ~]$ mkdir ~/.ssh
mkdir: cannot create directory `/home/oracle/.ssh': File exists
[oracle@ol6-112-rac1 ~]$ chmod 700 ~/.ssh
[oracle@ol6-112-rac1 ~]$ /usr/bin/ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/oracle/.ssh/id_rsa):
/home/oracle/.ssh/id_rsa already exists.
Overwrite (y/n)? y
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
d3:36:ee:fb:04:b5:9f:f6:df:fd:af:16:a4:62:00:40 oracle@ol6-112-rac1.localdomain
The key's randomart image is:
+--[ RSA 2048]----+
| .E. |
| . |
| . . |
| .. . .. |
| S.= .o |
| +oo.... |
| .... +. |
| . . ...o|
| oo....@|
+-----------------+
[oracle@ol6-112-rac1 ~]$ cd ~/.ssh
[oracle@ol6-112-rac1 .ssh]$ cat id_rsa.pub >> authorized_keys
[oracle@ol6-112-rac1 .ssh]$ scp authorized_keys ol6-112-rac2:/home/oracle/.ssh/
oracle@ol6-112-rac2's password:
authorized_keys 100% 1132 1.1KB/s 00:00
[oracle@ol6-112-rac1 .ssh]$ ssh ol6-112-rac1 date
Thu May 14 19:00:03 IST 2020
[oracle@ol6-112-rac1 .ssh]$ ssh ol6-112-rac2 date
Thu May 14 19:00:09 IST 2020
[oracle@ol6-112-rac1 .ssh]$ ssh ol6-112-rac1.localdomain date
The authenticity of host 'ol6-112-rac1.localdomain (192.168.43.101)' can't be established.
RSA key fingerprint is 21:15:05:c1:76:e6:13:08:75:ba:66:e9:b2:22:b4:cf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'ol6-112-rac1.localdomain' (RSA) to the list of known hosts.
Thu May 14 19:00:27 IST 2020
[oracle@ol6-112-rac1 .ssh]$ ssh ol6-112-rac2.localdomain date
The authenticity of host 'ol6-112-rac2.localdomain (192.168.43.102)' can't be established.
RSA key fingerprint is 21:15:05:c1:76:e6:13:08:75:ba:66:e9:b2:22:b4:cf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'ol6-112-rac2.localdomain' (RSA) to the list of known hosts.
Thu May 14 19:00:34 IST 2020
[oracle@ol6-112-rac1 .ssh]$ exec /usr/bin/ssh-agent $SHELL
[oracle@ol6-112-rac1 .ssh]$ /usr/bin/ssh-add
Identity added: /home/oracle/.ssh/id_rsa (/home/oracle/.ssh/id_rsa)
Identity added: /home/oracle/.ssh/identity (/home/oracle/.ssh/identity)
On node 2
su - oracle
mkdir ~/.ssh
chmod 700 ~/.ssh
/usr/bin/ssh-keygen -t rsa # Accept the default settings.
then
[oracle@ol6-112-rac2 ~]$ cd ~/.ssh
[oracle@ol6-112-rac2 .ssh]$ cat id_rsa.pub >> authorized_keys
[oracle@ol6-112-rac2 .ssh]$ scp authorized_keys ol6-112-rac1:/home/oracle/.ssh/
authorized_keys 100% 1373 1.3KB/s 00:00
[oracle@ol6-112-rac2 .ssh]$ ssh ol6-112-rac1 date
Thu May 14 19:01:04 IST 2020
[oracle@ol6-112-rac2 .ssh]$ ssh ol6-112-rac2 date
Thu May 14 19:01:08 IST 2020
[oracle@ol6-112-rac2 .ssh]$ ssh ol6-112-rac1.localdomain date
The authenticity of host 'ol6-112-rac1.localdomain (192.168.43.101)' can't be established.
RSA key fingerprint is 21:15:05:c1:76:e6:13:08:75:ba:66:e9:b2:22:b4:cf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'ol6-112-rac1.localdomain' (RSA) to the list of known hosts.
Thu May 14 19:01:13 IST 2020
[oracle@ol6-112-rac2 .ssh]$ ssh ol6-112-rac2.localdomain date
The authenticity of host 'ol6-112-rac2.localdomain (192.168.43.102)' can't be established.
RSA key fingerprint is 21:15:05:c1:76:e6:13:08:75:ba:66:e9:b2:22:b4:cf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'ol6-112-rac2.localdomain' (RSA) to the list of known hosts.
Thu May 14 19:01:22 IST 2020
[oracle@ol6-112-rac2 .ssh]$ exec /usr/bin/ssh-agent $SHELL
[oracle@ol6-112-rac2 .ssh]$ /usr/bin/ssh-add
Identity added: /home/oracle/.ssh/id_rsa (/home/oracle/.ssh/id_rsa)
Identity added: /home/oracle/.ssh/identity (/home/oracle/.ssh/identity)
[oracle@ol6-112-rac2 .ssh]$ ssh ol6-112-rac1
Last login: Thu May 14 18:55:28 2020 from ol6-112-rac2.localdomain
[oracle@ol6-112-rac1 ~]$ ssh ol6-112-rac2
Last login: Thu May 14 18:55:44 2020 from ol6-112-rac1.localdomain
[oracle@ol6-112-rac2 ~]$ ssh ol6-112-rac1.localdomain
Last login: Thu May 14 19:01:43 2020 from ol6-112-rac2.localdomain
[oracle@ol6-112-rac1 ~]$ ssh ol6-112-rac2.localdomain
Last login: Thu May 14 19:01:46 2020 from ol6-112-rac1.localdomain
aftre setting this I pressed retry and it went successful. After that click next
Click next and Click close
Install the Database
[oracle@ol6-112-rac1 database]$ pwd
/shared_dir/11.2.0.3/database
[oracle@ol6-112-rac1 database]$ ls
doc install readme.html response rpm runInstaller sshsetup stage welcome.html
[oracle@ol6-112-rac1 database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 35868 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3995 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-05-14_08-10-13PM. Please wait ...[oracle@ol6-112-rac1 database]$
run root.sh on both nodes.
[root@ol6-112-rac1 ~]# /u01/app/oracle/product/11.2.0.3/db_1/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.3/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 script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@ol6-112-rac2 ~]# /u01/app/oracle/product/11.2.0.3/db_1/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.3/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 script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@ol6-112-rac2 ~]#
Check the Status of the RAC
[oracle@ol6-112-rac1 ~]$ srvctl config database -d TROY
Database unique name: TROY
Database name: TROY
Oracle home: /u01/app/oracle/product/11.2.0.3/db_1
Oracle user: oracle
Spfile: +DATA/TROY/spfileTROY.ora
Domain: localdomain
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: TROY
Database instances: TROY1,TROY2
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Database is administrator managed
[oracle@ol6-112-rac1 ~]$ srvctl status database -d TROY
Instance TROY1 is running on node ol6-112-rac1
Instance TROY2 is running on node ol6-112-rac2
[oracle@ol6-112-rac1 ~]$
[oracle@ol6-112-rac1 ~]$ cd
[oracle@ol6-112-rac1 ~]$ ls
db_env Desktop Documents Downloads grid_env grid.rsp Music old.Xauthority oradata oradiag_oracle Pictures Public Templates Videos
[oracle@ol6-112-rac1 ~]$ db_env
[oracle@ol6-112-rac1 ~]$ env|grep ORA
ORACLE_UNQNAME=TROY
ORACLE_SID=TROY1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOSTNAME=ol6-112-rac1.localdomain
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/db_1
[oracle@ol6-112-rac1 ~]$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Thu May 14 20:47:24 2020
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> SELECT inst_name FROM v$active_instances;
INST_NAME
--------------------------------------------------------------------------------
ol6-112-rac1.localdomain:TROY1
ol6-112-rac2.localdomain:TROY2
[oracle@ol6-112-rac1 ~]$ grid_env
[oracle@ol6-112-rac1 ~]$ env|grep ORA
ORACLE_UNQNAME=TROY
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOSTNAME=ol6-112-rac1.localdomain
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/11.2.0.3/grid
[oracle@ol6-112-rac1 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[oracle@ol6-112-rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE ol6-112-rac1
ONLINE ONLINE ol6-112-rac2
ora.LISTENER.lsnr
ONLINE ONLINE ol6-112-rac1
ONLINE ONLINE ol6-112-rac2
ora.asm
ONLINE ONLINE ol6-112-rac1 Started
ONLINE ONLINE ol6-112-rac2 Started
ora.gsd
OFFLINE OFFLINE ol6-112-rac1
OFFLINE OFFLINE ol6-112-rac2
ora.net1.network
ONLINE ONLINE ol6-112-rac1
ONLINE ONLINE ol6-112-rac2
ora.ons
ONLINE ONLINE ol6-112-rac1
ONLINE ONLINE ol6-112-rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ol6-112-rac2
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE ol6-112-rac1
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE ol6-112-rac1
ora.cvu
1 ONLINE ONLINE ol6-112-rac1
ora.oc4j
1 ONLINE ONLINE ol6-112-rac1
ora.ol6-112-rac1.vip
1 ONLINE ONLINE ol6-112-rac1
ora.ol6-112-rac2.vip
1 ONLINE ONLINE ol6-112-rac2
ora.scan1.vip
1 ONLINE ONLINE ol6-112-rac2
ora.scan2.vip
1 ONLINE ONLINE ol6-112-rac1
ora.scan3.vip
1 ONLINE ONLINE ol6-112-rac1
ora.troy.db
1 ONLINE ONLINE ol6-112-rac1 Open
2 ONLINE ONLINE ol6-112-rac2 Open
[oracle@ol6-112-rac1 ~]$ olsnodes
ol6-112-rac1
ol6-112-rac2
[oracle@ol6-112-rac1 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node ol6-112-rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node ol6-112-rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node ol6-112-rac1
DBATracker 