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: Two Versions of Oracle / Common Database Access

Re: Two Versions of Oracle / Common Database Access

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Tue, 24 Sep 2002 10:22:27 -0500
Message-ID: <km01pucre12nn6ah0jjan939qh6rgkekv5@4ax.com>


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

Original text of this message

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