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