Re: How to reinstall Oracle 8.0.5 but use existing DB files?

You may have to change ORACLE_SID with regedit (My Computer\HKEY_LOCAL_MACHINE\SOFTWARE_ORACLE)

Roger

John Haskins <76054.334_at_compuserve.com> schrieb in im Newsbeitrag: 8ADy4.750$bl4.79310_at_dfiatx1-snr1.gtei.net...
> I took the steps you defined, and after they worked I used the Database
> Assistant to delete the ORCL database that was created when I reinstalled
> O8. Then rebooted. There's a small problem, though: somehow the system
> still things ORCL is the default database. Even though I've changed the
> TNSNAMES.ORA file to identify the new SID for the BEQ-LOCAL connection,
 when
> I try to start SQL*Plus on the server and don't specify a host string, I
 get
> the error "TNS:unable to connect to destination". While I can work
 around
> that problem in SQL*Plus by specifying a host string, the problem also
> exists in Server Manager, and it isn't so easy to work around
> there...resulting in my not being able to startup a database after I've
 shut
> it down.
>
> Any thoughts on what else I need to do to make Oracle understand that its
> old default database is gone, and it needs to use the new one?
>
> I'm amazed that the Database Wizard didn't handle this properly. Guess I
> shouldn't be.
>
> Thanks again.
>
Received on Sun Mar 12 2000 - 00:00:00 CST