RE: Listening on specific ports

[Mercadante, Thomas F]

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-----
From: Michael Kline [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Listening on specific ports

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: [EMAIL PROTECTED] Web: www.b2bsol.com