How to recreate oracle instance services after reinstall of NT ?

I had the misfortune of having my NT box chrash this morning. It did not like an updated driver and there was no other way than to reinstall NT.

This of course means that all the registry settings are lost, including oracle settings, service definitions and so forth.

Now I have reinstalled NT 4.0, applied service pack 5 and reinstalled the driver. No problems this time arround. Then I reinstalled Oracle Enterprice edition 8.0.4.0.0 (dont need the patches).

But now I dont know how to bring my database back to life. I have all the files, controll files, log files, data files, init.ora files and so forth. Including the start and stop scripts.

But I do not have the two service definitions: OracleService<SID> and OracleStart<SID>.

I do have the original scripts I used to generate the database with, and could just let the machine chew on these for a few hours to build an empty database.

But I dont like the idea, there should be a relatively simple way to get this up and running again without having to turf the contents of the databae and build a new one from scratch.

There will not be an awfull lot of work lost by recreating the database, but i surely hate not knowing how to save this situation.

Had this been a unix installation the problem would newer have occured. One would just boot from an old kernal-image and recreate the damaged one. And even If one had to reinstall the operating system the database setup would not have been damaged.

I do not beleive that this situation cannot be rescued, imagine that this had been one of our customer installations. With paralel oracle in a cluster setup, partitioned tables and arrount 100 GB of data. I start sweating when I imagine that a failed driver installation here would mean that the entire cluster, including database would have to be recreated.
I am not responsible for these setups, but since I develop for them I like to keep on top of the technology that drives them.

I hope somebody here can help, if possible pointing me at the proper documentation or other sources of information. I am in this to learn, how to be able to employ this technology in the customers best interest.

(I shouldnt wonder if creative use of oradim80.exe could do the trick).

Greetings from Denmark

Jesper Wolf Jespersen jwj_at_dde.dk

PS. When you post a followup to this, please mail me a copy. I may miss the posting. Received on Thu Nov 25 1999 - 15:49:24 CST