Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to reinstall Oracle 8.0.5 but use existing DB files?

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

From: John Haskins <76054.334_at_compuserve.com>
Date: 2000/03/12
Message-ID: <8ADy4.750$bl4.79310@dfiatx1-snr1.gtei.net>#1/1

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.

Valentin Mînzatu <mvali_at_rds.ro> wrote in message news:n9nx4.2$pm6.339_at_nreader1.kpnqwest.net...
> First of all you need to create a new instance. After that you should
> shutdown that instance and remove all of its files. After that you should
> copy your instanceless files in their place and startup the instance.
>
> Attention, if your prevoius files compound a altered database you could
 not
> manage to use it.
>
> Good luck,
> Valentin Mînzatu
> Oracle Programmer (http://www.brainbench.com/transcript.jsp?pid=130633)
>
> John Haskins <76054.334_at_compuserve.com> wrote in message
> news:fHmx4.1206$ct3.308700_at_dfiatx1-snr1.gtei.net...
> > Greetings, experienced Oracle mavens:
> >
> > My Oracle installation got corrupted to the point that I had to wipe the
> > installation (except ORACLE_HOME\DATABASE) and re-install it from
 scratch.
> > (NT4, O8.0.5) The reinstall succeeded. Now I would like to reinstate
 my
> > prior database files so that the actual database reappears and the prior
> > data is present. If someone could point me in the right direction for
 that,
> > I'd be very grateful.
> >
> > Thanks.
> >
> >
>
>
Received on Sun Mar 12 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US