Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NOT able to create a RAC DB

JhilDec 14 2017

Hi,

I could NOT able to create a RAC database because of VIP issue.

dbca.png

>> De configured CRS on NODE1

# /u01/product/11.2.0/grid/crs/install/rootcrs.pl -verbose -deconfig -force

2017-12-15 03:39:18: Parsing the host name

2017-12-15 03:39:18: Checking for super user privileges

2017-12-15 03:39:18: User has super user privileges

Using configuration parameter file: /u01/product/11.2.0/grid/crs/install/crsconfig_params

VIP exists.:rac2

VIP exists.: /rac2-vip/192.168.212.71/255.255.255.0/eth0

GSD exists.

ONS daemon exists. Local port 6100, remote port 6200

eONS daemon exists. Multicast port 22846, multicast IP address 234.134.52.116, listening port 2016

PRKO-2439 : VIP does not exist.

PRKO-2313 : VIP rac1 does not exist. <===================== ERROR

ACFS-9200: Supported

CRS-2613: Could not find resource 'ora.registry.acfs'.

CRS-4000: Command Stop failed, or completed with errors.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'

CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'

CRS-2673: Attempting to stop 'ora.CRS.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.RECO.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.rac1-vip.vip' on 'rac1'

CRS-2677: Stop of 'ora.rac1-vip.vip' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.rac1-vip.vip' on 'rac2'

CRS-2677: Stop of 'ora.RECO.dg' on 'rac1' succeeded

CRS-2676: Start of 'ora.rac1-vip.vip' on 'rac2' succeeded

CRS-2677: Stop of 'ora.CRS.dg' on 'rac1' succeeded

CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'rac1'

CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.net2.network' on 'rac1'

CRS-2677: Stop of 'ora.net2.network' on 'rac1' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed

CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'

CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'

CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'

CRS-2673: Attempting to stop 'ora.asm' on 'rac1'

CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'

CRS-2677: Stop of 'ora.cssdmonitor' on 'rac1' succeeded

CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded

CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'

CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'

CRS-2673: Attempting to stop 'ora.diskmon' on 'rac1'

CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'

CRS-2677: Stop of 'ora.diskmon' on 'rac1' succeeded

CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

Successfully deconfigured Oracle clusterware stack on this node

>> Executed root.sh on NODE1

[root@RAC1 ~]# /u01/product/11.2.0/grid/root.sh

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE\_OWNER= grid

ORACLE\_HOME=  /u01/product/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]: y

Copying dbhome to /usr/local/bin ...

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]: y

Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]: y

Copying coraenv to /usr/local/bin ...

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.

2017-12-15 03:40:55: Parsing the host name

2017-12-15 03:40:55: Checking for super user privileges

2017-12-15 03:40:55: User has super user privileges

Using configuration parameter file: /u01/product/11.2.0/grid/crs/install/crsconfig_params

LOCAL ADD MODE

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

Adding daemon to inittab

CRS-4123: Oracle High Availability Services has been started.

ohasd is starting

CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node rac2, number 2, and is terminating

An active cluster was found during exclusive startup, restarting to join the cluster

CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'

CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'

CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'

CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'

CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'rac1'

CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'

CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded

CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'

CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac1'

CRS-2676: Start of 'ora.drivers.acfs' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'rac1'

CRS-2676: Start of 'ora.asm' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'rac1'

CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.evmd' on 'rac1'

CRS-2676: Start of 'ora.evmd' on 'rac1' succeeded

PRCN-2050 : The requested VIP (nodename: rac1, VIP name: rac1-vip, network number: 1) has the same VIP name but different network number or preferred node than the registered VIP (nodename: rac1, VIP name: 192.168.212.70, network number: 2).

add vip -n rac1 -k 1 -A rac1-vip/255.255.255.0/eth0 on node=rac1 ... failed <============================ Error

Preparing packages for installation...

cvuqdisk-1.0.7-1

Configure Oracle Grid Infrastructure for a Cluster ... failed

Updating inventory properties for clusterware

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB. Actual 6000 MB Passed

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /u01/app/oraInventory

'UpdateNodeList' was successful.

>>

[root@RAC1 ~]# srvctl add vip -n rac1 -A 192.168.212.70/255.255.255.0 -k 2

>>

# srvctl status vip -i rac1-vip

