Re: Two Versions of Oracle / Common Database Access

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<3d8dbc83$0$1289$cc9e4d1f_at_news.dial.pipex.com>...
> "B. Kloppt" <b_kloppt_at_my-deja.com> wrote in message
> news:3717b54f.0209220407.51a3dc2f_at_posting.google.com...
> > hi karsten,
> >
> > thanks for your reply.
> >
> > Karsten Farell <kfarrell_at_medimpact.com> wrote in message
> news:<sjLi9.1189$%C1.32123946_at_newssvr13.news.prodigy.com>...
> > > I don't know if I'm interpreting your post correctly. If all you want to
> > > do is to use the 9.2.0 software to access the 9.0.1 database, I think
> > > you just have to change ORACLE_HOME.
> >
> >
> > this is exactly what i wish to do. however, just resetting the
> > ORACLE_HOME variable (and all the others, for that matter) to the
> > 9.2.0 version does not allow me to access my 9.0.1 databases.
> > there must be something else i'm not doing. please note that all i
> > have done was to install the 9.2.0 software, and that's it. i haven't
> > done any kind of database creation under the 9.2.0 version whatsoever.
> > i simply want to use the 9.2.0 to access the databases in 9.0.1 and
> > eventually i will uninstall the 9.0.1.
>
> You'll need to setup your networking configuration so that you can access
> the databases using your naming methods. If I guess that you are using
> tnsnames as a naming method by far the simplest thing to do would be to copy
> the tnsnames.ora and sqlnet.ora from your 9.0.2 home to your 9.2 home
> (obviously backup any files you replace first of all)
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************

hi niall,

that is exactly where the problem was!
after copying $ORACLE_HOME/product/9.0.1/network/admin/tnsnames.ora to the $ORACLE_HOME/product/9.2.0/network/admin/ directory, i was able to access the databases.

thanks for your help!

cheers,
b. Received on Mon Sep 23 2002 - 12:38:59 CDT