Re: how can listener list on two ports for the same db?

From: <Shreepad.Vaidya_at_alltel.com>
Date: Thu, 30 May 2002 05:54:02 -0800
Message-ID: <F001.0046F64A.20020530055402@fatcity.com>

Hi Helmut ,
I will try to clarify using an example.

                  Tnsnames.ora

ghi100 =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = <your IP address of the server where database resides> )

          (Port = 1526)

        )

    )
    (CONNECT_DATA = (SID = ghi100)
    )
  )

ghi101 =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host =<your IP address of the server where database resides> )

          (Port = 1521)

        )

    )
    (CONNECT_DATA = (SID = ghi100)
    )
  )

      In this example  i have 2 connection strings (ghi100,ghi101)
connecting through 2 different ports                  (1521,1526) to the
same database .
            Also ensure that you add the ports(1521,1526)  in /etc/services

on the server (Unix based) .

            Listener.ora

LISTENER =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host=<your server ip address > )(Port=

1526))
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= hildb1.%domain_name%)
      (ORACLE_HOME= /opt/oracle/app/oracle/product/7.3.3)
      (SID_NAME = ghi100)
          )

  )

LISTENER0 =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= TCP)(Host=<your server ip address >)(Port= 1521))
  )
SID_LIST_LISTENER0 =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= hildb1.%domain_name%)
      (ORACLE_HOME= /opt/oracle/app/oracle/product/7.3.3)
      (SID_NAME = ghi100)

    )
  )

            There are two listener's LISTENER and LISTENER0 . You would have to start the listener's seperately.

      Especially check /etc/services for the entries and check if you have seperate listener names in listener.ora

      Hope this helps .

            shreepad

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Shreepad.Vaidya_at_alltel.com

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).

Received on Thu May 30 2002 - 08:54:02 CDT