Re: Oracle7.3.4. listener and Oracle8.0.4 listener on the same machi ne

--0-719885386-960824910=:4910
Content-Type: text/plain; charset=us-ascii

 It can be done. The listeners need to be in separate oracle home directories, listening on different ports and different IPC keys. Make sure if you use a TNS_ADMIN environment variable that it's set differently when you start the two listeners so they do indeed use the separate listener.ora files.

Out of curiousity, why do you want to run 2 listeners? Normally if I have multiple versions of the database software, I use one listener to support them all - the more recent one.  

"Boivin, Patrice J" wrote:

I have both versions on my workstation, and haven't used the Oracle7 TNSListener service for quite some time because it returns an internal error when I try to start it up.

When I called Oracle, they informed me it was because both listeners try to latch on to the same ports (1521, 1526).

Has anyone tried creating two separate listener.ora files on one machine, one with all 1521 and one with 1526? Any problems?

What about IPC, can both listeners connect to IPC? (I don't know much about IPC). Any ramifications in the future, esp. when we move to 8.1.6.?

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

--
Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). 




---------------------------------
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
--0-719885386-960824910=:4910
Content-Type: text/html; charset=us-ascii



<P> It can be done. The listeners need to be in separate oracle home directories, listening on different ports and different IPC keys. Make sure if you use a TNS_ADMIN environment variable that it's set differently when you start the two listeners so they do indeed use the separate listener.ora files.</P>

<P>Out of curiousity, why do you want to run 2 listeners? Normally if I have multiple versions of the database software, I use one listener to support them all - the more recent one.</P>

<P>&nbsp;<BR><B><I>"Boivin, Patrice J" <BOIVINP_at_MAR.DFO-MPO.GC.CA></I></B>wrote: <BR></P>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><BR>I have both versions on my workstation, and haven't used the Oracle7<BR>TNSListener service for quite some time because it returns an internal error<BR>when I try to start it up.<BR><BR>When I called Oracle, they informed me it was because both listeners try to<BR>latch on to the same ports (1521, 1526).<BR><BR>Has anyone tried creating two separate listener.ora files on one machine,<BR>one with all 1521 and one with 1526? Any problems?<BR><BR>What about IPC, can both listeners connect to IPC? (I don't know much about<BR>IPC).<BR><BR>Any ramifications in the future, esp. when we move to 8.1.6.?<BR><BR>TIA<BR>Patrice Boivin<BR>Systems Analyst (Oracle Certified DBA)<BR><BR>Systems Admin &amp; Operations | Admin. et Exploit. des systèmes<BR>Technology Services | Services technologiques<BR>Informatics Branch | Direction de l'informatique <BR>Maritimes Region, DFO | Région des Maritimes, MPO!

<BR><BR>E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <?xml:namespace prefix = mailto /><mailto:boivinp_at_mar.dfo-mpo.gc.ca><BR><BR>--<BR>Author: Boivin, Patrice J<BR>INET: BoivinP_at_mar.dfo-mpo.gc.ca<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing). <BR></BLOCKQUOTE><BR></mailto:boivinp_at_mar.dfo-mpo.gc.ca><p><br><hr size=1><b>Do You Yahoo!?</b><br>

<a href="http://photos.yahoo.com/">Yahoo! Photos</a> -- now, 100 FREE prints!