Re: 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>.
>

You can re-create these services with ORADIM (from a DOS prompt):

oradim80 -new -sid <sid> intpwd <password> -startmode auto -pfile <full path name of initsid.ora>

Unfortunely, the output of ORADIM is not sent back to the screen put into a file called ORADIM.LOG. You cat find it with the Explorer from your Oracle home directory.

In case I missed any parameter on command, type "oradim80 -?" for help.

When ORADIM.LOG tells you that the services have been created, reboot your machine. If as you said all the Oracle files are intact, your instance should be up and running.

Good luck! (I'd love to know if that works. I did not actually try this out by crashing my PC)

>
> 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 Sat Nov 27 1999 - 17:59:42 CST