Re: NT Database Instance Recreation

The Oracle service can be recreated by going into a dos-box on the server and issuing the command
oradim80 -new -sid <your sid> -password <the password of internal> -pfile <full path to your init.ora>
This will NOT create a new database, it will create the service only. For exact parameters (I missed out a few relatively unimportant) type oradim80 -?

Hth,

--
Sybrand Bakker, Oracle DBA

Jeremy Ovenden <jovenden_at_hazelweb.co.uk> wrote in message news:7siv03$mpb$1_at_gxsn.com...
> Due to an NT catastrophe, the registry got corrupted and had to be
restored.
> The restored registry pre-dates the installation of an Oracle 8.0.5
> database....as all the data files, configuration files, oracle excutanles
> etc are all still on the system, is there a way of simply recreating the
> service definitions and how is it done?
>
> I tried creating a new database and then simply replacing the newly
> generated initorc0.ora file with my original, but obviously its a little
> more complex than tha as afterwards I received ORA-01223 and ORA-12500
> errors (having attempted to juggle with the tnsnames.ora for a while).
>
> Pls help if you can.
>
> Ta
>
> Jeremy Ovenden
> HazelWeb Systems
> UK
>
>
Received on Sat Sep 25 1999 - 12:10:08 CDT