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


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.net
Received on Tue Sep 10 1996 - 00:00:00 CEST

Original text of this message