Re: Oracle Linux Cluster File System

In article <ah8ok2$aro$03$1_at_news.t-online.com>, "Norbert says...
>
>Since you mentioned "sales":
>
>I would be pleased to get some helping hand with regard to raw devices then:
>
>(see RE: RAC on Linux Cluster, Message-ID:
><ah6tgd$spt$04$1_at_news.t-online.com>)
>
>Please comment the suggested prodecure (I start with two nodes)
>
>The following tablespaces are needed:
>
>system (10GB)
>indx (50GB)
>temp (10GB)
>user (50GB)
>tools (10GB)
>undo_nodeX (10GB)
>control1 (10GB)
>control2 (10GB)
>control3 (10GB)
>redo1_nodeX (10GB)
>redo2_nodeX (10GB)
>
>(that's 8 tablespaces on-off, 3 per node, 2 nodes make 6+8 = 14 tablespaces,
>size = 160 GB + 2 * 3 * 10 GB = 220 GB)

OK, fundamental breakdown in understanding right here. For one thing, your files are ridiculously large. Why are you setting up everything in chunks of 10 Gb? 10 gig is far, far too large for any control files or redo log files, and unless you have a ginormous database with literally trillions of lines of PL/SQL code you won't need a 10 gig SYSTEM tablespace either. Likewise the other files are for tablespaces that are used generally in demo systems, and I've never seen a demo database 190 Gb in size! :)

Second point, in RAC the datafiles are shared i.e. accessible from each node, but there's only one copy of each file e.g. you don't have a SYSTEM tablespace on each node, unless you have multiple databases.

Before you go any further, I strongly suggest you read both the Oracle and RAC Concepts manuals, as I suspect there's a fundamental lack of understanding here.

Pete
>
>I would do it like:
>
>on node1:
>
>fdisk /dev/sda
>
>create first 4 partitions primary
>then one big extended
>then therein 14-4 logical partitions
>
>(this creates devices /dev/sda1 ... /dev/sda14
>
>on every node:
>
>create special files for every tablespace
>
>mknod /dev/system.dbf c 162 1
>...
>
>bind the block device to the raw device
>
>e.g.:
>
>raw /dev/system.dbf /dev/sda/sda1
>
>instead, write the config file (suse, package rawio)
>
>system.dbf:sda1
>indx.dbf:sda2
>...
>
>edit /etc/rc.config
>
>ACTIVATE_RAW_DEV=yes
>
>
>chown oracle /dev/system.dbf
>
>etc.
>
>
>Thanks in advance,
>
>Norbert
>
>
>"Pete Sharman" <peter.sharman_at_oracle.com> schrieb im Newsbeitrag
>news:ah76nq02q45_at_drn.newsguy.com...
>> In article <3D371161.13DD_at_yahoo.com>, Connor says...
>> >
>> >Pete Sharman wrote:
>> >>
>> >> In article <ah6tk1$elf$01$1_at_news.t-online.com>, "Norbert says...
>> >> >
>> >> >At OracleWorld Copenhagen Oracle said they will release a CFS for
>linux this
>> >> >month.
>> >> >
>> >> >Does anybody know something about actual release date?
>> >> >
>> >> >Thanks,
>> >> >
>> >> >Norbert
>> >> >
>> >> >
>> >> Yes. Can I tell you? No.
>> >>
>> >> Sorry, couldn't resist! :)
>> >>
>> >> HTH. Additions and corrections welcome.
>> >>
>> >> Pete
>> >>
>> >> SELECT standard_disclaimer, witty_remark FROM company_requirements;
>> >
>> >(and since you're an Oracle employee...)
>> >
>> >even if you did tell us - would be it correct tomorrow ? No!
>> >
>> >:-)
>>
>> Oohhh, cutting, cutting! Do you see the word "Sales" in my title? :)
>>
>> Pete
>> >
>> >--
>> >==============================
>> >Connor McDonald
>> >
>> >http://www.oracledba.co.uk
>> >
>> >"Some days you're the pigeon, some days you're the statue..."
>>
>> HTH. Additions and corrections welcome.
>>
>> Pete
>>
>> SELECT standard_disclaimer, witty_remark FROM company_requirements;
>>
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Fri Jul 19 2002 - 11:03:42 CDT