Re: Oracle Linux Cluster File System

Pete,

> as I suspect there's a fundamental lack of understanding here

Oh, I'm sorry about that! Let me explain.

Fundamental Breakdown: Let's not discuss about the suggested sizes.

Second point: mknod does not create a tablespace, it creates a special file. raw does not create a tablespace, it binds a raw device to block devices. So, I did not want to create physical files for every node.

Before going any further: Let's say I issue the fdisk command on one node only (which I intended to do anyway).

I really would like to get some comments on my scriptlets. Or at least not only a RTFM
suggestion without a URL.

Thanks in advance,

Norbert

"Pete Sharman" <peter.sharman_at_oracle.com> schrieb im Newsbeitrag news:ah9d8u01kb1_at_drn.newsguy.com...
> 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 Sat Jul 20 2002 - 04:57:02 CDT