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

[Shreepad . Vaidya]

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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).