Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
Raw Devices

Raw Devices

2006-10-09       - By C'est Pierre

 Back
Reply:     1     2     3     4     5     6  

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