Oracle-L: RE: Listening on specific ports

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Mon, 03 Feb 2003 10:59:02 -0800
Message-ID: <F001.0054252B.20030203105902@fatcity.com>

Mike,

the only way that I know of to do this is to run mutiple listeners on your server. you can set-up multiple listeners within your listener.ora file, and assign each one the port you want it to use. you then would need to start each listener separately.

in your case, your listener file could look like:

PROD1_LISTENER =
(DESCRIPTION_LIST=
(DESCRIPTION=

      (ADDRESS_LIST=
        (ADDRESS=


          (PROTOCOL=TCP)

          (HOST=xxxxx)

          (PORT=1521)

        )
      )
      (ADDRESS_LIST=
        (ADDRESS=


          (PROTOCOL=IPC)

          (KEY=EXTPROC0)

        )
      )

)
)

SID_LIST_PROD1_LISTENER =
  (SID_LIST=
    (SID_DESC=
      (SID_NAME=PROD1)
    )
  )

DEVL1_LISTENER =
(DESCRIPTION_LIST=
(DESCRIPTION=

      (ADDRESS_LIST=
        (ADDRESS=


          (PROTOCOL=TCP)

          (HOST=xxxxxx)

          (PORT=1522)

        )
      )
      (ADDRESS_LIST=
        (ADDRESS=


          (PROTOCOL=IPC)

          (KEY=EXTPROC0)

        )
      )

)
)

SID_LIST_DEVL1_LISTENER =
  (SID_LIST=
    (SID_DESC=
      (SID_NAME=DEVL1)
    )
  )

within lsnrctl, you would then need to

start prod1_listener
start devl1_listener
etc.

good luck. the only benefit I see of this approach is that you could take one listener down - thus stopping incoming connections to a database.

good luck

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Monday, February 03, 2003 12:44 PM To: Multiple recipients of list ORACLE-L

Is there an "Easy" way to assign specific tnslistener ports to a specific database?

Let's say I wanted:

1521 to be prod1
1522 to be devl1
1523 to be web1
1524 to be test1

Right now ports are basically assigned to servers which may well be adequate. But I was asked, and it seems that we give a listener ports and databases, but there is no link to make one equal the other.

Also, is there a limit on total number of ports that a listener can be assigned to? In some cases I could find that they could conceivably want to use 10 ports over 15-20 databases? I'm not sure this will be practical.

It's such an unusual concept as usually there are 2-3 "large" databases, and this one server looks like it's a bunch of small databases.

Server is currently Solaris 8, database 8.1.7 all sharing the same ORACLE_HOME.

Thanks.

Michael Alan Kline, Sr.
Principal Consultant
Business to Business Solutions, LLC
Phone: 804-744-1545 Cell: 804-314-6262
ICQ: 1009605, 975313
Email: <mailto:mkline_at_b2bsol.com> mkline_at_b2bsol.com Web: <http://www.b2bsol.com/> www.b2bsol.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Mon Feb 03 2003 - 12:59:02 CST