Allow me to guess the sequence of events that brought you to this blog, possibly via google.
- You just installed the Oracle 10g clusterware
- You just ran root.sh and got an error:
The given interface(s), "eth0" is not public. Public interfaces should be used to configure virtual IPs.
- You just went to metalink Note:316583.1 or Note:387691.1
- You just issued something like:
srvctl add nodeapps -n crmnode1 -o /ora/ora10 -A 1.2.3.4/255.255.255.0
- You just attempted to start the VIP via:
srvctl start nodeapps -n node1
- It just failed with:
/opt/oracle> srvctl start nodeapps -n node1
node1:ora.node1.vip:Invalid parameters, or failed to bring up VIP (host=node1)
node1:ora.node1.vip:Invalid parameters, or failed to bring up VIP (host=node1)
CRS-1006: No more members to consider
CRS-0215: Could not start resource 'ora.node1.vip'.
CRS-0210: Could not find resource ora.node1.LISTENER_NODE1.lsnr
- And now you are relying on Google to help you with what Metalink couldn’t.
Well look no more, and here’s the solution.
When you issued the add nodeapps command, you did not include the interface name. It’s ok, it’s not your fault, it’s how the example was formated in these 2 notes and the srvctl documentation as well.
I know you want to fix this right now, but please read the whole blog before running any commands:
srvctl modify nodeapps -n node1 -A 1.2.3.4/255.255.255.0/eth0
Dont forget the other nodes, just replace the node number (can all be done on 1 node). The srvctl documentation actually shows that there’s an interface parameter, just very casually and only in the Options section. Extract:
-n node_name Node name. -o oracle_home Oracle home for the cluster database. -A addr_str The node level VIP address (name|ip/netmask[/if1[|if2|...]]).
Then bring up the nodeapps and check status:
srvctl start nodeapps -n node1 crs_stat -t
That’s it. Before running those though, you may want to make sure this is the problem you are experiencing.
Run this (replace node1):
crs_stat -p ora.node1.vip|grep USR_ORA_IF
If it shows empty (“USR_ORA_IF=”) then it’s most likely this is your problem.
I hope you dont encounter any other issues with your RAC installation. But if you do, and nothing in Metalink or Google helps you figure it out, I’d love to help.
5 Comments. Leave new
Hi Christo,
thank you for the blog.
For me you guessed right just google site :) because I use Google Reader.
But I think most of people will go to your blog through RSS channels.
Should we vote for how people go to the Pythian blog?
Do you have online voting feature on the site? :)
Regards,
Andrey Goryunov
Andrey,
My experience is that it’s amazing how many people turn up at my blog via a Google search for some obscure parallel wait event so I guess that was the audience Christo was aiming at. I notice Kevin Closson is taking the same approach – blogging about little-known problems that people might encounter.
Me? I arrive here via RSS ;-)
Cheers,
Doug
Hi,
Thanks for your help.
But, could i ask something else?
How can i include/excluse a listener in the RAC?
I have a cluster of 2 servers, in one we have 2 listeners registered, 1 for ORACLE_HOME and 1 for CRS_HOME, in the second node we have 3 listeners registered, 1 for CRS_HOME end 2 for ORACLE_HOME.
I need to add a new listener with name LISTENER in the second node or remove the listener named LISTENER of the first node.
Thanks
Thanks a lot – that worked
Thanks a lot for your post. I ran into this problem, but I had used vipca instead of manually executing “srvctl add […]”. Just when it was trying to start the GSD application resource, I got a CRS-0215 error. I applied your solution, and vipca finished just fine.