RAC: add new node to cluster


15.04.2015
by Kamil Stawiarski

  • Add a new node to RAC

Check the network configuration for both nodes

On the with active cluster, check the network configuration

[root@lodzio ~]# oifcfg getif
eth0  192.168.56.0  global  public
eth1  10.0.0.0  global  cluster_interconnect

Configure appropriate network devices on the node, which I want to add

[root@miodzio ~]# vim /etc/sysconfig/network-scripts/ifcfg-eth1 
[root@miodzio ~]# cat !$
cat /etc/sysconfig/network-scripts/ifcfg-eth1
DEVICE=eth1
TYPE=Ethernet
ONBOOT=yes
NM_CONTROLLED=no
BOOTPROTO=none
HWADDR=08:00:27:42:F0:03
IPADDR=10.0.0.2
PREFIX=24
DEFROUTE=no
IPV4_FAILURE_FATAL=yes
IPV6INIT=no
NAME="System eth1"
[root@miodzio ~]# ifup eth1
[root@miodzio ~]# ifconfig 
eth0      Link encap:Ethernet  HWaddr 08:00:27:E5:9A:8C  
          inet addr:192.168.56.122  Bcast:192.168.56.255  Mask:255.255.255.0
          inet6 addr: fe80::a00:27ff:fee5:9a8c/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:296 errors:0 dropped:0 overruns:0 frame:0
          TX packets:196 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:29589 (28.8 KiB)  TX bytes:30922 (30.1 KiB)

eth1      Link encap:Ethernet  HWaddr 08:00:27:42:F0:03  
          inet addr:10.0.0.2  Bcast:10.0.0.255  Mask:255.255.255.0
          inet6 addr: fe80::a00:27ff:fe42:f003/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:38 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:0 (0.0 b)  TX bytes:8300 (8.1 KiB)

Create appropriate user on the new node:

[root@miodzio ~]# id oracle
uid=54321(oracle) gid=54321(oinstall) grupy=54321(oinstall),54322(dba)

Configure shared storage – first install ASMLib drivers (if you are using ASMLib :))

[root@miodzio ~]# yum install oracleasm-support.x86_64
Loaded plugins: refresh-packagekit, security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package oracleasm-support.x86_64 0:2.1.8-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================
 Package                   Arch           Version                Repository          Size
==========================================================================================
Installing:
 oracleasm-support         x86_64         2.1.8-1.el6            ol6_latest          73 k

Transaction Summary
==========================================================================================
Install       1 Package(s)

Total download size: 73 k
Installed size: 216 k
Is this ok [y/N]: y
Downloading Packages:
oracleasm-support-2.1.8-1.el6.x86_64.rpm                           |  73 kB     00:00     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : oracleasm-support-2.1.8-1.el6.x86_64                                   1/1 
  Verifying  : oracleasm-support-2.1.8-1.el6.x86_64                                   1/1 

Installed:
  oracleasm-support.x86_64 0:2.1.8-1.el6                                                  

Complete!

[root@miodzio ~]# rpm -Uvh oracleasmlib-2.0.4-1.el6.x86_64.rpm 
Przygotowywanie...          ########################################### [100%]
   1:oracleasmlib           ########################################### [100%]

You can download oracleasmlib-2.0.4-1.el6.x86_64.rpm from here: http://www.oracle.com/technetwork/server-storage/linux/asmlib/ol6-1709075.html

Ensure that SELinux won’t be a problem:

[root@miodzio ~]# setenforce 0
[root@miodzio ~]# vim /etc/sysconfig/selinux 
[root@miodzio ~]# cat !$
cat /etc/sysconfig/selinux

# 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=permissive
# SELINUXTYPE= can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted 

Now we can perfom a library configuration (be sure to set the same ownership as in other RAC nodes)

[root@miodzio ~]# /etc/init.d/oracleasm configure 
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: oinstall
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: 
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]

Check the existance of appropriate devices:

[root@miodzio ~]# ls -al /dev/oracleasm/disks/
razem 0
drwxr-xr-x. 1 root   root         0 04-15 12:42 .
drwxr-xr-x. 4 root   root         0 04-15 12:42 ..
brw-rw----. 1 oracle oinstall 8, 17 04-15 12:49 ASMGRID

