Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Multiple Networks: How to define LISTENER.ORA?
Our server has one token ring and one network card. I want to be able to
establish SQL*Net connections through either network. How would you define
this in LISTENER.ORA ?
I've attached a vanilla LISTENER.ORA file which you may kindly modify.
TIA,
Rob.
######### # # Listener name = TCP_LISTENER # Created Mon Sep 15 13:05:25 EDT 2000 # by root # ######### TCP_LISTENER= (ADDRESS_LIST= (ADDRESS =
(PROTOCOL = TCP)
(HOST = hostname)
(PORT = 1521)
)) SID_LIST_TCP_LISTENER = (SID_LIST = (SID_DESC =
(SID_NAME = WG73)
(ORACLE_HOME = /oracle0/oracle7)
))
STARTUP_WAIT_TIME_TCP_LISTENER=0
CONNECT_TIMEOUT_TCP_LISTENER=10 TRACE_LEVEL_TCP_LISTENER=ADMIN TRACE_DIRECTORY_TCP_LISTENER=/oracle0/oracle7/network/traceTRACE_FILE_TCP_LISTENER=TCP_LISTENER