Re: ASM installation problems: re: Further adventures in the world of RAC
- From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
- To: "Anurag Verma" <anuragdba@xxxxxxxxx>
- Date: Thu, 28 Jun 2007 08:05:17 -0500
The permissions are set via oracleasm, correct? They are the same for both
nodes, and they are still under root.
On 6/28/07, Anurag Verma <anuragdba@xxxxxxxxx> wrote:
Did you set the persmissions of disk to oracle user on Node 2 when the
node boots up??
Are they still under root user on the second node?
On 6/27/07, Charles Schultz <sacrophyte@xxxxxxxxx> wrote:
>
> Two updates:
>
> Oracle Support has responded rather quickly, so perhaps I may be able to
> get an answer through those channels first, for a pleasant change. =)
> Also, ASM on node1 mounted the disk fine, but node2 has the problem:
>
> NODE1_SQL> select state,header_status,substr(name,1,12) Name,free_mb,
> substr(path,1,16) PATH from v$asm_disk;
>
> STATE HEADER_STATU NAME FREE_MB PATH
> -------- ------------ ------------ ---------- ----------------
> NORMAL PROVISIONED 0 ORCL:VOLUME2
> NORMAL MEMBER VOLUME1 34766 ORCL:VOLUME1
>
> NODE2_SQL> select state,header_status,substr(name,1,12) Name,free_mb,
> substr(path,1,16) PATH from v$asm_disk;
>
> STATE HEADER_STATU NAME FREE_MB PATH
> -------- ------------ ------------ ---------- ----------------
> NORMAL UNKNOWN 0 ORCL:VOLUME2
> NORMAL UNKNOWN 0 ORCL:VOLUME1
>
> It has been suggested that I try to drop and recreate the disks. I am
> willing to try it (because this is a new install), but will that mess things
> up for node1?
>
> On 6/27/07, Charles Schultz <sacrophyte@xxxxxxxxx > wrote:
> >
> > I found Bill Wagman's
thread<http://www.freelists.org/archives/oracle-l/04-2007/msg00205.html>to be quite
interesting, especially since we are hitting a similar problem
> > now. I filed the SR ( 6395660.992) first in the hopes that someone at
> > Oracle Support will eventually get around to it. =)
> >
> > Hardware/software:
> > RHEL4 (Nanant) running on 2 Dell 2950's, gigabit nic
> > Stock Oracle 10.2.0.1 for clusterware and asm oracle home
> >
> > CRS install went just dandy, including all of K Gopal's suggest cluvfy
> > steps. The ASM install was going nicely until I hit the DBCA, at which point
> > the ASM instance on node 2 could not start because it could not mount the
> > disks. After digging around and finding Varga's
blog<http://blogs.oracle.com/AlejandroVargas/newsItems/viewFullItem$126>,
> > I did some homework with my sysadmin and configured /etc/sysconfig/oracleasm
> > to exclude the scsi drivers from our linux multipath ( not EMC
> > PowerPath) scans. So, how do I get my ASM instance to mount the disks after
> > solving that little riddle? I am looking through K Gopal's book (and now we
> > have Julian Dyke's book as well); I am sure the answer is in there
> > somewhere, but if someone wants to give me a little hint as to what page,
> > that would be cool. *grin*
> >
> > For those interested in nitty-gritty details, here is the current
> > error:
> > SQL> ALTER DISKGROUP ALL MOUNT;
> > ALTER DISKGROUP ALL MOUNT
> > *
> > ERROR at line 1:
> > ORA-15032: not all alterations performed
> > ORA-15063: ASM discovered an insufficient number of disks for
> > diskgroup "DATA"
> >
> > From alert.log
> > NOTE: cache registered group DATA number=1 incarn=0x0e9a9f02
> > Wed Jun 27 17:08:20 2007
> > ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg =
> > [Operation not permitted]
> > Wed Jun 27 17:08:20 2007
> > ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg =
> > [Operation not permitted]
> > Wed Jun 27 17:08:20 2007
> > ERROR: no PST quorum in group 1: required 2, found 0
> > Wed Jun 27 17:08:20 2007
> > NOTE: cache dismounting group 1/0x0E9A9F02 (DATA)
> > NOTE: dbwr not being msg'd to dismount
> > ERROR: diskgroup DATA was not mounted
> >
> > I have also looked at Metalink notes:
> > *391136.1
> > * *309815.1
> > **353423.1 - this one might be helpful, but since node1 appears to be
> > ok, I am not so sure about dropping the diskgroup
> > * 398622.1 - I saw a reference for this, but cannot find the note
> > itself.
> >
> > TIA. Hopefully, I am missing something obvious.
> >
> > --
> > Charles Schultz
>
>
>
>
> --
> Charles Schultz
--
Charles Schultz
- References:
- ASM installation problems: re: Further adventures in the world of RAC
- From: Charles Schultz
- Re: ASM installation problems: re: Further adventures in the world of RAC
- From: Charles Schultz
- Re: ASM installation problems: re: Further adventures in the world of RAC
- From: Anurag Verma
Other related posts:
- » ASM installation problems: re: Further adventures in the world of RAC
- » Re: ASM installation problems: re: Further adventures in the world of RAC
- » Re: ASM installation problems: re: Further adventures in the world of RAC
- » Re: ASM installation problems: re: Further adventures in the world of RAC
Did you set the persmissions of disk to oracle user on Node 2 when the node boots up?? Are they still under root user on the second node? On 6/27/07, Charles Schultz <sacrophyte@xxxxxxxxx> wrote: > > Two updates: > > Oracle Support has responded rather quickly, so perhaps I may be able to > get an answer through those channels first, for a pleasant change. =) > Also, ASM on node1 mounted the disk fine, but node2 has the problem: > > NODE1_SQL> select state,header_status,substr(name,1,12) Name,free_mb, > substr(path,1,16) PATH from v$asm_disk; > > STATE HEADER_STATU NAME FREE_MB PATH > -------- ------------ ------------ ---------- ---------------- > NORMAL PROVISIONED 0 ORCL:VOLUME2 > NORMAL MEMBER VOLUME1 34766 ORCL:VOLUME1 > > NODE2_SQL> select state,header_status,substr(name,1,12) Name,free_mb, > substr(path,1,16) PATH from v$asm_disk; > > STATE HEADER_STATU NAME FREE_MB PATH > -------- ------------ ------------ ---------- ---------------- > NORMAL UNKNOWN 0 ORCL:VOLUME2 > NORMAL UNKNOWN 0 ORCL:VOLUME1 > > It has been suggested that I try to drop and recreate the disks. I am > willing to try it (because this is a new install), but will that mess things > up for node1? > > On 6/27/07, Charles Schultz <sacrophyte@xxxxxxxxx > wrote: > > > > I found Bill Wagman's thread<http://www.freelists.org/archives/oracle-l/04-2007/msg00205.html>to be quite interesting, especially since we are hitting a similar problem > > now. I filed the SR ( 6395660.992) first in the hopes that someone at > > Oracle Support will eventually get around to it. =) > > > > Hardware/software: > > RHEL4 (Nanant) running on 2 Dell 2950's, gigabit nic > > Stock Oracle 10.2.0.1 for clusterware and asm oracle home > > > > CRS install went just dandy, including all of K Gopal's suggest cluvfy > > steps. The ASM install was going nicely until I hit the DBCA, at which point > > the ASM instance on node 2 could not start because it could not mount the > > disks. After digging around and finding Varga's blog<http://blogs.oracle.com/AlejandroVargas/newsItems/viewFullItem$126>, > > I did some homework with my sysadmin and configured /etc/sysconfig/oracleasm > > to exclude the scsi drivers from our linux multipath ( not EMC > > PowerPath) scans. So, how do I get my ASM instance to mount the disks after > > solving that little riddle? I am looking through K Gopal's book (and now we > > have Julian Dyke's book as well); I am sure the answer is in there > > somewhere, but if someone wants to give me a little hint as to what page, > > that would be cool. *grin* > > > > For those interested in nitty-gritty details, here is the current > > error: > > SQL> ALTER DISKGROUP ALL MOUNT; > > ALTER DISKGROUP ALL MOUNT > > * > > ERROR at line 1: > > ORA-15032: not all alterations performed > > ORA-15063: ASM discovered an insufficient number of disks for > > diskgroup "DATA" > > > > From alert.log > > NOTE: cache registered group DATA number=1 incarn=0x0e9a9f02 > > Wed Jun 27 17:08:20 2007 > > ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = > > [Operation not permitted] > > Wed Jun 27 17:08:20 2007 > > ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = > > [Operation not permitted] > > Wed Jun 27 17:08:20 2007 > > ERROR: no PST quorum in group 1: required 2, found 0 > > Wed Jun 27 17:08:20 2007 > > NOTE: cache dismounting group 1/0x0E9A9F02 (DATA) > > NOTE: dbwr not being msg'd to dismount > > ERROR: diskgroup DATA was not mounted > > > > I have also looked at Metalink notes: > > *391136.1 > > * *309815.1 > > **353423.1 - this one might be helpful, but since node1 appears to be > > ok, I am not so sure about dropping the diskgroup > > * 398622.1 - I saw a reference for this, but cannot find the note > > itself. > > > > TIA. Hopefully, I am missing something obvious. > > > > -- > > Charles Schultz > > > > > -- > Charles Schultz
- ASM installation problems: re: Further adventures in the world of RAC
- From: Charles Schultz
- Re: ASM installation problems: re: Further adventures in the world of RAC
- From: Charles Schultz
- Re: ASM installation problems: re: Further adventures in the world of RAC
- From: Anurag Verma