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: create control files HELP

Re: create control files HELP

From: David Fitzjarrell <oratune_at_aol.com>
Date: Sat, 11 Nov 2000 00:07:32 GMT
Message-ID: <8ui2k1$tm8$1@nnrp1.deja.com>

In our last gripping episode "Thierry TERZANO" <tterzano_at_sopra.com> wrote:
> Hi,
>
> I've lost all my control files so I tri to create new ones in order
 not to
> lost all my database.
> I've read this order :
>
> create controlfile reuse
> database DATAORA
> logfile 'd:\database\PL31\LOG1PL31.ora' size 1M reuse,
> 'd:\database\PL31\LOG2PL31.ORA' size 1M reuse,
> 'd:\database\PL31\LOG3PL31.ORA' size 1M reuse
> noresetlogs
> datafile 'D:\database\PL31\USR1PL31.ORA' size 1024002K reuse,
> 'D:\database\PL31\USR2PL31.ORA' size 1024002K reuse,
> 'D:\database\PL31\USR3PL31.ORA' size 1024002K reuse,
> 'D:\database\PL31\USR4PL31.ORA' size 1024002K reuse,
> 'D:\database\PL31\IDX1PL31.ORA' size 409602K reuse,
> 'D:\database\PL31\IDX2PL31.ORA' size 409602K reuse,
> 'D:\database\PL31\RBS1PL31.ORA' size 65538K reuse,
> 'D:\database\PL31\TMP1PL31.ORA' size 524290K reuse,
> 'D:\database\PL31\SYS1PL31.ORA' size 65538K reuse
> noarchivelog
> ;
>
> but it doesn't like to be good because i've got this error messages :
>
> create controlfile reuse
> *
> ORA-01503: echec de CREATE CONTROLFILE
> ORA-01565: erreur d'identification du fichier
> 'D:\database\PL31\USR1PL31.ORA'
> ORA-09202: sfifi: erreur lors de l'identification du fichier
> OSD-04002: Ouverture de fichier impossible
> O/S-Error: (OS 5) Access is denied.
>
> So, has someone any idea in ordre to solve this problem ?
>
> Thanks a lot for any "helper".
> Thierry
>
>

The key is the last error entry:

> O/S-Error: (OS 5) Access is denied

This indicates you don't have permission to write the file. You should be logged in as Administrator to create new controlfiles on NT.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Nov 10 2000 - 18:07:32 CST

Original text of this message

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