Re: TCP/IP Port for the listener

From: Scott Cote <scottcote_at_contractor.net>
Date: Fri, 10 Jul 1998 09:07:51 -0500
Message-ID: <35A62037.27C18825@contractor.net>

As Mr. Schnaider points out, you need to have a good reason to do what I described.
Example: A compelling need to run two different versions of Oracle SQLNET .

I can't think of any other examples.

If you don't have a need, just setup a single listener to handle both instances. If you have Oracle 8 for NT, try using the Net8 Assistant (not the same as easy config).

Here is a sample listener file for two instances running on NT:

# C:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:C:\orant\net80\admin\listener.ora
# Generated by Oracle Net8 Assistant

PASSWORDS_LISTENER= (oracle)

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = datarx_1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) )

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME = oem)
      (ORACLE_HOME = \orant)
      (SID_NAME = oem)

)
(SID_DESC =

      (GLOBAL_DBNAME = whd)
      (ORACLE_HOME = \orant)
      (SID_NAME = whd)

)
)
#end of file

Now you might need a different sqlnet config, so make sure that you read the sqlnet documentation. If you have a CSI # for silver support, call oracle for help if you cannot find the proper documentation (hint: check for the help on CD if you don't have paper).

SCott

Scott Cote wrote:

> I know that you can setup sqlnet so that two listeners can run on the same
> host.

> listener1 listens on 1521 (standard) feeding instance 1
> listener2 listens on 1525 (non-standard) feeding instance 2

> SCott

> dov_shnaider_at_my-dejanews.com wrote:

>


> > Hi, Is there a way to make the listener listen on two different TCP/IP port


> > for two different instances (SID) installed on the same machine ? ( so each


> > instance will have a port for itself )


> >


> > Thanks


> >

> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Jul 10 1998 - 09:07:51 CDT