Home » Server Options » RAC & Failsafe » Why does Voting File is different in different nodes (Oracle 11.2.0.1 SuSe LInux 11 SP3)
Why does Voting File is different in different nodes [message #615266] Sun, 01 June 2014 09:55 Go to next message
juniordbanewbie
Messages: 19
Registered: April 2014
Junior Member
Initially I have a one node RAC, later, in $GRID_HOME, the initohasd files is missing, so I've to deconfigure the clusterware and reinstall $GRID_BINARIES, in the process I also drop the diskgroup that contains both Voting disk and OCR. What happens is that I empty the disk before marking them with oracleasm libraries, i.e. /etc/init.d/oracleasm create disk OCR_VOTE 1 /dev/asm-ocr-vote1_part1.

Before I deconfigure the clusteware, I've used udev to mark the disk.

So after resintalling the grid binaries, I found some unexplained observations.


On my first node
grid@ORCL01:~> crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   3cf0990ca73f4f58bf18bcb9874524be (ORCL:OCR_VOTE1) [OCR_VOTE]
Located 1 voting disk(s).


on my second node
grid@ORCL02:~> crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   3cf0990ca73f4f58bf18bcb9874524be (/dev/asm-ocr-vote1_part1) [OCR_VOTE]
Located 1 voting disk(s).
grid@ORCL02:~>


Why is it in the second node it is reflecting the old udev path and not the oracleasm lib path (ORCL:OCR_VOTE1)

many thanks in advance!
Re: Why does Voting File is different in different nodes [message #615423 is a reply to message #615266] Tue, 03 June 2014 13:58 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

If this question still open.. Can you provide the details from both node ?

set linesize 120
select MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,name,path from v$asm_disk

/etc/oracleasm/querydisk <<diskname>> 


I would like to see major / minor number from both node.
Re: Why does Voting File is different in different nodes [message #617504 is a reply to message #615423] Mon, 30 June 2014 20:31 Go to previous messageGo to next message
juniordbanewbie
Messages: 19
Registered: April 2014
Junior Member
over at ASM2


col mount_status format a6
col header_status format a6
col mode_status format a6
col state format a6
col name format a9
col path format a24

SELECT disk.mount_status, disk.header_status, disk.mode_status, disk.state, disk.name, disk.path FROM v$asm_disk disk JOIN v$asm_diskgroup dg ON
disk.group_number = dg.group_number
WHERE dg.name='OCR_VOTE' ORDER BY disk.name;


MOUNT_ HEADER MODE_S STATE  NAME      PATH
------ ------ ------ ------ --------- ------------------------
CACHED MEMBER ONLINE NORMAL OCR_VOTE1 /dev/asm-ocr-vote1_part1
CACHED MEMBER ONLINE NORMAL OCR_VOTE2 /dev/asm-ocr-vote2_part1
CACHED MEMBER ONLINE NORMAL OCR_VOTE3 /dev/asm-ocr-vote3_part1


querydisk at ORCL02


ORCL02:~ # oracleasm querydisk -d OCR_VOTE1
Disk "OCR_VOTE1" is a valid ASM disk on device [8,97]


over at ASM1

SYS@ASM1>ed
Wrote file afiedt.buf

  1  SELECT disk.mount_status, disk.header_status, disk.mode_status, disk.state,
 disk.name, disk.path FROM v$asm_disk disk JOIN v$asm_diskgroup dg ON
  2  disk.group_number = dg.group_number
  3* WHERE dg.name='OCR_VOTE' ORDER BY disk.name
SYS@ASM1>/

MOUNT_ HEADER MODE_S STATE  NAME      PATH
------ ------ ------ ------ --------- ---------------
CACHED MEMBER ONLINE NORMAL OCR_VOTE1 ORCL:OCR_VOTE1
CACHED MEMBER ONLINE NORMAL OCR_VOTE2 ORCL:OCR_VOTE2
CACHED MEMBER ONLINE NORMAL OCR_VOTE3 ORCL:OCR_VOTE3

SYS@ASM1>


querydisk at ORCL01


ORCL01:~ # oracleasm querydisk -d OCR_VOTE1
Disk "OCR_VOTE1" is a valid ASM disk on device [253,43]

Re: Why does Voting File is different in different nodes [message #617687 is a reply to message #617504] Wed, 02 July 2014 12:26 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

ORCL01:~ # oracleasm querydisk -d OCR_VOTE1
Disk "OCR_VOTE1" is a valid ASM disk on device [253,43]

ORCL02:~ # oracleasm querydisk -d OCR_VOTE1
Disk "OCR_VOTE1" is a valid ASM disk on device [8,97]


It seems your major / minor numbers are different but this can't be same from storage level.. Why don't you check with your storage team for above shared device ?

In my experience few environment I do see the different major / minor numbers but as per my storage admin.. " Those lun's uniqe ID was same from storage clarrion but in server its shows different ID.. "

thanks, Babu
Previous Topic: SEVERE:OUI-67064:OPatchSession cannot load inventory for the given Oracle Home /u01/app/11.2.0.1/gri
Next Topic: [check] Error = error 11 encountered when sending messages to CRSD
Goto Forum:
  


Current Time: Fri Dec 19 03:50:43 CST 2014

Total time taken to generate the page: 0.09044 seconds