Now we can create install directories and start installation procedure

[root@miodzio ~]# mkdir /u01
[root@miodzio ~]# chown oracle:oinstall /u01

Set the same DNS configuration files as in other RAC nodes. Of course you have to update the DNS configuration for thew node names.

[root@miodzio ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0 | grep DNS
DNS1=192.168.56.121
DNS2=8.8.8.8
[root@miodzio ~]# cat /etc/resolv.conf
# Generated by NetworkManager


# No nameservers found; try putting DNS servers into your
# ifcfg files in /etc/sysconfig/network-scripts like so:
#
# DNS1=xxx.xxx.xxx.xxx
# DNS2=xxx.xxx.xxx.xxx
# DOMAIN=lab.foo.com bar.foo.com
nameserver 192.168.56.121
nameserver 8.8.8.8
search racdomain 

[root@miodzio ~]# nslookup scan
Server:		192.168.56.121
Address:	192.168.56.121#53

Name:	scan.racdomain
Address: 192.168.56.143
Name:	scan.racdomain
Address: 192.168.56.141
Name:	scan.racdomain
Address: 192.168.56.142

[root@miodzio ~]# nslookup lodzio
Server:		192.168.56.121
Address:	192.168.56.121#53

Name:	lodzio.racdomain
Address: 192.168.56.121

[root@miodzio ~]# nslookup lodzio-vip
Server:		192.168.56.121
Address:	192.168.56.121#53

Name:	lodzio-vip.racdomain
Address: 192.168.56.131

[root@miodzio ~]# nslookup miodzio
Server:		192.168.56.121
Address:	192.168.56.121#53

Name:	miodzio.racdomain
Address: 192.168.56.122

[root@miodzio ~]# nslookup miodzio-vip
Server:		192.168.56.121
Address:	192.168.56.121#53

Name:	miodzio-vip.racdomain
Address: 192.168.56.132

[root@miodzio ~]# nslookup 192.168.56.122
Server:		192.168.56.121
Address:	192.168.56.121#53

122.56.168.192.in-addr.arpa	name = miodzio.

[root@miodzio ~]# nslookup 192.168.56.121
Server:		192.168.56.121
Address:	192.168.56.121#53

121.56.168.192.in-addr.arpa	name = lodzio.

[root@miodzio ~]# nslookup 192.168.56.131
Server:		192.168.56.121
Address:	192.168.56.121#53

131.56.168.192.in-addr.arpa	name = lodzio-vip.

[root@miodzio ~]# nslookup 192.168.56.132
Server:		192.168.56.121
Address:	192.168.56.121#53

132.56.168.192.in-addr.arpa	name = miodzio-vip.

[root@miodzio ~]# nslookup 192.168.56.141
Server:		192.168.56.121
Address:	192.168.56.121#53

141.56.168.192.in-addr.arpa	name = scan.

[root@miodzio ~]# nslookup 192.168.56.142
Server:		192.168.56.121
Address:	192.168.56.121#53

142.56.168.192.in-addr.arpa	name = scan.

[root@miodzio ~]# nslookup 192.168.56.142
Server:		192.168.56.121
Address:	192.168.56.121#53

142.56.168.192.in-addr.arpa	name = scan.

[root@miodzio ~]# nslookup 192.168.56.143
Server:		192.168.56.121
Address:	192.168.56.121#53

143.56.168.192.in-addr.arpa	name = scan.

Now you have to configure SSH passwordless connectivity between nodes

Generate RSA public and private keys on the new node

[root@miodzio ~]# passwd oracle
Zmienianie hasła użytkownika oracle.
Nowe hasło : 
BŁĘDNE HASŁO: oparte na słowie ze słownika
BŁĘDNE HASŁO: jest za proste
Proszę ponownie podać nowe hasło : 
passwd: zaktualizowanie wszystkich tokenów uwierzytelniania powiodło się.
[root@miodzio ~]# su - oracle
[oracle@miodzio ~]$ ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/oracle/.ssh/id_rsa): 
Created directory '/home/oracle/.ssh'.
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:
a7:7f:a2:79:f9:8f:1a:c0:dc:f4:99:f2:b4:ed:0d:ae oracle@miodzio
The key's randomart image is:
+--[ RSA 2048]----+
|                 |
|                 |
|          .      |
|       o o . o   |
|        S + =    |
|         + + o   |
|        . ..o o  |
|         o+..+ o |
|        ooo=Eo+ .|
+-----------------+

