listerner config

[ora_inf]

Hi:

I am having a problem with configuring listerner.
I have three database instance on same machine.
Two of the instance uses 8.1.5 oracle and one uses 8.0.5 oracle.

Please let me know how can I configure listerner with two different version of oracle.

Thanks.

[sreddy]

see the listener on my unix box which has 2 versions.
<font face=courier>
LISTENER =
---(ADDRESS_LIST =
--------(ADDRESS =
----------(COMMUNITY = tcpcom.world)
----------(PROTOCOL = TCP)
----------(Host = apps)
----------(Port = 1521)
--------)
---)
SID_LIST_LISTENER =
--(SID_LIST =
----(SID_DESC =
------(GLOBAL_DBNAME = iiip.world)
------(SID_NAME = iiip)
------(ORACLE_HOME = /u01/oracle/product/734)
----)
----(SID_DESC =
------(GLOBAL_DBNAME = caae.world)
------(SID_NAME = caae)
------(ORACLE_HOME = /u01/oracle/product/815)
----)
--)
</font>

[Edited by sreddy on 01-31-2001 at 04:16 PM]

[ora_inf]

Reddy:

Since I have two oracle_home, one for oracle 8.0.5 and one for 8.1.5
so which one should I use? I think due to upward compability, I should use 8.1.5/network/admin
directory.

Thanks,
-Nitesh

[sreddy]

YOu have to use most latest version of Networking. If its 815 use 815 networking. If you have 817 binaries also sitting on it, use 817 networking.

Your $TNS_ADMIN should always point to latest version of Networking for better results.

Whichever version you want to use to go that O_H/network/admin and modify listener.ora and tnsnames.ora as per your requirement.

Make sure, you don't invoke older versions of executables by renaming 'em after you setup for latest version of Networking.

In logical sence, all(8x) use Net8. But, we do this way in our shop, by allowing 734 instances also to use Net8 rather SQL*Net.

[Edited by sreddy on 01-31-2001 at 06:10 PM]

[MJP]

Hmm....This definitely put me in thinking mode. I was always under the impression that the new and latest products have the backward compatibility as against the previous products having upward compatibility. And hence, I have all the different versions of instances looking at the oldest version of the listener and tnsnames files instead of the other way around as said by sreddy. May be I need to try this.

[uddinr]

Use these 2 files as you different version of Oracle running 2 different listeners.
execute this command after changing the $ORACLE_HOME and $ORACLE_SID

lsnrctl start LISTENER

FILE 1:
________________________________________________________

LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcpcom.world)
(PROTOCOL = TCP)
(Host = apps)
(Port = 1521)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = iiq.world)
(SID_NAME = iiq)
(ORACLE_HOME = /u01/oracle/product/734)
)
)
--------------------------------------------------------------------------

lsnrctl start LSNR

FILE 2:
------------------------------------------------------------------------

LSNR =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcpcom.world)
(PROTOCOL = TCP)
(Host = apps)
(Port = 1526)
)
)
SID_LIST_LSNR =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = iiip.world)
(SID_NAME = iiip)
(ORACLE_HOME = /u01/oracle/product/815)
)
)