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

Great catch. It was in two other places in the registry as well.

Thanks.

Roger <NOrgSPAM_at_mcs-hh.de> wrote in message news:8agpvt$e5j$1_at_opal.hamburg.cityline.net...
> 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 Mon Mar 13 2000 - 00:00:00 CST