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: Can I point a 9.0 listener to a 9.2 database?

Re: Can I point a 9.0 listener to a 9.2 database?

From: Frank <fvanbortel_at_netscape.net>
Date: Mon, 03 Mar 2003 20:50:43 +0100
Message-ID: <3E63B213.6020108@netscape.net>


Stan wrote:
> Absolutely you can have 9.0 listener to point to 9.2 database. All you
> need to do is change 9.0 listener.ora file to point 9.2 ORACLE_HOME and
> reload the listener.
>
> for. eg.
> ....
> SID_LIST_LISTENER
> (SID_LIST =
> (SID_DESC=
> (GLOBAL_DBNAME = oracle)
> (ORACLE_HOME = 9.2_oracle_home)
> (SERVICE_NAME = ORCL)
> )
> )
>
> But, it better to configure 9.2 listener and have 9.0 database point
> from here.
>
> David Trusty wrote:
>

>> Hi,
>>
>> I have a database that I have exported from 9.0 and imported to 9.2.
>>
>> I want a set of Java clients (using the jdbc thin driver) to be unaware
>> of this change.
>>
>> There are several 9.0 databases still on the machine that I want to stay
>> in version 9.0 for a while yet.
>>
>> Is there some way that I can use my 9.0 listener to point to the 9.2
>> database?
>>
>> Thanks in advance!!
>>
>> David

>
>
>

... and hope they do not use jdbc (machine:port:sid) connects?

-- 
Regards, Frank van Bortel
Received on Mon Mar 03 2003 - 13:50:43 CST

Original text of this message

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