Re: Problem Using 2 Oracle Environments with 2 Listeners

From: <sunk_at_focushope.edu>
Date: Thu, 12 Aug 1999 12:01:18 GMT
Message-ID: <7oud2a$vcl$1@nnrp1.deja.com>

In article <37b20ca3.275404440_at_client.nw.news.psi.net>, ccarson_at_phi.org (The Chuckster) wrote:
>
> I have a Solaris 2.6 Server.
>
> I have 2 Complete Oracle 8.0.5 Installations (NOT instances). By this
> I mean Oracle has been installed twice, one server resides under
> /oracle1 and one server resides under /oracle2
>
> I can run the listener in the first environment fine on port 1520
> using the command "lsnrctl start MYNAME1"
>
> When trying to run the listener in the second environment with the
> followig command "lsnrctl start MYNAME2" I get the following error
> from Oracle:
>
> TNS-01106 Listener using listener name MYNAME1 already been started.
>
> If I terminate the listener in the 1st environment, I can start up the
> listener in the 2nd environment without problems.
>
> What am I missing?
>
> -Chuck
>
>

You might want to try this: Use 1 listener and handle 2 service.

I did this in 7.3.3 and pretty sure it works with 8.0.5:

Example:
listener.ora

LISTENER=
(ADDRESS_LIST=
(ADDRESS=

   (COMMUNITY = tcp.com)
   (PROTOCOL = tcp)
   (HOST = tasmania)
   (PORT = 1523)

  )
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 0 SID_LIST_LISTENER=
(SID_LIST=
  (SID_DESC=
   (SID_NAME=dev)
   (ORACLE_HOME=/u01/app/oracle/product/7.3.3.0)   )
  (SID_DESC=
   (SID_NAME=prod)
   (ORACLE_HOME=/u01/app/oracle/product/7.3.3)   )
)

TRACE_LEVEL_LISTENER = OFF
PASSWORD_LISTENER = (9D3ABA0853BBAEC3)

As you can tell I got 2 7.3.3 homes and 1 listener.(I used 7.3.3.0 just distinguish one from the other, tnsnames.ora need to be modified as well)

Hope this will help, Kurt.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 12 1999 - 07:01:18 CDT