Exchange keys between servers

[oracle@miodzio ~]$ ssh lodzio
The authenticity of host 'lodzio (192.168.56.121)' can't be established.
RSA key fingerprint is 04:3e:60:a1:26:17:6c:5e:80:43:55:6c:ae:08:f4:98.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'lodzio,192.168.56.121' (RSA) to the list of known hosts.
oracle@lodzio's password: 
Last login: Mon Apr 13 17:15:46 2015 from 192.168.56.1

[oracle@lodzio ~]$ cd .ssh/
[oracle@lodzio .ssh]$ ssh miodzio "cat $PWD/*.pub" >> authorized_keys
The authenticity of host 'miodzio (192.168.56.122)' can't be established.
RSA key fingerprint is 04:3e:60:a1:26:17:6c:5e:80:43:55:6c:ae:08:f4:98.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'miodzio,192.168.56.122' (RSA) to the list of known hosts.
oracle@miodzio's password: 
[oracle@lodzio .ssh]$ scp authorized_keys miodzio:$PWD/
oracle@miodzio's password: 
authorized_keys                                         100% 1097     1.1KB/s   00:00    
[oracle@lodzio .ssh]$ ssh miodzio date
Wed Apr 15 13:13:02 CEST 2015
[oracle@lodzio .ssh]$ ssh miodzio
[oracle@miodzio ~]$ ssh lodzio date
Wed Apr 15 13:13:09 CEST 2015
[oracle@miodzio ~]$ ssh miodzio date
The authenticity of host 'miodzio (192.168.56.122)' can't be established.
RSA key fingerprint is 04:3e:60:a1:26:17:6c:5e:80:43:55:6c:ae:08:f4:98.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'miodzio,192.168.56.122' (RSA) to the list of known hosts.
Wed Apr 15 13:13:15 CEST 2015

You can check if you new node is configured properly

[oracle@lodzio ~]$ . oraenv 
ORACLE_SID = [+ASM1] ? +ASM1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@lodzio ~]$ cd /u01/app/11.2.0/grid/cv/cvutl/
[oracle@lodzio cvutl]$ perl check_nodeadd.pl -pre "CLUSTER_NEW_NODES={miodzio}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES=miodzio-vip}"

Performing pre-checks for node addition 

Checking node reachability...
Node reachability check passed from node "lodzio"


Checking user equivalence...
User equivalence check passed for user "oracle"

Checking node connectivity...

Checking hosts config file...

Verification of the hosts config file successful

Check: Node connectivity for interface "eth0"
Node connectivity passed for interface "eth0"
TCP connectivity check passed for subnet "192.168.56.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.56.0".
Subnet mask consistency check passed.

Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.56.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.56.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.

Checking CRS integrity...

Clusterware version consistency passed

CRS integrity check passed

Checking shared resources...

Checking CRS home location...
"/u01/app/11.2.0/grid" is shared
Shared resources check for node addition passed


Checking node connectivity...

Checking hosts config file...

Verification of the hosts config file successful

Check: Node connectivity for interface "eth0"
Node connectivity passed for interface "eth0"
TCP connectivity check passed for subnet "192.168.56.0"


