cluvfy and user equivalence

Oh how I've been looking forward to this week.

Why you ask?

This week I'm setting up my first Oracle RAC instance. SQUEEEE

New policies at work dictate that we start phasing out any non-Windows servers so I was given two new Windows Server 2008 machines to utilize.


I was hoping to use Oracle 11.2 since the new ASM features seem leaps and bounds better than 11.1, but 11.2 isn't out yet for Windows so I'm sticking with 11.1.0.7 for now.

Like any responsible DBA type looking at a new technology, I spent some solid time with the documentation. The Cluster Verification Utility immediately grabbed my attention as something that will be essential for me and I loved that I could use it at different phases of the setup to constantly reassure myself that everything was golden.

My first major stumbling block occurred when I tested for user equivalence in my two nodes:

runcluvfy.bat comp admprv -o user_equiv -n node_list -verbose

This kept telling me that it was failing on the opposite node, but the existing one was fine.

Numerous searches came up with the same two reasons for this:
1) Your user doesn't have admin rights on the server
2) Your user doesn't have the same password on both servers

Well I found a third reason today:
3) Your user isn't part of the ORA_DBA group

While Oracle's documentation does specify at some point to create this group, but it also mentions that on Windows, the OUI will do this for you, so I assumed that it wasn't necessary. Totally my fault, I assumed.

CVU success !!!!