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

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

-- 
-Stan