Check: Node connectivity for interface "eth1"
Node connectivity passed for interface "eth1"
TCP connectivity check passed for subnet "10.0.0.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.56.0".
Subnet mask consistency check passed for subnet "10.0.0.0".
Subnet mask consistency check passed.

Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.56.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.56.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "10.0.0.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "10.0.0.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.
Total memory check passed
Available memory check passed
Swap space check passed
Free disk space check passed for "lodzio:/u01/app/11.2.0/grid,lodzio:/tmp"
Free disk space check passed for "miodzio:/u01/app/11.2.0/grid,miodzio:/tmp"
Check for multiple users with UID value 54321 passed 
User existence check passed for "oracle"
Run level check passed
Hard limits check passed for "maximum open file descriptors"
Soft limits check passed for "maximum open file descriptors"
Hard limits check passed for "maximum user processes"
Soft limits check passed for "maximum user processes"
System architecture check passed
Kernel version check passed
Kernel parameter check passed for "semmsl"
Kernel parameter check passed for "semmns"
Kernel parameter check passed for "semopm"
Kernel parameter check passed for "semmni"
Kernel parameter check passed for "shmmax"
Kernel parameter check passed for "shmmni"
Kernel parameter check passed for "shmall"
Kernel parameter check passed for "file-max"
Kernel parameter check passed for "ip_local_port_range"
Kernel parameter check passed for "rmem_default"
Kernel parameter check passed for "rmem_max"
Kernel parameter check passed for "wmem_default"
Kernel parameter check passed for "wmem_max"
Kernel parameter check passed for "aio-max-nr"
Package existence check passed for "binutils"
Package existence check passed for "compat-libcap1"
Package existence check passed for "compat-libstdc++-33(x86_64)"
Package existence check passed for "libgcc(x86_64)"
Package existence check passed for "libstdc++(x86_64)"
Package existence check passed for "libstdc++-devel(x86_64)"
Package existence check passed for "sysstat"
Package existence check passed for "gcc"
Package existence check passed for "gcc-c++"
Package existence check passed for "ksh"
Package existence check passed for "make"
Package existence check passed for "glibc(x86_64)"
Package existence check passed for "glibc-devel(x86_64)"
Package existence check passed for "libaio(x86_64)"
Package existence check passed for "libaio-devel(x86_64)"
Check for multiple users with UID value 0 passed 
Current group ID check passed

Starting check for consistency of primary group of root user

Check for consistency of root user's primary group passed

Checking OCR integrity...

OCR integrity check passed

Checking Oracle Cluster Voting Disk configuration...

Oracle Cluster Voting Disk configuration check passed
Time zone consistency check passed

Starting Clock synchronization checks using Network Time Protocol(NTP)...

NTP Configuration file check started...
NTP Configuration file check passed

Checking daemon liveness...
Liveness check passed for "ntpd"
Check for NTP daemon or service alive passed on all nodes

NTP daemon slewing option check failed on some nodes
Check failed on nodes: 
	miodzio
PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "-x"
Clock synchronization check using Network Time Protocol(NTP) failed


User "oracle" is not part of "root" group. Check passed
Checking consistency of file "/etc/resolv.conf" across nodes

File "/etc/resolv.conf" does not have both domain and search entries defined
domain entry in file "/etc/resolv.conf" is consistent across nodes
search entry in file "/etc/resolv.conf" is consistent across nodes
All nodes have one search entry defined in file "/etc/resolv.conf"
PRVF-5637 : DNS response time could not be checked on following nodes: lodzio,miodzio

File "/etc/resolv.conf" is not consistent across nodes


Pre-check for node addition was unsuccessful on all the nodes. 

You can correct the important errors and on the first node I will use the addNode.sh script from GRID_HOME

[oracle@lodzio ~]$ env | grep ORA
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/11.2.0/grid
[oracle@lodzio ~]$ cd /u01/app/11.2.0/grid/oui/bin/
[oracle@lodzio bin]$ export IGNORE_PREADDNODE_CHECKS=Y
[oracle@lodzio bin]$ ./addNode.sh CLUSTER_NEW_NODES={miodzio} CLUSTER_NEW_VIRTUAL_HOSTNAMES={miodzio-vip}
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 7999 MB    Passed
Oracle Universal Installer, Version 11.2.0.3.0 Production
Copyright (C) 1999, 2011, Oracle. All rights reserved.


Performing tests to see whether nodes miodzio are available
............................................................... 100% Done.

.
-----------------------------------------------------------------------------
Cluster Node Addition Summary
Global Settings
   Source: /u01/app/11.2.0/grid
   New Nodes
