Re: SQL*NET to listen on more than one IP address

From: Mike Rose <mmrose_at_home.com>
Date: Fri, 23 Apr 1999 03:28:43 GMT
Message-ID: <LNRT2.3829$h72.893@news.rdc1.md.home.com>

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

mmrose_at_home.com

Steve Jelfs <s.jelfs_at_btinternet.com> wrote in message news:7fo8bu$32c$1_at_mendelevium.btinternet.com...

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

Received on Thu Apr 22 1999 - 22:28:43 CDT