Re: NT Database Instance Recreation

You're right about backups! There's no greater teacher than experience though!

I have reinstalled oracle s/w, taking care to preserve all existing datafiles, config files etc etc, and am having trouble actually getting the thing to run.

I followed Sybrand Bakker's advice of using oradim80 to create the new services, I subsequently added a new alias to the tnsnames file (2 entries in fact (diff aliases) for the database, in order to test the BEQ and TCP/IP connection methods) and am still unable to connect.

I started the instance and checked under control panel services, appears fine.

Tried to startup the database using svrmgr30 but get an oracle ora-01034 when issue the 'startup nomount' instruction.

I am ata loss as to what to do next! so any help, greatly appreciated......

cheers
jeremy

David Sisk wrote in message ...
>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 Mon Sep 27 1999 - 12:51:49 CDT