Space Requirements
   New Nodes
      miodzio
         /: Required 3.70GB : Available 35.15GB
Installed Products
   Product Names
      Oracle Grid Infrastructure 11.2.0.3.0 
      Sun JDK 1.5.0.30.03 
      Installer SDK Component 11.2.0.3.0 
      Oracle One-Off Patch Installer 11.2.0.1.7 
      Oracle Universal Installer 11.2.0.3.0 
      Oracle USM Deconfiguration 11.2.0.3.0 
      Oracle Configuration Manager Deconfiguration 10.3.1.0.0 
      Enterprise Manager Common Core Files 10.2.0.4.4 
      Oracle DBCA Deconfiguration 11.2.0.3.0 
      Oracle RAC Deconfiguration 11.2.0.3.0 
      Oracle Quality of Service Management (Server) 11.2.0.3.0 
      Installation Plugin Files 11.2.0.3.0 
      Universal Storage Manager Files 11.2.0.3.0 
      Oracle Text Required Support Files 11.2.0.3.0 
      Automatic Storage Management Assistant 11.2.0.3.0 
      Oracle Database 11g Multimedia Files 11.2.0.3.0 
      Oracle Multimedia Java Advanced Imaging 11.2.0.3.0 
      Oracle Globalization Support 11.2.0.3.0 
      Oracle Multimedia Locator RDBMS Files 11.2.0.3.0 
      Oracle Core Required Support Files 11.2.0.3.0 
      Bali Share 1.1.18.0.0 
      Oracle Database Deconfiguration 11.2.0.3.0 
      Oracle Quality of Service Management (Client) 11.2.0.3.0 
      Expat libraries 2.0.1.0.1 
      Oracle Containers for Java 11.2.0.3.0 
      Perl Modules 5.10.0.0.1 
      Secure Socket Layer 11.2.0.3.0 
      Oracle JDBC/OCI Instant Client 11.2.0.3.0 
      Oracle Multimedia Client Option 11.2.0.3.0 
      LDAP Required Support Files 11.2.0.3.0 
      Character Set Migration Utility 11.2.0.3.0 
      Perl Interpreter 5.10.0.0.2 
      PL/SQL Embedded Gateway 11.2.0.3.0 
      OLAP SQL Scripts 11.2.0.3.0 
      Database SQL Scripts 11.2.0.3.0 
      Oracle Extended Windowing Toolkit 3.4.47.0.0 
      SSL Required Support Files for InstantClient 11.2.0.3.0 
      SQL*Plus Files for Instant Client 11.2.0.3.0 
      Oracle Net Required Support Files 11.2.0.3.0 
      Oracle Database User Interface 2.2.13.0.0 
      RDBMS Required Support Files for Instant Client 11.2.0.3.0 
      RDBMS Required Support Files Runtime 11.2.0.3.0 
      XML Parser for Java 11.2.0.3.0 
      Oracle Security Developer Tools 11.2.0.3.0 
      Oracle Wallet Manager 11.2.0.3.0 
      Enterprise Manager plugin Common Files 11.2.0.3.0 
      Platform Required Support Files 11.2.0.3.0 
      Oracle JFC Extended Windowing Toolkit 4.2.36.0.0 
      RDBMS Required Support Files 11.2.0.3.0 
      Oracle Ice Browser 5.2.3.6.0 
      Oracle Help For Java 4.2.9.0.0 
      Enterprise Manager Common Files 10.2.0.4.3 
      Deinstallation Tool 11.2.0.3.0 
      Oracle Java Client 11.2.0.3.0 
      Cluster Verification Utility Files 11.2.0.3.0 
      Oracle Notification Service (eONS) 11.2.0.3.0 
      Oracle LDAP administration 11.2.0.3.0 
      Cluster Verification Utility Common Files 11.2.0.3.0 
      Oracle Clusterware RDBMS Files 11.2.0.3.0 
      Oracle Locale Builder 11.2.0.3.0 
      Oracle Globalization Support 11.2.0.3.0 
      Buildtools Common Files 11.2.0.3.0 
      Oracle RAC Required Support Files-HAS 11.2.0.3.0 
      SQL*Plus Required Support Files 11.2.0.3.0 
      XDK Required Support Files 11.2.0.3.0 
      Agent Required Support Files 10.2.0.4.3 
      Parser Generator Required Support Files 11.2.0.3.0 
      Precompiler Required Support Files 11.2.0.3.0 
      Installation Common Files 11.2.0.3.0 
      Required Support Files 11.2.0.3.0 
      Oracle JDBC/THIN Interfaces 11.2.0.3.0 
      Oracle Multimedia Locator 11.2.0.3.0 
      Oracle Multimedia 11.2.0.3.0 
      HAS Common Files 11.2.0.3.0 
      Assistant Common Files 11.2.0.3.0 
      PL/SQL 11.2.0.3.0 
      HAS Files for DB 11.2.0.3.0 
      Oracle Recovery Manager 11.2.0.3.0 
      Oracle Database Utilities 11.2.0.3.0 
      Oracle Notification Service 11.2.0.3.0 
      SQL*Plus 11.2.0.3.0 
      Oracle Netca Client 11.2.0.3.0 
      Oracle Net 11.2.0.3.0 
      Oracle JVM 11.2.0.3.0 
      Oracle Internet Directory Client 11.2.0.3.0 
      Oracle Net Listener 11.2.0.3.0 
      Cluster Ready Services Files 11.2.0.3.0 
      Oracle Database 11g 11.2.0.3.0 
