Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

Re: [suse-oracle] Raw Devices

Fabrizio Magni

2006-10-09

Replies:

Pierre,
you are not forced to use ASMlib when going with ASM.

The bug/limitation seems interesting. Can you have some information from
your DBA?

Fabrizio

On 10/9/06, C'est Pierre <cestpierre@(protected):
>
> Hi Fabrizio,
>
> We skipped the option of using ASMLib on this cluster. Our dba said it
> had a limitation (or bug) when a tablespace (or was it raw device?)
> filled up, they couldn't extend the size anymore. This is a migration
> database, so they'll need lots more space than we already have in the
> long run.
>
> We're using RAC and raw devices only, from what he said. An
> alternative in mind is OCFS.
>
> Any thoughts?
>
>
> Thanks,
> Pierre
>
>
> On 10/9/06, Fabrizio Magni <fabrizio.magni@(protected):
> > Hi Pierre,
> > just personal curiosity: what's the advantage to have 47 partition on
> the
> > same disk?
> > If you are still using the ASM then you can simply use a single
> partition
> > (or device).
> > Tablespaces are already divided inside that device optimizing the space
> > usage.
> >
> > Regards
> > Fabrizio
> >
> >
> > On 10/9/06, C'est Pierre <cestpierre@(protected):
> > >
> > > Hello all,
> > >
> > > First, I am sys-administrator, not a DBA, so excuse me if I am no
> > > precise with some tech. aspects of Oracle.
> > >
> > > I am in the process of installing a new RAC cluster. Our previous one,
> > > went smoothly, but we used ASMLib, which we aren't using now. Problem:
> > > I created 47 partitions on a scsi disk presented to the server thru a
> > > fibre channel card. These are sda1 thru sda47. However, only the 15
> > > first (except one, which is the extended one - sda4) are usable.
> > >
> > > I wrote the /etc/raw, mapping sda's to raw's just as the dba sugested
> > > for organizational purposes (they aren't sequential, e.g raw51 maps
> > > to sda28).
> > >
> > > I then made this line of bash to create all device nods that weren't
> > > there (and even those that were...just in case):
> > >
> > >   for i in `seq -f %g 1 47`; do echo mknod sda$i b 8 $i ; done
> > >
> > > Problem: I can't access past sda16, I get this error:
> > >
> > > dd: opening `/dev/sda16': No such device or address
> > >
> > > when I look at dmesg and /proc/partitions, I only get to see the first
> > > 15 partitions there (or 16, if you count with 'sda')
> > >
> > > sda: sda1 sda2 sda3 sda4 < sda5 sda6 sda7 sda8 sda9 sda10 sda11 sda12
> > > sda13 sda14 sda15 >
> > >
> > > I've googled for this problem and it seems there's a limitation on
> > > scsi disks of 16 partitions per device. Is this true? if so, what is
> > > the solution for this problem? how can I make 47 raw partitions?
> > >
> > > I can still ask our storage administrator to divide this disk into
> > > several disks and then we will group partitions 16 partitions on each,
> > > but this isn't a good solution. Another alternative solution which our
> > > dba presented, was adding ocfs 2 support and make it dance with the
> > > devil by the pale moonlight ;-)
> > >
> > > Let me know your thoughts and especially solutions!!
> > >
> > > Also, your thoughts on ocfs or not as a side note would be apreciated.
> > >
> > > Thank you
> > >
> > > Pierre
> > >
> > > P.S: I'm not french but I love french bread! ;)
> > >
> > > --
> > > To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> > > For additional commands, email: suse-oracle-help@(protected)
> > > Please see http://www.suse.com/oracle/ before posting
> > >
> > >
> >
> >
>
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.