Just as an additional note:
If you want to access the DATA in the 9.0.1 while connected to the 9.2.0 ( or vice versa) treat the other version as a remote
database and create a database link for it..That way you can easily access and move data between the 2 instances ...
b_kloppt_at_my-deja.com (B. Kloppt) wrote:
>"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.
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
Received on Tue Sep 24 2002 - 10:22:27 CDT