-----------------------------------------------------------------------------


Instantiating scripts for add node (Wednesday, April 15, 2015 1:36:02 PM CEST)
.                                                                 1% Done.
Instantiation of add node scripts complete

Copying to remote nodes (Wednesday, April 15, 2015 1:36:06 PM CEST)
...............................................................................................                                 96% Done.
Home copied to new nodes

Saving inventory on nodes (Wednesday, April 15, 2015 1:38:16 PM CEST)
.                                                               100% Done.
Save inventory complete
WARNING:A new inventory has been created on one or more nodes in this session. However, it has not yet been registered as the central inventory of this system. 
To register the new inventory please run the script at '/u01/app/oraInventory/orainstRoot.sh' with root privileges on nodes 'miodzio'.
If you do not register the inventory, you may not be able to update or patch the products you installed.
The following configuration scripts need to be executed as the "root" user in each new cluster node. Each script in the list below is followed by a list of nodes.
/u01/app/oraInventory/orainstRoot.sh #On nodes miodzio
/u01/app/11.2.0/grid/root.sh #On nodes miodzio
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts in each cluster node
    
The Cluster Node Addition of /u01/app/11.2.0/grid was successful.
Please check '/tmp/silentInstall.log' for more details.

Now we can follow the instruction to run scripts as root:

[oracle@lodzio gpnpd]$ ssh miodzio
Last login: Wed Apr 15 13:24:54 2015 from lodzio
[oracle@miodzio ~]$ su -
Password: 
[root@miodzio ~]# /u01/app/oraInventory/orainstRoot.sh 
Creating the Oracle inventory pointer file (/etc/oraInst.loc)
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@miodzio ~]# /u01/app/11.2.0/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/grid

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 script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/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 lodzio, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Preparing packages for installation...
cvuqdisk-1.0.9-1
Configure Oracle Grid Infrastructure for a Cluster ... succeeded

Now you can proceed to extend home binaries for database.

[oracle@lodzio bin]$ env | grep ORA
ORACLE_SID=orcl
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@lodzio ~]$ cd $ORACLE_HOME/oui/bin
[oracle@lodzio bin]$ export IGNORE_PREADDNODE_CHECKS=Y
[oracle@lodzio bin]$ ./addNode.sh CLUSTER_NEW_NODES={miodzio} CLUSTER_NEW_VIRTUAL_HOSTNAMES={miodzio-vip}

Contact us

Database Whisperers sp. z o. o. sp. k.
al. Jerozolimskie 200, 3rd floor, room 342
02-486 Warszawa
NIP: 5272744987
REGON:362524978
+48 508 943 051
+48 661 966 009
info@ora-600.pl

Newsletter Sign up to be updated