Re: need for multiple listeners?

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 11 Nov 2004 01:53:55 GMT
Message-ID: <TCzkd.20009$6q2.19103@newssvr14.news.prodigy.com>

Sybrand Bakker wrote:
> On Wed, 10 Nov 2004 15:32:00 -0600, "Phillip"
> <damack_at_alumni.utexas.net> wrote:
>
>

>>Hello,
>>
>>our environment has it where there are multiple versions of Oracle (8i and
>>9i) databases residing on the same server.  I was wondering if there was a
>>technical/functional *need* to have multiple listeners running, or will a
>>single listener do?

[...]

> As far as I am concerned I never saw a need. Just set up the listener
> for the most recent version of the software.
> However, if you have a big version gap, you may find that you need to
> set up both versions
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

IIRC, the Oracle 8i RDBMS does not auto-register with the Oracle 9i listener, so you will want a listener.ora file to specify the 8i connect information for the 9i listener.

--Mark Bole Received on Wed Nov 10 2004 - 19:53:55 CST