Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to access mounted drive as raw file

Re: how to access mounted drive as raw file

From: koert54 <koert54_at_nospam.com>
Date: Mon, 04 Mar 2002 09:11:31 GMT
Message-ID: <7TGg8.235713$rt4.22558@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 Mon Mar 04 2002 - 03:11:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US