I'd better create 47 LVM volumes (even in clustered environment). But
really, it is a bad practice - just install ASM on raw devices, and you
will need only 1 - 2 partitions per disk. You d o n o t n e e d ASMLib
to run ASM.
(I think that system may have a limitation on disk driver or, more likelyt,
don't create more than 15 partition devices by default)
----- Original Message -----
From: "Fabrizio Magni" <fabrizio.magni@(protected)>
To: "C'est Pierre" <cestpierre@(protected)>
Cc: <suse-oracle@(protected)>
Sent: Monday, October 09, 2006 8:32 AM
Subject: Re: [suse-oracle] Raw Devices
> 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
> >
> >
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