VIP 192.168.212.70 is enabled

VIP 192.168.212.70 is not running

>>

[root@RAC1 ~]# srvctl start nodeapps -n rac1

PRKO-2421 : Network resource is already started on node(s): rac1

PRKO-2439 : VIP does not exist.

PRKO-2422 : ONS is already started on node(s): rac1

PRKO-2423 : eONS is already started on node(s): rac1

>>

# srvctl status vip -i rac1-vip

VIP 192.168.212.70 is enabled

VIP 192.168.212.70 is not running

>>

[root@RAC1 ~]# srvctl start vip -i rac1-vip -v

Successfully started VIP.

>>

# srvctl status vip -i rac1-vip

VIP 192.168.212.70 is enabled

VIP 192.168.212.70 is running on node: rac1

>>

[root@RAC1 ~]# ping rac1-vip

PING rac1-vip (192.168.212.70) 56(84) bytes of data.

64 bytes from rac1-vip (192.168.212.70): icmp_seq=1 ttl=64 time=0.018 ms

64 bytes from rac1-vip (192.168.212.70): icmp_seq=2 ttl=64 time=0.023 ms

64 bytes from rac1-vip (192.168.212.70): icmp_seq=3 ttl=64 time=0.021 ms

--- rac1-vip ping statistics ---

3 packets transmitted, 3 received, 0% packet loss, time 2000ms

rtt min/avg/max/mdev = 0.018/0.020/0.023/0.005 ms

>>

[root@RAC1 ~]# ping rac2-vip

PING rac2-vip (192.168.212.71) 56(84) bytes of data.

64 bytes from rac2-vip (192.168.212.71): icmp_seq=1 ttl=64 time=1.84 ms

64 bytes from rac2-vip (192.168.212.71): icmp_seq=2 ttl=64 time=0.153 ms

64 bytes from rac2-vip (192.168.212.71): icmp_seq=3 ttl=64 time=0.162 ms

--- rac2-vip ping statistics ---

3 packets transmitted, 3 received, 0% packet loss, time 1999ms

rtt min/avg/max/mdev = 0.153/0.720/1.845/0.795 ms

>>

# cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

#::1 localhost6.localdomain6 localhost6i

# Public IP

192.168.212.40 rac1 rac1.example.com

192.168.212.41 rac2 rac2.example.com

# Private IP

10.0.0.1 rac1-priv

10.0.0.2 rac2-priv

# Virtual IP

192.168.212.70 rac1-vip

192.168.212.71 rac2-vip

# Scan IP

192.168.212.90 rac-scan

>> On Node2

# ping rac1-vip

PING rac1-vip (192.168.212.70) 56(84) bytes of data.

64 bytes from rac1-vip (192.168.212.70): icmp_seq=1 ttl=64 time=1.53 ms

64 bytes from rac1-vip (192.168.212.70): icmp_seq=2 ttl=64 time=0.442 ms

--- rac1-vip ping statistics ---

2 packets transmitted, 2 received, 0% packet loss, time 1000ms

rtt min/avg/max/mdev = 0.442/0.987/1.532/0.545 ms

>>

[root@RAC2 ~]# ping rac2-vip

PING rac2-vip (192.168.212.71) 56(84) bytes of data.

64 bytes from rac2-vip (192.168.212.71): icmp_seq=1 ttl=64 time=0.018 ms

64 bytes from rac2-vip (192.168.212.71): icmp_seq=2 ttl=64 time=0.038 ms

64 bytes from rac2-vip (192.168.212.71): icmp_seq=3 ttl=64 time=0.035 ms

--- rac2-vip ping statistics ---

3 packets transmitted, 3 received, 0% packet loss, time 2000ms

rtt min/avg/max/mdev = 0.018/0.030/0.038/0.009 ms

>>

# cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

#::1 localhost6.localdomain6 localhost6i

# Public IP

192.168.212.40 rac1 rac1.example.com

192.168.212.41 rac2 rac2.example.com

# Private IP

10.0.0.1 rac1-priv

10.0.0.2 rac2-priv

# Virtual IP

192.168.212.70 rac1-vip

192.168.212.71 rac2-vip

# Scan IP

192.168.212.90 rac-scan

>>

# crsctl check cluster -all

**************************************************************

rac1:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

rac2:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

>>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2018
Added on Dec 14 2017
0 comments
808 views