Re: Two Versions of Oracle / Common Database Access

"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
******************************************