Sunday, May 14, 2006

RACing ahead with Oracle on VMware - Part 12 (ASM) up on 20th May 2006!



We will continue our Oracle RAC on VMware series with understanding what ASM is (briefly) and going ahead and installing and configuring ASMlib.

Read it on the 20th May 2006 on DBAsupport and DatabaseJournal.

PS: I will also start doing/starting RAC administration series (which will be rather long) and will be very helpful to DBAs (me included) and Database enthusiasts to manage our Oracle RAC farm. Performance too will be taken into account. So lots of exciting material coming up in the coming months...

Tuesday, May 02, 2006

RAC Clusterware configuration problems

Khanh Vu Viet wrote:

Dear you,
I've read your articles about install RAC on VMWare. I've already
setup this demo. But the problem happened with these problem:
- Output generated from configuration assistant "Oracle Cluster
Ready Services Configuration Assistant":
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node :
node 1: rac1 10.0.0.1 rac1
node 2: rac2 10.0.0.2 rac2
Creating OCR keys for user 'administrator', privgrp ''..
Operation successful.
Now formatting voting device: F:\cdata\rac\votedsk
Successful in setting block0 for voting disk.
Format complete.
Step 1: checking status of CRS cluster
Step 2: configuring OCR repository
Step 3: configuring safe mode for CRS stack
Step 4: Starting up CRS stack on all nodes
rac1 service OracleCSService in improper PENDING state, err(997)
rac2 service OracleCSService in improper PENDING state, err(997)

Configuration assistant "Oracle Cluster Ready Services Configuration
Assistant" failed

- I've manually started these services in the command prompt but it
can not started.

Please checked it again and help me to solve this problem.

Thanks and regards


My Answer:

Kanhn,

How does your hosts file look like? Is the public interface on top of the list, if not, put it there. Private interface should be under it. More or less like this...



Secondly:

Are your disks automounted (like I suggested on my articles)? If not, automount them with DISKPART.

Then attempt to start the CRS services.

Oracle RAC VIP nodes configuration

I got several emails and instead of answering all the problems privately to each of them, I decided to address the issues here on the blog.
WHY?
So we can share our problems with others.

Oscar Javier Flores Gutierrez asked:

Please Tarry, tell me , I do it of the correct way OR?

How I must to configure my VIP address?

Please Just help me with this couse is the only mistake that i have, this error:

ERROR:
No se ha encontrado un juego de interfaces adecuado para VIP.

Resultado: Fallo de comprobaci¾n de conectividad de nodos.

or english somthing like this.. "No found a Set of Interface to VIP",

PD:

Just help me on how you configure your Ips, how,?


My Answer:

Javier looking at your hosts file, I see that you have set the IPs as follows:

143.46.43.100 vmware01w2k3 in DNS
143.46.43.101 vmware01w2k3

143.46.43.104 vmware01w2k3-vip in host file
143.46.43.105 vmware01w2k3-vip

10.0.0.5 vmware01w2k3-priv in DNS and host file
10.0.0.6 vmware01w2k3-priv


NOTE: VIPs can be in the hosts file (not necessary though) but they must be registered in your DNS and doing a ping machinename-vip should (before the installation) give you machine not found error (I'm using simple language) and later on (after RAC installation) it will ping successfully.

So, register both your pubic as well as VIP addresses in your DNS server and keep the private (10.x.x.x, 192.x.x.x,172.x.x.x type of ip ranges are private ranges) NICs (which you will be using for high speed interconnect and RAC's cache fusion technology) in your hosts file.