Oracle 11g Release 1 RAC Installation Steps On Linux
Oracle Clusterware Install
Action : Click "Next"
Actions : Enter the new node details
Action : Click "Next".
Actions :
Actions :
Action : None required.
Oracle ASM Home Software Install.
Verify the cluster is configured correctly for an instance creation.
Action : Select the Enterprise Edition radio button and click "Next"
Action : Confirm entries are OK and Click "Next"
Actions : Click "Select All" and Click "Next"
Action : None Required click "Next"
Action : Select Install Software Only ration button and click "Next"
Action : Review summary and click "Install".
Action : None Required.
Action : Click "Exit"
Oracle RAC Database Listener Creation
Action : Select "Cluster Configuration" ration button and click "Next"
Action : Click Select all nodes and "click Next"
Action : Select Listener Configuration Ratio button and click "Next"
Action : Select Add Ratio button and click "Next"
Action : Click "Next"
Action : Ensure the Selected Protocols list includes TCP and click "Next"
Action : Ensure the Use the Standard port number of 1521 radio button is set and click "Next"
Action : Select No ratio button and click "Next"
Action : Click "Next"
Oracle ASM Instance and diskgroup Creation
Action : Select Configure Automatic Storage Management ration button and click "Next"
Action : Click Select All and click "Next"
Action : Enter the SYS Password and click "Next"
Action: Click "OK"
Action : None required.
Action: Click Create New
Action : Ensure the Disk Group Name, Redundancy, select disks and click "OK"
Action : None required.
Repeat the same steps for FRA Disk group creation.
Action: Click "Finish"
Action: Select Enterprise Edition ration button and click "Next"
Action : Ensure Oracle Base, Name, Path and click "Next"
Action : Nothing required click "Next".
Action : Select All and click "Next"
Action: Select Install Software Only ration button.
Action : Click "Install".
Action : Run root.sh script as a root and click "OK"
Action : Click "Exit"
Action: Select Real Application Clusters Databases ration button and click "Next".
Action : Select General Purpose or Transaction Processing and click "Next"
Action : Enter the Database name and click "Next"
Action: Select Enterprise Manager Configuration and click "Next"
Action : Enter Administrative Password and click "Next"
Action: Select Automatic Memory Management(ASM) and click "OK"
Action: Select ASM Disk Group and click "Next"
Action: Ensure Flash Recovery Area Disk Group and Click "Next"
Action : Ensure Sample Schema and Click "Next"
Action : Nothing Required.
Action : Ensure Recommended one click "Next"
Action : Select Automatic Maintenance Enable Task ration button and click "Next"
Action : Nothing Required.
Action : Click "Finish".
Action : Click "OK"
Once the database creation is complete you are presented with the following screen.
krac2
TNSNAMES.ORA.
---------------------------------------------------------------------------------------------------------------------------
Oracle 11gR1(11.1.0.6.0) Real Application Cluster Installation (RAC)
Installation Steps on Linux
Installation Prerequisite:
Perform below steps in all nodes as a root user.
Step 1: Install below RPM's as a root user.
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.1
gcc-c++-4.1.1
glibc-2.5-12
glibc-2.5-12 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5-12 (32 bit)
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libgcc-4.1.1
libgcc-4.1.1 (32 bit)
libstdc++-4.1.1
libstdc++-4.1.1 (32 bit)
libstdc++-devel 4.1.1
make-3.81
sysstat-7.0.0
To install RPM use below command as a root user.
rpm -Uvh <rpm_name> or
rpm -ivh <rpm_name>
Step 2: The "/etc/hosts" file must contain the following information.
##################################################
### LocalHost
##################################################
127.0.0.1 localhost.localdomain localhost
##################################################
### Public IP Address
##################################################
152.168.1.50 krac1.dbprod.com krac1
152.168.1.51 krac2.dbprod.com krac2
##################################################
### Private IP Address
##################################################
192.168.1.50 krac1-priv.dbprod.com krac1-priv
192.168.1.51 krac2-priv.dbprod.com krac2-priv
##################################################
### VIP Address
##################################################
152.168.1.60 krac1-vip.dbprod.com krac1-vip
152.168.1.61 krac2-vip.dbprod.com krac2-vip
Step 3: Add the following lines to the "/etc/sysctl.conf" file.
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
Step 4: Run the following command to change the current kernel parameters.
/sbin/sysctl -p
Step 5: Configuration of the Hangcheck-timer Module
on Kernel 2.4 enter a command similar to the following to start the module on that node:
/sbin/insmod hangcheck-timer hangcheck_tick=1 hangcheck_margin=10 hangcheck_reboot=1
on Kernel 2.6 enter a command similar to the following to start the module located in the directories of the current kernel version:
/sbin/insmod /lib/modules/`uname -r`/kernel/drivers/char/hangcheck-timer.ko
hangcheck_tick=1 hangcheck_margin=10 hangcheck_reboot=1
Add the above command into /etc/rc.d/rc.local file.
Step 6: Create the new groups and users.
[root@krac1 ~]# groupadd -g 501 oinstall
[root@krac1 ~]# groupadd -g 502 dba
[root@krac1 ~]# groupadd -g 503 oper
[root@krac1 ~]# groupadd -g 504 asmadmin
[root@krac1 ~]# useradd -u 501 -c "Oracle Clusterware Owner" -g oinstall crs
[root@krac1 ~]# useradd -u 502 -c "Oracle Software Owner" -g oinstall -G dba,oper,asmadmin oracle
[root@krac1 ~]# passwd crs
Changing password for user crs.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@krac1 ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@krac1 ~]#
Step 7: Add the following lines to the "/etc/security/limits.conf" file.
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
crs soft nproc 2047
crs hard nproc 16384
crs soft nofile 1024
crs hard nofile 65536
step 8 : Add the following lines to the "/etc/pam.d/login" file, if it does not already exist.
session required /lib/security/pam_limits.so
Step 9 : Add the following lines to the "/etc/profile" file.
if [[ $USER = "oracle" ] || [ $USER = "crs" ]]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
Step 10 : Configuring SSH on Cluster Member Nodes
su - crs
[crs@krac1 ~]$ mkdir ~/.ssh
[crs@krac1 ~]$ chmod 700 ~/.ssh
[crs@krac1 ~]$ cd ~/.ssh
[crs@krac1 .ssh]$/usr/bin/ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/crs/.ssh/id_rsa): <ENTER>
Enter passphrase (empty for no passphrase): <ENTER>
Enter same passphrase again:
Your identification has been saved in /home/crs/.ssh/id_rsa.
Your public key has been saved in /home/crs/.ssh/id_rsa.pub.
The key fingerprint is:
73:49:56:a3:ed:e4:4e:b2:66:35:32:c6:d1:7d:e1:17 crs@krac1.dbprod.com
[crs@krac1 ~]$ /usr/bin/ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/home/crs/.ssh/id_dsa):
Enter passphrase (empty for no passphrase): <ENTER>
Enter same passphrase again: <ENTER>
Your identification has been saved in /home/crs/.ssh/id_dsa.
Your public key has been saved in /home/crs/.ssh/id_dsa.pub.
The key fingerprint is:
66:64:8c:2f:44:a4:c2:bd:a5:4e:46:a8:dc:d6:1b:11 crs@krac1.dbprod.com
[crs@krac1 .ssh]$ touch authorized_keys
[crs@krac1 .ssh]$ cat id_rsa.pub > authorized_keys
[crs@krac1 .ssh]$ cat id_dsa.pub >> authorized_keys
[crs@krac1 .ssh]$ scp authorized_keys crs@krac2:/home/crs/.ssh/.
crs@krac2's password:
authorized_keys 100% 1012 1.0KB/s 00:00
su - oracle
[oracle@krac2 ~]$ mkdir ~/.ssh
[oracle@krac2 ~]$ chmod 700 ~/.ssh
[oracle@krac2 ~]$ /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):
Enter passphrase (empty for no passphrase): <ENTER>
Enter same passphrase again: <ENTER>
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:
39:3a:5b:82:e2:56:9c:72:4b:7c:ee:6c:50:2c:f9:5e oracle@krac2.dbprod.com
[oracle@krac2 ~]$ /usr/bin/ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/home/oracle/.ssh/id_dsa):
Enter passphrase (empty for no passphrase): <ENTER>
Enter same passphrase again: <ENTER>
Your identification has been saved in /home/oracle/.ssh/id_dsa.
Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.
The key fingerprint is:
b0:4d:a9:0c:0d:1b:f3:77:f6:fc:1a:71:17:10:35:4f oracle@krac2.dbprod.com
[oracle@krac2 .ssh]$ cat id_rsa.pub >> authorized_keys
[oracle@krac2 .ssh]$ cat id_dsa.pub >> authorized_keys
[oracle@krac2 .ssh]$ scp authorized_keys oracle@krac1:/home/oracle/.ssh/.
The authenticity of host 'krac1 (152.168.1.50)' can't be established.
RSA key fingerprint is e4:b5:5e:ab:5c:0b:a3:f4:20:1a:1f:3f:ad:04:50:f1.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'krac1,152.168.1.50' (RSA) to the list of known hosts.
oracle@krac1's password:
authorized_keys 100% 1012 1.0KB/s 00:00
The "authorized_keys" file on both servers now contains the public keys generated on all RAC nodes.
Step 11 : Enabling SSH User Equivalency on Cluster Member Nodes
ssh krac1 date
ssh krac2 date
ssh krac1.dbprod.com date
ssh krac2.dbprod.com date
ssh krac1-priv date
ssh krac2-priv date
ssh krac1-priv.dbprod.com date
ssh krac2-priv.dbprod.com date
You should now be able to SSH and SCP between servers without entering passwords.
Step 14: Create the directories in which the Oracle software will be installed.
[root@krac1 ~]# mkdir /u01/crs11g
[root@krac1 ~]# chown root:oinstall /u01/crs11g/
[root@krac1 ~]# chmod 775 /u01/crs11g
[root@krac1 ~]# mkdir -p /u02/app/oracle/product/11.1.0/db_1
[root@krac1 ~]# mkdir -p /u02/app/oracle/product/11.1.0/asm_1
[root@krac1 ~]# chown -R oracle:oinstall /u02/app/oracle
[root@krac1 ~]# chmod -R 775 /u02/app/oracle
Step 15 : Prepare the shared storage for Oracle RAC
# cd /dev
# ls sd*
sda sda1 sda2 sdb sdc sdd sde sdf sdg
Use the "fdisk" command to partition the disks sdb to sdg. The following output shows the
expected fdisk output for the sdb disk.
[root@krac1 ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. 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)
Command (m for help): p
Disk /dev/sdc: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-130, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-130, default 130):
Using default value 130
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
Load the updated block device partition tables by running the following on ALL servers participating in the cluster:
[root@krac2 ~]# /sbin/partprobe /dev/sdb
[root@krac2 ~]# /sbin/partprobe /dev/sdc
[root@krac2 ~]# /sbin/partprobe /dev/sdd
[root@krac2 ~]# /sbin/partprobe /dev/sde
[root@krac2 ~]# /sbin/partprobe /dev/sdf
[root@krac2 ~]# /sbin/partprobe /dev/sdg
Step 17 : Edit the "/etc/sysconfig/rawdevices" file, adding the following lines.
/dev/raw/raw1 /dev/sdb1
/dev/raw/raw2 /dev/sdc1
/dev/raw/raw3 /dev/sdd1
/dev/raw/raw4 /dev/sde1
/dev/raw/raw5 /dev/sdf1
Step 18 : Run the following commands and add them the "/etc/rc.local" file.
chown root:oinstall /dev/raw/raw1
chown crs:oinstall /dev/raw/raw2
chown oracle:oinstall /dev/raw/raw3
chown oracle:oinstall /dev/raw/raw4
chown oracle:oinstall /dev/raw/raw5
chown oracle:oinstall /dev/raw/raw6
chmod 640 /dev/raw/raw1
chmod 640 /dev/raw/raw2
chmod 640 /dev/raw/raw3
chmod 640 /dev/raw/raw4
chmod 640 /dev/raw/raw5
chmod 640 /dev/raw/raw6
Step 19: Cluster Verification Utility stage check
[crs@krac1 clusterware]$ ./runcluvfy.sh stage -pre crsinst -n krac1,krac2 -verbose
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "krac1"
Destination Node Reachable?
------------------------------------ ------------------------
krac1 yes
krac2 yes
Result: Node reachability check passed from node "krac1".
Checking user equivalence...
Check: User equivalence for user "crs"
Node Name Comment
------------------------------------ ------------------------
krac2 passed
krac1 passed
Result: User equivalence check passed for user "crs".
Checking administrative privileges...
Check: Existence of user "crs"
Node Name User Exists Comment
------------ ------------------------ ------------------------
krac2 yes passed
krac1 yes passed
Result: User existence check passed for "crs".
Check: Existence of group "oinstall"
Node Name Status Group ID
------------ ------------------------ ------------------------
krac2 exists 501
krac1 exists 501
Result: Group existence check passed for "oinstall".
Check: Membership of user "crs" in group "oinstall" [as Primary]
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
krac2 yes yes yes yes passed
krac1 yes yes yes yes passed
Result: Membership check for user "crs" in group "oinstall" [as Primary] passed.
Administrative privileges check passed.
Checking node connectivity...
Interface information for node "krac2"
Interface Name IP Address Subnet Subnet Gateway Default Gateway Hardware Address
---------------- ------------ ------------ ------------ ------------ ------------
eth0 152.168.1.51 152.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:F7:59:F7
eth1 192.168.1.51 192.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:F7:59:01
Interface information for node "krac1"
Interface Name IP Address Subnet Subnet Gateway Default Gateway Hardware Address
---------------- ------------ ------------ ------------ ------------ ------------
eth0 152.168.1.50 152.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:71:EE:43
eth1 192.168.1.50 192.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:71:EE:4D
Check: Node connectivity of subnet "152.168.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
krac2:eth0 krac1:eth0 yes
Result: Node connectivity check passed for subnet "152.168.1.0" with node(s) krac2,krac1.
Check: Node connectivity of subnet "192.168.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
krac2:eth1 krac1:eth1 yes
Result: Node connectivity check passed for subnet "192.168.1.0" with node(s) krac2,krac1.
Interfaces found on subnet "152.168.1.0" that are likely candidates for VIP:
krac2 eth0:152.168.1.51
krac1 eth0:152.168.1.50
Interfaces found on subnet "192.168.1.0" that are likely candidates for VIP:
krac2 eth1:192.168.1.51
krac1 eth1:192.168.1.50
WARNING:
Could not find a suitable set of interfaces for the private interconnect.
Result: Node connectivity check passed.
Checking system requirements for 'crs'...
Check: Total memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 1.98GB (2075468KB) 1GB (1048576KB) passed
krac1 1.98GB (2075468KB) 1GB (1048576KB) passed
Result: Total memory check passed.
Check: Free disk space in "/tmp" dir
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 6.62GB (6946444KB) 400MB (409600KB) passed
krac1 6.52GB (6833792KB) 400MB (409600KB) passed
Result: Free disk space check passed.
Check: Swap space
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 3.42GB (3582484KB) 1.5GB (1572864KB) passed
krac1 3.42GB (3582484KB) 1.5GB (1572864KB) passed
Result: Swap space check passed.
Check: System architecture
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 i686 i686 passed
krac1 i686 i686 passed
Result: System architecture check passed.
Check: Kernel version
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 2.6.18-194.el5 2.6.9 passed
krac1 2.6.18-194.el5 2.6.9 passed
Result: Kernel version check passed.
Check: Package existence for "make-3.81"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 make-3.81-3.el5 passed
krac1 make-3.81-3.el5 passed
Result: Package existence check passed for "make-3.81".
Check: Package existence for "binutils-2.17.50.0.6"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 binutils-2.17.50.0.6-14.el5 passed
krac1 binutils-2.17.50.0.6-14.el5 passed
Result: Package existence check passed for "binutils-2.17.50.0.6".
Check: Package existence for "gcc-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 gcc-4.1.2-48.el5 passed
krac1 gcc-4.1.2-48.el5 passed
Result: Package existence check passed for "gcc-4.1.1".
Check: Package existence for "libaio-0.3.106"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libaio-0.3.106-5 passed
krac1 libaio-0.3.106-5 passed
Result: Package existence check passed for "libaio-0.3.106".
Check: Package existence for "libaio-devel-0.3.106"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libaio-devel-0.3.106-5 passed
krac1 libaio-devel-0.3.106-5 passed
Result: Package existence check passed for "libaio-devel-0.3.106".
Check: Package existence for "libstdc++-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libstdc++-4.1.2-48.el5 passed
krac1 libstdc++-4.1.2-48.el5 passed
Result: Package existence check passed for "libstdc++-4.1.1".
Check: Package existence for "elfutils-libelf-devel-0.125"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 elfutils-libelf-devel-0.137-3.el5 passed
krac1 elfutils-libelf-devel-0.137-3.el5 passed
Result: Package existence check passed for "elfutils-libelf-devel-0.125".
Check: Package existence for "sysstat-7.0.0"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 sysstat-7.0.2-3.el5 passed
krac1 sysstat-7.0.2-3.el5 passed
Result: Package existence check passed for "sysstat-7.0.0".
Check: Package existence for "compat-libstdc++-33-3.2.3"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 compat-libstdc++-33-3.2.3-61 passed
krac1 compat-libstdc++-33-3.2.3-61 passed
Result: Package existence check passed for "compat-libstdc++-33-3.2.3".
Check: Package existence for "libgcc-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libgcc-4.1.2-48.el5 passed
krac1 libgcc-4.1.2-48.el5 passed
Result: Package existence check passed for "libgcc-4.1.1".
Check: Package existence for "libstdc++-devel-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libstdc++-devel-4.1.2-48.el5 passed
krac1 libstdc++-devel-4.1.2-48.el5 passed
Result: Package existence check passed for "libstdc++-devel-4.1.1".
Check: Package existence for "unixODBC-2.2.11"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 unixODBC-2.2.11-7.1 passed
krac1 unixODBC-2.2.11-7.1 passed
Result: Package existence check passed for "unixODBC-2.2.11".
Check: Package existence for "unixODBC-devel-2.2.11"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 unixODBC-devel-2.2.11-7.1 passed
krac1 unixODBC-devel-2.2.11-7.1 passed
Result: Package existence check passed for "unixODBC-devel-2.2.11".
Check: Package existence for "glibc-2.5-12"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 glibc-2.5-49 passed
krac1 glibc-2.5-49 passed
Result: Package existence check passed for "glibc-2.5-12".
Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
krac2 exists passed
krac1 exists passed
Result: Group existence check passed for "dba".
Check: Group existence for "oinstall"
Node Name Status Comment
------------ ------------------------ ------------------------
krac2 exists passed
krac1 exists passed
Result: Group existence check passed for "oinstall".
Check: User existence for "nobody"
Node Name Status Comment
------------ ------------------------ ------------------------
krac2 exists passed
krac1 exists passed
Result: User existence check passed for "nobody".
System requirement passed for 'crs'
Pre-check for cluster services setup was successful.
Oracle Clusterware Install
su - crs
./runInstaller
Action : Entry the full path of the inventory directory, Operating system group name and click "Next"
Action:
- Confirm the Cluster Name selected is acceptable
- Confirm the Details for the current node are OK.
- The defaults are:
- Public Node Name : must resolve via hosts and or DNS to the public IP address and must be live
- Private Node Name : must resolve via hosts to the interconnect IP address and must be live
- Virtual Host Name : must resolve via hosts and or DNS to a new IP address and must not be live
- If these are not correct select the node entry and click Edit... to modify OR Click Add... to add more nodes to the cluster
Actions : Enter the new node details
- Public Node Name : must resolve via hosts and or DNS to the public IP address and must be live
- Private Node Name : must resolve via hosts to the interconnect IP address and must be live
- Virtual Host Name : must resolve via hosts and or DNS to a new IP address and must not be live
- Click OK to return to the node list for the cluster
Actions : Select the Interface Type : Public radio button and Click "OK"
- Select the External radio button
- Enter the device to be used for the OCR
- Click Next
- Select the External radio button
- Enter the device to be used for the vote disk
Action : Click "Install"
#orainstRoot.sh and root.sh script output on rac1
[root@krac1 ~]# /u02/app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /u02/app/oracle/oraInventory to 770.
Changing groupname of /u02/app/oracle/oraInventory to oinstall.
The execution of the script is complete
[root@krac1 ~]# /u01/crs11g/root.sh
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
Setting the permissions on OCR backup directory
Setting up Network socket directories
Oracle Cluster Registry configuration upgraded successfully
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node< nodenumber>: <nodename> <private interconnect name>< hostname>
node 1: krac1 krac1-priv krac1
node 2: krac2 krac2-priv krac2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /dev/raw/raw2
Format of 1 voting devices complete.
/etc/profile: line 65: ulimit: open files: cannot modify limit: Operation not permitted
Startup will be queued to init within 30 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
Cluster Synchronization Services is active on these nodes.
krac1
Cluster Synchronization Services is inactive on these nodes.
krac2
Local node checking complete. Run root.sh on remaining nodes to start CRS daemons.
[root@krac1 ~]#
#orainstRoot.sh and root.sh script output on rac2
[root@krac2 ~]# /u02/app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /u02/app/oracle/oraInventory to 770.
Changing groupname of /u02/app/oracle/oraInventory to oinstall.
The execution of the script is complete
[root@krac2 ~]# /u01/crs11g/root.sh
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
Setting the permissions on OCR backup directory
Setting up Network socket directories
Oracle Cluster Registry configuration upgraded successfully
clscfg: EXISTING configuration version 4 detected.
clscfg: version 4 is 11 Release 1.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node< nodenumber>: <nodename> <private interconnect name>< hostname>
node 1: krac1 krac1-priv krac1
node 2: krac2 krac2-priv krac2
clscfg: Arguments check out successfully.
NO KEYS WERE WRITTEN. Supply -force parameter to override.
-force is destructive and will destroy any previous cluster
configuration.
Oracle Cluster Registry for cluster has already been initialized
/etc/profile: line 65: ulimit: open files: cannot modify limit: Operation not permitted
Startup will be queued to init within 30 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
Cluster Synchronization Services is active on these nodes.
krac1
krac2
Cluster Synchronization Services is active on all the nodes.
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps
Creating VIP application resource on (2) nodes...
Creating GSD application resource on (2) nodes...
Creating ONS application resource on (2) nodes...
Starting VIP application resource on (2) nodes...
Starting GSD application resource on (2) nodes...
Starting ONS application resource on (2) nodes...
Done.
Action : Click Exit.
[crs@krac1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.krac1.gsd application 0/5 0/0 ONLINE ONLINE krac1
ora.krac1.ons application 0/3 0/0 ONLINE ONLINE krac1
ora.krac1.vip application 0/0 0/0 ONLINE ONLINE krac1
ora.krac2.gsd application 0/5 0/0 ONLINE ONLINE krac2
ora.krac2.ons application 0/3 0/0 ONLINE ONLINE krac2
ora.krac2.vip application 0/0 0/0 ONLINE ONLINE krac2
[crs@krac1 ~]$
Post CUV Check for clusterware post installation.
[crs@krac1 ~]$ cluvfy stage -post crsinst -n krac1,krac2 -verbose
Performing post-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "krac1"
Destination Node Reachable?
------------------------------------ ------------------------
krac1 yes
krac2 yes
Result: Node reachability check passed from node "krac1".
Checking user equivalence...
Check: User equivalence for user "crs"
Node Name Comment
------------------------------------ ------------------------
krac2 passed
krac1 passed
Result: User equivalence check passed for user "crs".
Checking Cluster manager integrity...
Checking CSS daemon...
Node Name Status
------------------------------------ ------------------------
krac2 running
krac1 running
Result: Daemon status check passed for "CSS daemon".
Cluster manager integrity check passed.
Checking cluster integrity...
Node Name
------------------------------------
krac1
krac2
Cluster integrity check passed
Checking OCR integrity...
Checking the absence of a non-clustered configuration...
All nodes free of non-clustered, local-only configurations.
Uniqueness check for OCR device passed.
Checking the version of OCR...
OCR of correct Version "2" exists.
Checking data integrity of OCR...
Data integrity check for OCR passed.
OCR integrity check passed.
Checking CRS integrity...
Checking daemon liveness...
Check: Liveness for "CRS daemon"
Node Name Running
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: Liveness check passed for "CRS daemon".
Checking daemon liveness...
Check: Liveness for "CSS daemon"
Node Name Running
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: Liveness check passed for "CSS daemon".
Checking daemon liveness...
Check: Liveness for "EVM daemon"
Node Name Running
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: Liveness check passed for "EVM daemon".
Liveness of all the daemons
Node Name CRS daemon CSS daemon EVM daemon
------------ ------------------------ ------------------------ ----------
krac2 yes yes yes
krac1 yes yes yes
Checking CRS health...
Check: Health of CRS
Node Name CRS OK?
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: CRS health check passed.
CRS integrity check passed.
Checking node application existence...
Checking existence of VIP node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
krac2 yes exists passed
krac1 yes exists passed
Result: Check passed.
Checking existence of ONS node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
krac2 no exists passed
krac1 no exists passed
Result: Check passed.
Checking existence of GSD node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
krac2 no exists passed
krac1 no exists passed
Result: Check passed.
Post-check for cluster services setup was successful.
Oracle ASM Home Software Install.
CVU check before creating ASM instance.
Verify the cluster is configured correctly for an instance creation.
[oracle@krac1 clusterware]$ ./runcluvfy.sh stage -pre dbinst -n krac1,krac2 -verbose
Performing pre-checks for database installation
Checking node reachability...
Check: Node reachability from node "krac1"
Destination Node Reachable?
------------------------------------ ------------------------
krac1 yes
krac2 yes
Result: Node reachability check passed from node "krac1".
Checking user equivalence...
Check: User equivalence for user "oracle"
Node Name Comment
------------------------------------ ------------------------
krac2 passed
krac1 passed
Result: User equivalence check passed for user "oracle".
Checking administrative privileges...
Check: Existence of user "oracle"
Node Name User Exists Comment
------------ ------------------------ ------------------------
krac2 yes passed
krac1 yes passed
Result: User existence check passed for "oracle".
Check: Existence of group "oinstall"
Node Name Status Group ID
------------ ------------------------ ------------------------
krac2 exists 501
krac1 exists 501
Result: Group existence check passed for "oinstall".
Check: Membership of user "oracle" in group "oinstall" [as Primary]
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
krac2 yes yes yes yes passed
krac1 yes yes yes yes passed
Result: Membership check for user "oracle" in group "oinstall" [as Primary] passed.
Check: Existence of group "dba"
Node Name Status Group ID
------------ ------------------------ ------------------------
krac2 exists 502
krac1 exists 502
Result: Group existence check passed for "dba".
Check: Membership of user "oracle" in group "dba"
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
krac2 yes yes yes no passed
krac1 yes yes yes no passed
Result: Membership check for user "oracle" in group "dba" passed.
Administrative privileges check passed.
Checking node connectivity...
Interface information for node "krac2"
Interface Name IP Address Subnet Subnet Gateway Default Gateway Hardware Address
---------------- ------------ ------------ ------------ ------------ ------------
eth0 152.168.1.51 152.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:F7:59:F7
eth0 152.168.1.61 152.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:F7:59:F7
eth1 192.168.1.51 192.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:F7:59:01
Interface information for node "krac1"
Interface Name IP Address Subnet Subnet Gateway Default Gateway Hardware Address
---------------- ------------ ------------ ------------ ------------ ------------
eth0 152.168.1.50 152.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:71:EE:43
eth0 152.168.1.60 152.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:71:EE:43
eth1 192.168.1.50 192.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:71:EE:4D
Check: Node connectivity of subnet "152.168.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
krac2:eth0 krac2:eth0 yes
krac2:eth0 krac1:eth0 yes
krac2:eth0 krac1:eth0 yes
krac2:eth0 krac1:eth0 yes
krac2:eth0 krac1:eth0 yes
krac1:eth0 krac1:eth0 yes
Result: Node connectivity check passed for subnet "152.168.1.0" with node(s) krac2,krac1.
Check: Node connectivity of subnet "192.168.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
krac2:eth1 krac1:eth1 yes
Result: Node connectivity check passed for subnet "192.168.1.0" with node(s) krac2,krac1.
Interfaces found on subnet "152.168.1.0" that are likely candidates for VIP:
krac2 eth0:152.168.1.51 eth0:152.168.1.61
krac1 eth0:152.168.1.50 eth0:152.168.1.60
Interfaces found on subnet "192.168.1.0" that are likely candidates for VIP:
krac2 eth1:192.168.1.51
krac1 eth1:192.168.1.50
WARNING:
Could not find a suitable set of interfaces for the private interconnect.
Result: Node connectivity check passed.
Checking system requirements for 'database'...
Check: Total memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 1.98GB (2075468KB) 1GB (1048576KB) passed
krac1 1.98GB (2075468KB) 1GB (1048576KB) passed
Result: Total memory check passed.
Check: Free disk space in "/tmp" dir
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 6.47GB (6787332KB) 400MB (409600KB) passed
krac1 6.51GB (6827884KB) 400MB (409600KB) passed
Result: Free disk space check passed.
Check: Swap space
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 3.42GB (3582484KB) 1.5GB (1572864KB) passed
krac1 3.42GB (3582484KB) 1.5GB (1572864KB) passed
Result: Swap space check passed.
Check: System architecture
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 i686 i686 passed
krac1 i686 i686 passed
Result: System architecture check passed.
Check: Kernel version
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 2.6.18-194.el5 2.6.18 passed
krac1 2.6.18-194.el5 2.6.18 passed
Result: Kernel version check passed.
Check: Package existence for "make-3.81"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 make-3.81-3.el5 passed
krac1 make-3.81-3.el5 passed
Result: Package existence check passed for "make-3.81".
Check: Package existence for "binutils-2.17.50.0.6"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 binutils-2.17.50.0.6-14.el5 passed
krac1 binutils-2.17.50.0.6-14.el5 passed
Result: Package existence check passed for "binutils-2.17.50.0.6".
Check: Package existence for "gcc-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 gcc-4.1.2-48.el5 passed
krac1 gcc-4.1.2-48.el5 passed
Result: Package existence check passed for "gcc-4.1.1".
Check: Package existence for "libaio-0.3.106"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libaio-0.3.106-5 passed
krac1 libaio-0.3.106-5 passed
Result: Package existence check passed for "libaio-0.3.106".
Check: Package existence for "libaio-devel-0.3.106"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libaio-devel-0.3.106-5 passed
krac1 libaio-devel-0.3.106-5 passed
Result: Package existence check passed for "libaio-devel-0.3.106".
Check: Package existence for "libstdc++-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libstdc++-4.1.2-48.el5 passed
krac1 libstdc++-4.1.2-48.el5 passed
Result: Package existence check passed for "libstdc++-4.1.1".
Check: Package existence for "elfutils-libelf-devel-0.125"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 elfutils-libelf-devel-0.137-3.el5 passed
krac1 elfutils-libelf-devel-0.137-3.el5 passed
Result: Package existence check passed for "elfutils-libelf-devel-0.125".
Check: Package existence for "sysstat-7.0.0"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 sysstat-7.0.2-3.el5 passed
krac1 sysstat-7.0.2-3.el5 passed
Result: Package existence check passed for "sysstat-7.0.0".
Check: Package existence for "compat-libstdc++-33-3.2.3"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 compat-libstdc++-33-3.2.3-61 passed
krac1 compat-libstdc++-33-3.2.3-61 passed
Result: Package existence check passed for "compat-libstdc++-33-3.2.3".
Check: Package existence for "libgcc-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libgcc-4.1.2-48.el5 passed
krac1 libgcc-4.1.2-48.el5 passed
Result: Package existence check passed for "libgcc-4.1.1".
Check: Package existence for "libstdc++-devel-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libstdc++-devel-4.1.2-48.el5 passed
krac1 libstdc++-devel-4.1.2-48.el5 passed
Result: Package existence check passed for "libstdc++-devel-4.1.1".
Check: Package existence for "unixODBC-2.2.11"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 unixODBC-2.2.11-7.1 passed
krac1 unixODBC-2.2.11-7.1 passed
Result: Package existence check passed for "unixODBC-2.2.11".
Check: Package existence for "unixODBC-devel-2.2.11"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 unixODBC-devel-2.2.11-7.1 passed
krac1 unixODBC-devel-2.2.11-7.1 passed
Result: Package existence check passed for "unixODBC-devel-2.2.11".
Check: Package existence for "glibc-2.5-12"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 glibc-2.5-49 passed
krac1 glibc-2.5-49 passed
Result: Package existence check passed for "glibc-2.5-12".
Check: Kernel parameter for "semmsl"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 250 250 passed
krac1 250 250 passed
Result: Kernel parameter check passed for "semmsl".
Check: Kernel parameter for "semmns"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 32000 32000 passed
krac1 32000 32000 passed
Result: Kernel parameter check passed for "semmns".
Check: Kernel parameter for "semopm"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 100 100 passed
krac1 100 100 passed
Result: Kernel parameter check passed for "semopm".
Check: Kernel parameter for "semmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 128 128 passed
krac1 128 128 passed
Result: Kernel parameter check passed for "semmni".
Check: Kernel parameter for "shmmax"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 2147483648 536870912 passed
krac1 2147483648 536870912 passed
Result: Kernel parameter check passed for "shmmax".
Check: Kernel parameter for "shmall"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 2097152 2097152 passed
krac1 2097152 2097152 passed
Result: Kernel parameter check passed for "shmall".
Check: Kernel parameter for "shmmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 4096 4096 passed
krac1 4096 4096 passed
Result: Kernel parameter check passed for "shmmni".
Check: Kernel parameter for "file-max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 65536 65536 passed
krac1 65536 65536 passed
Result: Kernel parameter check passed for "file-max".
Check: Kernel parameter for "rmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 4194304 4194304 passed
krac1 4194304 4194304 passed
Result: Kernel parameter check passed for "rmem_default".
Check: Kernel parameter for "rmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 4194304 4194304 passed
krac1 4194304 4194304 passed
Result: Kernel parameter check passed for "rmem_max".
Check: Kernel parameter for "wmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 262144 262144 passed
krac1 262144 262144 passed
Result: Kernel parameter check passed for "wmem_default".
Check: Kernel parameter for "wmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 1048576 262144 passed
krac1 1048576 262144 passed
Result: Kernel parameter check passed for "wmem_max".
Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
krac2 exists passed
krac1 exists passed
Result: Group existence check passed for "dba".
Check: User existence for "nobody"
Node Name Status Comment
------------ ------------------------ ------------------------
krac2 exists passed
krac1 exists passed
Result: User existence check passed for "nobody".
System requirement passed for 'database'
Checking CRS integrity...
Checking daemon liveness...
Check: Liveness for "CRS daemon"
Node Name Running
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: Liveness check passed for "CRS daemon".
Checking daemon liveness...
Check: Liveness for "CSS daemon"
Node Name Running
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: Liveness check passed for "CSS daemon".
Checking daemon liveness...
Check: Liveness for "EVM daemon"
Node Name Running
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: Liveness check passed for "EVM daemon".
Liveness of all the daemons
Node Name CRS daemon CSS daemon EVM daemon
------------ ------------------------ ------------------------ ----------
krac2 yes yes yes
krac1 yes yes yes
Checking CRS health...
Check: Health of CRS
Node Name CRS OK?
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: CRS health check passed.
CRS integrity check passed.
Checking node application existence...
Checking existence of VIP node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
krac2 yes exists passed
krac1 yes exists passed
Result: Check passed.
Checking existence of ONS node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
krac2 no exists passed
krac1 no exists passed
Result: Check passed.
Checking existence of GSD node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
krac2 no exists passed
krac1 no exists passed
Result: Check passed.
Pre-check for database installation was successful.
[oracle@krac1 clusterware]$
Oracle ASM Home Software Install.
su - oracle
./runInstaller
[root@krac1 ~]# /u02/app/oracle/product/11.1.0/asm_1/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u02/app/oracle/product/11.1.0/asm_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
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.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@krac1 ~]# ssh krac2 /u02/app/oracle/product/11.1.0/asm_1/root.sh
root@krac2's password:
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u02/app/oracle/product/11.1.0/asm_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
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.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@krac1 ~]#
Oracle RAC Database Listener Creation
cd $ORA_ASM_HOME/bin/
./netca
Action : Select "Cluster Configuration" ration button and click "Next"
Oracle ASM Instance and diskgroup Creation
cd $ORA_ASM_HOME/bin/
./dbca
Action : Click Select All and click "Next"
Action : Enter the SYS Password and click "Next"
Action: Click "OK"
Action : None required.
Action: Click Create New
Action : None required.
Repeat the same steps for FRA Disk group creation.
Action: Click "Finish"
Oracle RAC Database Home Software Install
[oracle@krac1 clusterware]$ ./runcluvfy.sh stage -pre dbinst -n krac1,krac2 -verbose
Performing pre-checks for database installation
Checking node reachability...
Check: Node reachability from node "krac1"
Destination Node Reachable?
------------------------------------ ------------------------
krac1 yes
krac2 yes
Result: Node reachability check passed from node "krac1".
Checking user equivalence...
Check: User equivalence for user "oracle"
Node Name Comment
------------------------------------ ------------------------
krac2 passed
krac1 passed
Result: User equivalence check passed for user "oracle".
Checking administrative privileges...
Check: Existence of user "oracle"
Node Name User Exists Comment
------------ ------------------------ ------------------------
krac2 yes passed
krac1 yes passed
Result: User existence check passed for "oracle".
Check: Existence of group "oinstall"
Node Name Status Group ID
------------ ------------------------ ------------------------
krac2 exists 501
krac1 exists 501
Result: Group existence check passed for "oinstall".
Check: Membership of user "oracle" in group "oinstall" [as Primary]
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
krac2 yes yes yes yes passed
krac1 yes yes yes yes passed
Result: Membership check for user "oracle" in group "oinstall" [as Primary] passed.
Check: Existence of group "dba"
Node Name Status Group ID
------------ ------------------------ ------------------------
krac2 exists 502
krac1 exists 502
Result: Group existence check passed for "dba".
Check: Membership of user "oracle" in group "dba"
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
krac2 yes yes yes no passed
krac1 yes yes yes no passed
Result: Membership check for user "oracle" in group "dba" passed.
Administrative privileges check passed.
Checking node connectivity...
Interface information for node "krac2"
Interface Name IP Address Subnet Subnet Gateway Default Gateway Hardware Address
---------------- ------------ ------------ ------------ ------------ ------------
eth0 152.168.1.51 152.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:F7:59:F7
eth0 152.168.1.61 152.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:F7:59:F7
eth1 192.168.1.51 192.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:F7:59:01
Interface information for node "krac1"
Interface Name IP Address Subnet Subnet Gateway Default Gateway Hardware Address
---------------- ------------ ------------ ------------ ------------ ------------
eth0 152.168.1.50 152.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:71:EE:43
eth0 152.168.1.60 152.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:71:EE:43
eth1 192.168.1.50 192.168.1.0 0.0.0.0 192.168.1.1 00:0C:29:71:EE:4D
Check: Node connectivity of subnet "152.168.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
krac2:eth0 krac2:eth0 yes
krac2:eth0 krac1:eth0 yes
krac2:eth0 krac1:eth0 yes
krac2:eth0 krac1:eth0 yes
krac2:eth0 krac1:eth0 yes
krac1:eth0 krac1:eth0 yes
Result: Node connectivity check passed for subnet "152.168.1.0" with node(s) krac2,krac1.
Check: Node connectivity of subnet "192.168.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
krac2:eth1 krac1:eth1 yes
Result: Node connectivity check passed for subnet "192.168.1.0" with node(s) krac2,krac1.
Interfaces found on subnet "152.168.1.0" that are likely candidates for VIP:
krac2 eth0:152.168.1.51 eth0:152.168.1.61
krac1 eth0:152.168.1.50 eth0:152.168.1.60
Interfaces found on subnet "192.168.1.0" that are likely candidates for VIP:
krac2 eth1:192.168.1.51
krac1 eth1:192.168.1.50
WARNING:
Could not find a suitable set of interfaces for the private interconnect.
Result: Node connectivity check passed.
Checking system requirements for 'database'...
Check: Total memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 1.98GB (2075468KB) 1GB (1048576KB) passed
krac1 1.98GB (2075468KB) 1GB (1048576KB) passed
Result: Total memory check passed.
Check: Free disk space in "/tmp" dir
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 6.47GB (6787332KB) 400MB (409600KB) passed
krac1 6.51GB (6827884KB) 400MB (409600KB) passed
Result: Free disk space check passed.
Check: Swap space
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 3.42GB (3582484KB) 1.5GB (1572864KB) passed
krac1 3.42GB (3582484KB) 1.5GB (1572864KB) passed
Result: Swap space check passed.
Check: System architecture
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 i686 i686 passed
krac1 i686 i686 passed
Result: System architecture check passed.
Check: Kernel version
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
krac2 2.6.18-194.el5 2.6.18 passed
krac1 2.6.18-194.el5 2.6.18 passed
Result: Kernel version check passed.
Check: Package existence for "make-3.81"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 make-3.81-3.el5 passed
krac1 make-3.81-3.el5 passed
Result: Package existence check passed for "make-3.81".
Check: Package existence for "binutils-2.17.50.0.6"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 binutils-2.17.50.0.6-14.el5 passed
krac1 binutils-2.17.50.0.6-14.el5 passed
Result: Package existence check passed for "binutils-2.17.50.0.6".
Check: Package existence for "gcc-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 gcc-4.1.2-48.el5 passed
krac1 gcc-4.1.2-48.el5 passed
Result: Package existence check passed for "gcc-4.1.1".
Check: Package existence for "libaio-0.3.106"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libaio-0.3.106-5 passed
krac1 libaio-0.3.106-5 passed
Result: Package existence check passed for "libaio-0.3.106".
Check: Package existence for "libaio-devel-0.3.106"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libaio-devel-0.3.106-5 passed
krac1 libaio-devel-0.3.106-5 passed
Result: Package existence check passed for "libaio-devel-0.3.106".
Check: Package existence for "libstdc++-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libstdc++-4.1.2-48.el5 passed
krac1 libstdc++-4.1.2-48.el5 passed
Result: Package existence check passed for "libstdc++-4.1.1".
Check: Package existence for "elfutils-libelf-devel-0.125"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 elfutils-libelf-devel-0.137-3.el5 passed
krac1 elfutils-libelf-devel-0.137-3.el5 passed
Result: Package existence check passed for "elfutils-libelf-devel-0.125".
Check: Package existence for "sysstat-7.0.0"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 sysstat-7.0.2-3.el5 passed
krac1 sysstat-7.0.2-3.el5 passed
Result: Package existence check passed for "sysstat-7.0.0".
Check: Package existence for "compat-libstdc++-33-3.2.3"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 compat-libstdc++-33-3.2.3-61 passed
krac1 compat-libstdc++-33-3.2.3-61 passed
Result: Package existence check passed for "compat-libstdc++-33-3.2.3".
Check: Package existence for "libgcc-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libgcc-4.1.2-48.el5 passed
krac1 libgcc-4.1.2-48.el5 passed
Result: Package existence check passed for "libgcc-4.1.1".
Check: Package existence for "libstdc++-devel-4.1.1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 libstdc++-devel-4.1.2-48.el5 passed
krac1 libstdc++-devel-4.1.2-48.el5 passed
Result: Package existence check passed for "libstdc++-devel-4.1.1".
Check: Package existence for "unixODBC-2.2.11"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 unixODBC-2.2.11-7.1 passed
krac1 unixODBC-2.2.11-7.1 passed
Result: Package existence check passed for "unixODBC-2.2.11".
Check: Package existence for "unixODBC-devel-2.2.11"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 unixODBC-devel-2.2.11-7.1 passed
krac1 unixODBC-devel-2.2.11-7.1 passed
Result: Package existence check passed for "unixODBC-devel-2.2.11".
Check: Package existence for "glibc-2.5-12"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
krac2 glibc-2.5-49 passed
krac1 glibc-2.5-49 passed
Result: Package existence check passed for "glibc-2.5-12".
Check: Kernel parameter for "semmsl"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 250 250 passed
krac1 250 250 passed
Result: Kernel parameter check passed for "semmsl".
Check: Kernel parameter for "semmns"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 32000 32000 passed
krac1 32000 32000 passed
Result: Kernel parameter check passed for "semmns".
Check: Kernel parameter for "semopm"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 100 100 passed
krac1 100 100 passed
Result: Kernel parameter check passed for "semopm".
Check: Kernel parameter for "semmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 128 128 passed
krac1 128 128 passed
Result: Kernel parameter check passed for "semmni".
Check: Kernel parameter for "shmmax"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 2147483648 536870912 passed
krac1 2147483648 536870912 passed
Result: Kernel parameter check passed for "shmmax".
Check: Kernel parameter for "shmall"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 2097152 2097152 passed
krac1 2097152 2097152 passed
Result: Kernel parameter check passed for "shmall".
Check: Kernel parameter for "shmmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 4096 4096 passed
krac1 4096 4096 passed
Result: Kernel parameter check passed for "shmmni".
Check: Kernel parameter for "file-max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 65536 65536 passed
krac1 65536 65536 passed
Result: Kernel parameter check passed for "file-max".
Check: Kernel parameter for "rmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 4194304 4194304 passed
krac1 4194304 4194304 passed
Result: Kernel parameter check passed for "rmem_default".
Check: Kernel parameter for "rmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 4194304 4194304 passed
krac1 4194304 4194304 passed
Result: Kernel parameter check passed for "rmem_max".
Check: Kernel parameter for "wmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 262144 262144 passed
krac1 262144 262144 passed
Result: Kernel parameter check passed for "wmem_default".
Check: Kernel parameter for "wmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
krac2 1048576 262144 passed
krac1 1048576 262144 passed
Result: Kernel parameter check passed for "wmem_max".
Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
krac2 exists passed
krac1 exists passed
Result: Group existence check passed for "dba".
Check: User existence for "nobody"
Node Name Status Comment
------------ ------------------------ ------------------------
krac2 exists passed
krac1 exists passed
Result: User existence check passed for "nobody".
System requirement passed for 'database'
Checking CRS integrity...
Checking daemon liveness...
Check: Liveness for "CRS daemon"
Node Name Running
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: Liveness check passed for "CRS daemon".
Checking daemon liveness...
Check: Liveness for "CSS daemon"
Node Name Running
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: Liveness check passed for "CSS daemon".
Checking daemon liveness...
Check: Liveness for "EVM daemon"
Node Name Running
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: Liveness check passed for "EVM daemon".
Liveness of all the daemons
Node Name CRS daemon CSS daemon EVM daemon
------------ ------------------------ ------------------------ ----------
krac2 yes yes yes
krac1 yes yes yes
Checking CRS health...
Check: Health of CRS
Node Name CRS OK?
------------------------------------ ------------------------
krac2 yes
krac1 yes
Result: CRS health check passed.
CRS integrity check passed.
Checking node application existence...
Checking existence of VIP node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
krac2 yes exists passed
krac1 yes exists passed
Result: Check passed.
Checking existence of ONS node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
krac2 no exists passed
krac1 no exists passed
Result: Check passed.
Checking existence of GSD node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
krac2 no exists passed
krac1 no exists passed
Result: Check passed.
Pre-check for database installation was successful.
[oracle@krac1 clusterware]$
su - oracle
./runInstaller
Action: Select Enterprise Edition ration button and click "Next"
Action : Ensure Oracle Base, Name, Path and click "Next"
Action : Click "Install".
Action : Run root.sh script as a root and click "OK"
Action : Click "Exit"
Use dbca to create the RAC database
su - oracle
cd $ORACLE_HOME/bin
./dbca
Action : Select Create a Database ration button and click "Next".
Action: Select All and click "Next"
Action : Enter Administrative Password and click "Next"
Action : Ensure Disk group name for Database files and click "Next"
Once the database creation is complete you are presented with the following screen.
Action : "Exit"
[oracle@krac1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....L1.inst application 0/5 0/0 ONLINE ONLINE krac1
ora....L2.inst application 0/5 0/0 ONLINE ONLINE krac2
ora.ORCL.db application 0/0 0/1 ONLINE ONLINE krac1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE krac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE krac1
ora.krac1.gsd application 0/5 0/0 ONLINE ONLINE krac1
ora.krac1.ons application 0/3 0/0 ONLINE ONLINE krac1
ora.krac1.vip application 0/0 0/0 ONLINE ONLINE krac1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE krac2
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE krac2
ora.krac2.gsd application 0/5 0/0 ONLINE ONLINE krac2
ora.krac2.ons application 0/3 0/0 ONLINE ONLINE krac2
ora.krac2.vip application 0/0 0/0 ONLINE ONLINE krac2
[oracle@krac1 ~]$ sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Sep 26 00:43:35 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: sys@orcl1 as sysdba
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> col instance_name format a15
SQL> col host_name format a25
SQL> select instance_name,host_name from gv$instance;
INSTANCE_NAME HOST_NAME
--------------- -------------------------
ORCL1 krac1.dbprod.com
ORCL2 krac2.dbprod.com
SQL> select instance_name,host_name from v$instance;
INSTANCE_NAME HOST_NAME
--------------- -------------------------
ORCL1 krac1.dbprod.com
SQL> connect sys@orcl2 as sysdba
Enter password:
Connected.
SQL> select instance_name,host_name from gv$instance;
INSTANCE_NAME HOST_NAME
--------------- -------------------------
ORCL2 krac2.dbprod.com
ORCL1 krac1.dbprod.com
SQL> select instance_name,host_name from v$instance;
INSTANCE_NAME HOST_NAME
--------------- -------------------------
ORCL2 krac2.dbprod.com
SQL> connect sys@orcl as sysdba
Enter password:
Connected.
SQL> select instance_name,host_name from v$instance;
INSTANCE_NAME HOST_NAME
--------------- -------------------------
ORCL1 krac1.dbprod.com
SQL> connect sys@orcl as sysdba
Enter password:
Connected.
SQL> select instance_name,host_name from v$instance;
INSTANCE_NAME HOST_NAME
--------------- -------------------------
ORCL2 krac2.dbprod.com
SQL>
Sample LISTENER.ORA and TNSNAMES.ORA file.
krac1
# listener.ora.krac1 Network Configuration File: /u02/app/oracle/product/11.1.0/db_1/network/admin/listener.ora.krac1
# Generated by Oracle configuration tools.
LISTENER_KRAC1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = krac1-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.168.1.50)(PORT = 1521)(IP = FIRST))
)
)
krac2
# listener.ora.krac2 Network Configuration File: /u02/app/oracle/product/11.1.0/db_1/network/admin/listener.ora.krac2
# Generated by Oracle configuration tools.
LISTENER_KRAC2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = krac2-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.168.1.51)(PORT = 1521)(IP = FIRST))
)
)
TNSNAMES.ORA.
# tnsnames.ora Network Configuration File: /u02/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENERS_ORCL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = krac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = krac2-vip)(PORT = 1521))
)
ORCL2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = krac2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL.DBPROD.COM)
(INSTANCE_NAME = ORCL2)
)
)
ORCL1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = krac1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL.DBPROD.COM)
(INSTANCE_NAME = ORCL1)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = krac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = krac2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL.DBPROD.COM)
)
)
---------------------------------------------------------------------------------------------------------------------------
Instagram Takipçi Satın Al
ReplyDeleteToptan Telefon Kılıfı
Resimli Magnet
Silivri Çatı Ustası
Çerkezköy Çatı Ustası
Z26RRZ