Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to access mounted drive as raw file
"I never said you said you could".
This is worse than the UN when we had all that shoe banging by the USSR.
I said, "I didn't know you could do that", which hardly is equivalent of some "J'Accuse" thing.
And I still think mixing raw partitions and file systems on the same spindles is a terribly bad idea, which is also something I think you didn't say, so get over it.
RSH.
"koert54" <koert54_at_nospam.com> wrote in message
news:7TGg8.235713$rt4.22558_at_afrodite.telenet-ops.be...
> Where in my post does it say you can mount a raw device ? You can't mount
a
> raw device but you can create symbolic links to it ...
>
> "RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message
> news:AMrg8.11070$gK2.829750_at_bgtnsc04-news.ops.worldnet.att.net...
> > I never mount raw disks or partitions, and never mix raw partitions and
> > cooked ones on the same disk. I didn't actually know you COULD 'mount' a
> raw
> > disk or disk partition.
> > Oh well, learn something new every day.
> >
> > RSH.
> >
> >
> > "koert54" <koert54_at_nospam.com> wrote in message
> > news:0e8g8.223606$rt4.22113_at_afrodite.telenet-ops.be...
> > > I'm guessing you're on on some sort of windows platform using some
sort
> of
> > > Oracle version (the one without a version and stuff )?????
> > >
> > > Anyways - a raw device is a piece of your disk without a filesystem on
> > it -
> > > can be a logical volume or a partition.
> > > On NT/2000 you also don't have to assign a drive letter to it ...
> > >
> > > On Unix you can access the raw device through its special device file.
> The
> > > lazy dba's amoung as - me included - like to create symbolic
> > > links to the special device file (ln -s /dev/xxx xxx.dbf) ... this way
> the
> > > usage within Oracle is kind of transparant.
> > >
> > > Now on NT/2000 the only way to access a raw device is by creating
> symbolic
> > > links representing the raw devices. So using \\.\i:\raw is pretty
> > > pointless because there's no drive letter to point to ! :-)
> > > So you'll need an Oracle tool called Oracle Object Link Manager.
> > > (GUIORACLEOBJMANAGER.EXE)
> > > It's normally included with Oracle OPS or Oracle RAC. I just
> > > installed/configured a 9i RAC last week on 2000 and
> > > this tool will let you create/delete/rename the symbolic links and
sync
> > the
> > > links amoung the participating nodes...
> > > Once the link is created you can do things like " create tablespace
....
> > > datafile '\\.\symbolic_link_name' "
> > >
> > > Oracle 9i RAC is now sooooo easy you could even do it with one thumb
in
> > your
> > > ass ! (until the lock transferts start and your thumb is needed for
> > > gc_files_to_lock) :-)
> > >
> > > "Richard Limanowski" <richard.limanowski_at_t-online.de> wrote in message
> > > news:a77e1f06.0203020624.7cd9fc24_at_posting.google.com...
> > > > Hi,
> > > >
> > > > I am looking for a way to access "mounted drive" as a raw file from
> > > > within oracle.
> > > >
> > > > In an article "HOW TO SETUP ORACLE ON A RAW PARTITION" I found a
> > > > description how to do in on a partition level:
> > > > 1. create partition (without creating a file system on it)
> > > > 2. use raw file with a construct '\\.\f:' like
> > > > create tablespace xxx datafile '\\.\f:' size 1 M;
> > > >
> > > > But what if I:
> > > > 1. create partition (without creating a file system on it)
> > > > 2. do not assign a drive letter to it but mount it into an empty
> > > > NTFS directory, say 'i:\raw1'?
> > > >
> > > > I tried:
> > > > richard_at_onc> CREATE TABLESPACE rts DATAFILE '\\.\i:\raw1' SIZE 1M
> > > > *
> > > > ERROR at line 1:
> > > > ORA-01119: error in creating database file '\\.\i:\raw1'
> > > > ORA-27040: skgfrcre: create error, unable to create file
> > > > OSD-04002: Datei kann nicht geöffnet werden
> > > > O/S-Error: (OS 5) Zugriff verweigert
> > > >
> > > > Cheers
> > > >
> > > > Richard Limanowski
> > >
> > >
> >
> >
>
>
Received on Tue Mar 05 2002 - 00:03:46 CST