Re: Oracle Listener
From: Naren Chintala <naren_at_mink.att.com>
Date: 1996/09/10
Message-ID: <323598D8.41CF_at_mink.att.com>#1/1
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
LOG_DIRECTORY_LISTENER = /var/opt/oracle LOG_FILE_LISTENER=LISTlog.log
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
)
Date: 1996/09/10
Message-ID: <323598D8.41CF_at_mink.att.com>#1/1
Minh Giang,
The following works for me. Let me know if you have any problems.
Naren Chintala
naren_at_mink.att.com
listener.ora
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = alias1)
(PORT = 1521)
) (ADDRESS =
(PROTOCOL = TCP)
(HOST = alias2)
(PORT = 1526)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
LOG_DIRECTORY_LISTENER = /var/opt/oracle LOG_FILE_LISTENER=LISTlog.log
TRACE_LEVEL_LISTENER = off TRACE_DIRECTORY_LISTENER = /var/opt/oracle TRACE_FILE_LISTENER=LISTtrace.log
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = abc) (ORACLE_HOME = /opt/oracle/product/7.2.3))
)
Minh Giang wrote:
> > Hi, > > Here is the situation: I've 2 groups of users connecting to a HP > machine thru different routers and ip address. This is an example of > the /etc/hosts file looks like. > > 127.0.0.1 localhost loopback > 123.4.5.67 alias1 hpG50 #comments > .. > .. > 321.7.3.76 alias2 alias1 #comments > > So, anyone who is connected using alias1 or alias2 will be connected to > the save HP server. > > Currently, the LISTENER.ORA looks something like this: > > # LISTENER is the default listener alias > LISTENER = (ADDRESS=(PROTOCOL=tcp)(HOST=alias1)(PORT=1521) > .. > .. > sid_list_listener = > (SID_LIST=(SID_DESC=(SID_NAME=abc)(ORACLE_HOME=/ora7))) > > With the above listener start, only the group of users connecting via > sqlnet v2 using alias1 can log on to the Oracle instance abc. The group > going thru alias2 keeps getting time-out error. > > What doing I need to change in LISTENER.ORA so that there will be > listening services for host alias1 and alias2? > > Thanks in advance, > Minh Giang > mpg_at_fast.netReceived on Tue Sep 10 1996 - 00:00:00 CEST