Re: Copying Database to new SID

DETAILS!!! I think I posted the original ages ago (well, a week or more ago), and I can't remember for the life of me the context, so ANY TIME you post, can you please include full error message details?? Particularly since I don't have my big boys book of Oracle error messages handy, and don't have the time to check technet!! (and that's a general message to anyone else who might consider posting *anything* here!)

That said, the mix of 8.1.5 and Windows 2000 is a bad one... Oracle only supports 8.1.6 for Windows 2000. Now that's not to say 8.1.5 simply *won't* work on W2K, because I had it working for a couple of months without problem. But it's not supported -which means nearly anything could be causing your problems. It *might* be a simple configuration thing that we can work through. But it might also be that there is a mysterious Oracle-W2K interaction that we'll never track down for sure.

My advice is to cut the losses, get hold of 8.1.6, and have a fresh go.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"Billy Collins" <billy_collins_at_my-deja.com> wrote in message
news:8quatu$3lf$1_at_nnrp1.deja.com...


> Hi,

>

> I am getting the same error ORA-01503, and I am not even using

> controlfile scripts! I am just installing Oracle on a fresh Windows

> 2000 server machine, and after installing all the (Java-laden) stuff,

> the installation suddenly breaks everytime with "Control file error"

> and then the database cannot be created!

>

> I am trying this with the Oracle 8.1.5!! IS there something I need to

> do for windows 2000 compatibility??

>

> Please let me know at your earliest..this is very urgent! Thanks very

> much in advance, much appreciated!

>

> Good day,

>

> Billy

>

>

>

> In article <39c27922$1_at_news.iprimus.com.au>,

>   "Howard J. Rogers" <howardjr_at_www.com> wrote:

> > There's a db_name parameter in your init.ora.  You forgot to edit it

 to


> > match the new database name in your 'create controlfile' script.

> >

> > That makes me worry you may have forgot some other things -like the

> > background_dump_dest, the archive log destination directory and so on.

> >

> > But the proximate cause of the error is the db_name parameter.

> >

> > Regards

> > HJR

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.