SQL*NET listens on more than one IP(n20)


How do I configure SQL*NET listener to listen on more than 1 IP address on NT4.0??


Ans:

You do it the same way on NT as on all other platforms --- with additional
entries in listener.ora.

################
# Filename......: listener.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=
          (PROTOCOL= IPC)
          (KEY= oracle.world)
        )
        (ADDRESS=
          (PROTOCOL= IPC)
          (KEY= ORC1)
        )
        (ADDRESS=
          (COMMUNITY= NMP.world)
          (PROTOCOL= NMP)
          (SERVER= ServerName)
          (PIPE= ORAPIPE)
        )
        (ADDRESS=
          (PROTOCOL= TCP)
          (Host= SecondIPAddress)
          (Port= 1521)
        )
        (ADDRESS=
          (PROTOCOL= TCP)
          (Host= SecondIPAddress)
          (Port= 1526)
        )
        (ADDRESS=
          (PROTOCOL= TCP)
          (Host= 10.0.0.1)
          (Port= 1521)
        )
        (ADDRESS=
          (PROTOCOL= TCP)
          (Host= 10.0.0.1)
          (Port= 1526)
        )
        (ADDRESS=
          (PROTOCOL= TCP)
          (Host= 127.0.0.1)
          (Port= 1521)
        )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ServerName)
      (SID_NAME = ORC1)
    )
    (SID_DESC =
      (SID_NAME = extproc)
      (PROGRAM=extproc)
    )
  )
PASSWORDS_LISTENER = (oracle)

Use this example to carefully modify your
%OracleHome%\Net80\Admin\listener.ora file AFTER you've made a Backup Copy
of it !!!

Mike Rose
 
 
 
 

Hosted by www.Geocities.ws

1