Re: Multiple instances with NT

The main part of your task is to recreate the control file. To do this (in UNIX and NT) you must first delete
or rename existing control files for that instance otherwise you will get the message below

>ORA-01503: CREATE CONTROLFILE failed
>ORA-00200: cannot create control file 'C:\ORANT\DATABASE\ctl1orcl.ctl'
>ORA-09200: sfccf: error creating file
>OSD-04010: <create> option specified, file already exists

Alex

Tony Adolph wrote in message <7li2sk$82d$1_at_nnrp1.deja.com>...
>Hello and thanks to Alex and Sybrand,
>
>You feedback was interesting but not very useful unfortunatey.
>
>My attempt to rename the database failed. I changed the name in the
>pfile to the new name and edited the backed up control file trace to
>read:
>
>CREATE CONTROLFILE set DATABASE "newdb" RESETLOGS NOARCHIVELOG
> MAXLOGFILES 32
> ........etc etc
>
>then I get:
>
>CREATE CONTROLFILE set DATABASE "newdb" RESETLOGS NOARCHIVELOG
>*
>ORA-01503: CREATE CONTROLFILE failed
>ORA-00200: cannot create control file 'C:\ORANT\DATABASE\ctl1orcl.ctl'
>ORA-09200: sfccf: error creating file
>OSD-04010: <create> option specified, file already exists
>
>All I want to do in the end is to use the datafiles and associated
>files that are the database on a server and with them create mulitple
>instances on an onther server. This is enable test teams to a database
>each. Obviously the SID must be different for each db, eg "test1db",
>"test2db" etc.
>
>I can copy the files and start one database, but to start another I
>must first rename it, hence my previous posting.
>
>Also, Folks, if I eventually do get >1 databases running when I connect
>internal from svrgmr which will I connect to. Do I need to start the
>listener and then connect via an alias in tnsnames?
>
>I come from a Unix background and so have little or no concept of NT
>services. I reckon that I need a service for each SID, but I'm not
>sure about how this all works. When I try to create a new service (via
>Instance Manager) to match the new SID it complains that the datafiles
>for the new SID already exist (which of course they do!). I think I
>may be in a chicken and egg situation here!
>
>Any (further) poitners would be very much appreciated
>Regards
>
>Tony Adolph
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Jul 02 1999 - 06:16:41 CDT