Xref: alice comp.databases.oracle.server:20318
Path: alice!news-feed.fnsi.net!dca1-hub1.news.digex.net!digex!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com!news1.bellglobal.com!news21.bellglobal.com.POSTED!not-for-mail
From: "Rob Forster" <robertf@inforamp.net>
Subject: Multiple Networks: How to define LISTENER.ORA?
Newsgroups: comp.databases.oracle.server
Organization: TD Bank
Message-ID: <01bd7873$22f3b110$6e6bcd8e@forrer>
X-Newsreader: Microsoft Internet News 4.70.1155
Lines: 24
Date: Tue, 05 May 1998 22:17:35 GMT
NNTP-Posting-Date: Tue, 05 May 1998 18:17:35 EDT

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/trace
TRACE_FILE_TCP_LISTENER=TCP_LISTENER
LOG_DIRECTORY_TCP_LISTENER=/oracle0/oracle7/network/log
LOG_FILE_TCP_LISTENER=TCP_LISTENER