Hi,
We have existing ORACLE 10gR2 RAC on two node HP-UX servers.
One RAC database is currently running on this RAC Cluster, wanted to create another RAC database.
oracle@dbnode02[cngdbs1]:/home/oracle$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE dbnode01
ora....01.lsnr application ONLINE ONLINE dbnode01
ora....s01.gsd application ONLINE ONLINE dbnode01
ora....s01.ons application ONLINE ONLINE dbnode01
ora....s01.vip application ONLINE ONLINE dbnode01
ora....SM2.asm application ONLINE ONLINE dbnode02
ora....02.lsnr application ONLINE ONLINE dbnode02
ora....s02.gsd application ONLINE ONLINE dbnode02
ora....s02.ons application ONLINE ONLINE dbnode02
ora....s02.vip application ONLINE ONLINE dbnode02
ora.orcl.db application ONLINE ONLINE dbnode01
ora....l1.inst application ONLINE ONLINE dbnode01
ora....l2.inst application ONLINE ONLINE dbnode02
Tried to create the database with "dbca", the node accessibility check failed on Node 1 "dbnode01"
The user "oracle" does not have user equivalence setup on nodes "dbnode01". Please set up the user equivalence before proceeding.
PRKC-1030: Error checking accessibility for node dbnode01, remshd: Login incorrect.
oracle@dbnode01:/home/oracle$ cluvfy stage -post hwos -n dbnode01,dbnode02 -verbose
Performing post-checks for hardware and operating system setup
Checking node reachability...
Check: Node reachability from node "dbnode01"
Destination Node Reachable?
------------------------------------ ------------------------
dbnode01 yes
dbnode02 yes
Result: Node reachability check passed from node "dbnode01".
Checking user equivalence...
Check: User equivalence for user "oracle"
Node Name Comment
------------------------------------ ------------------------
dbnode02 passed
dbnode01 failed
Result: User equivalence check failed for user "oracle".
WARNING:
User equivalence is not set for nodes:
dbnode01
Verification will proceed with nodes:
dbnode02
Checking node connectivity...
Interface information for node "dbnode02"
Interface Name IP Address Subnet
------------------------------ ------------------------------ ----------------
lan1 192.168.1.2 192.168.1.0
lan0 10.241.16.34 10.241.16.32
lan0 10.241.16.38 10.241.16.32
Check: Node connectivity of subnet "192.168.1.0"
Result: Node connectivity check passed for subnet "192.168.1.0" with node(s) dbnode02.
Check: Node connectivity of subnet "10.241.16.32"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
dbnode02:lan0 dbnode02:lan0 yes
Result: Node connectivity check passed for subnet "10.241.16.32" with node(s) dbnode02 .
Suitable interfaces for the private interconnect on subnet "192.168.1.0":
dbnode02 lan1:192.168.1.2
Suitable interfaces for the private interconnect on subnet "10.241.16.32":
dbnode02 lan0:10.241.16.34 lan0:10.241.16.38
ERROR:
Could not find a suitable set of interfaces for VIPs.
Result: Node connectivity check failed.
Checking shared storage accessibility...
Shared storage check failed on nodes "dbnode02".
Post-check for hardware and operating system setup was unsuccessful on all the nodes.
The Passwordless ssh connectivity is OK from both the nodes
oracle@dbnode01:/home/oracle$ ssh dbnode01 date
Sat Feb 4 08:55:23 WAT 2012
oracle@dbnode01:/home/oracle$ ssh dbnode02 date
Sat Feb 4 08:55:25 WAT 2012
oracle@dbnode02:/home/oracle$ ssh dbnode01 date
Sat Feb 4 08:55:11 WAT 2012
oracle@dbnode02:/home/oracle$ ssh dbnode02 date
Sat Feb 4 08:55:20 WAT 2012
I am confused why the cluvfy failed while the RAC DB is already existed on the Cluster,
I went on creating a RAC database on Second node so that I can add another instance to the other node,
oracle@hisdbs02[cngdbs1]:/home/oracle$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
*ora....bs1.srv application ONLINE ONLINE dbnode02*
*ora....dtaf.cs application ONLINE ONLINE dbnode02*
*ora....s1.inst application ONLINE ONLINE dbnode02*
*ora.cndbs.db application ONLINE ONLINE dbnode01*
ora....SM1.asm application ONLINE ONLINE dbnode01
ora....01.lsnr application ONLINE ONLINE dbnode01
ora....s01.gsd application ONLINE ONLINE dbnode01
ora....s01.ons application ONLINE ONLINE dbnode01
ora....s01.vip application ONLINE ONLINE dbnode01
ora....SM2.asm application ONLINE ONLINE dbnode02
ora....02.lsnr application ONLINE ONLINE dbnode02
ora....s02.gsd application ONLINE ONLINE dbnode02
ora....s02.ons application ONLINE ONLINE dbnode02
ora....s02.vip application ONLINE ONLINE dbnode02
ora.orcl.db application ONLINE ONLINE dbnode01
ora....l1.inst application ONLINE ONLINE dbnode01
ora....l2.inst application ONLINE ONLINE dbnode02
How can we setup user Equivalence on the Node 1?