Re: NT Database Instance Recreation

Hi:

1. Backup your registry periodically (as well as everything else). There is simply no excuse for not having a valid backup. You can manually "backup" the registry by using regedit to export the registry, then copy this file off to tape or another server.
2. Like most data, if you registry entries are gone and were not backed up, then they're, well, gone. You'll have to reinstall the Oracle software. Be careful to not overwrite your existing database files while you do this (hint: get a backup first...)

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original modern rock? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult
Raleigh music compilation! All $$$ go to NC Food Bank. http://www.mp3.com/whisper2ascream

Jeremy Ovenden wrote in message <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 Sun Sep 26 1999 - 20:02:57 CDT