Re: 2 Oralcle Environments, problem getting both listeners to work

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 28 Jul 1999 12:56:19 -0400
Message-ID: <7nnclo$3tm$1@autumn.news.rcn.net>

This message was emailed to Chuck at
<379f2fca.880075591_at_client.sw.news.psi.net>...
>

Hi Chuck,

For what it's worth here is a listener.ora file we have running on a box with two instances (WG73 and SWDT)

316$ cat listener.ora

#################################################################
#######
# Server:    andor.hbsrx.com
# Filename:  ORACLE_HOME/network/admin/listener.ora
# Note:      built from the template file listener.ora.tmpl
# Node:      local.world
# Date:      07/18/1997
#################################################################

#######
TCP_LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=
          (COMMUNITY= TCP.world)
          (PROTOCOL= TCP)
          (Host = andor.hbsrx.com)
          (Port= 1521)
        )
        (ADDRESS=
          (COMMUNITY= TCP.world)
          (PROTOCOL= TCP)
          (Host = andor.hbsrx.com)
          (Port= 1526)
        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_TCP_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = WG73)
      (ORACLE_HOME = /rx/app/oracle/wgs)

    )
  )
#PASSWORDS_LISTENER = (oracle7)

SWDT_LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=
          (COMMUNITY= TCP.world)
          (Host = andor.hbsrx.com)
          (Port= 1522)
        )
        (ADDRESS=
          (COMMUNITY= TCP.world)
          (PROTOCOL= TCP)
          (Host = andor.hbsrx.com)
          (Port= 1527)
        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_SWDT_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = SWDT)
      (ORACLE_HOME = /rx/app/oracle/wgs)

    )
  )
#PASSWORDS_LISTENER = (oracle7)

We start the listeners separately using the commands:

    lsnrctl start tcp_listener
    lsnrctl start swdt_listener

regards
Jerry Gitomer

---

Chuck wrote in message
<379f2fca.880075591_at_client.sw.news.psi.net>...
>
>I have two separate Oracle installations on a single box and can
>run the listener fine in the first environment. (I have this one
>running on port 1520)
>
>The second envrionment gives me this error when trying the
following
>command:
>
>lsnrctl start
>TNS-01106:Listener using listener name LISTENER has already been
>started.
>
>In the listener.ora file in the 2nd environment, I changed the
>LISTENER to LISTENER2 and am also trying to use port
>1521.
>
>
>Any ideas?
>
>
>Thanks,
>CHuck
>
Received on Wed Jul 28 1999 - 11:56:19 CDT