Re: Listener problem with 2 instances on 1 NT server

Hi Derk,

it seems as if you missed to list the PREV Database in the last section Itt schould read like this:

• snip --- SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ORCL) ) (SID_DESC = (SID_NAME = PREV) ) )
• snip ---

After modifying these lines and doing a "lsnrctl reload" from the prompt the listener should listen to both databases.

Hope this helps.

Andreas Stephan

VdWal schrieb:

> I have a problem with connecting to more than one instances on one
> NT-Server.
>
> With SQL-NET easy configuration I can connect with (for example) alias OWS
> to instance ORCL. On the server I have started the listener process for this
> service (instance).
>
> When i modify the listener.ora file I can connect with another alias, (for
> example) named PRV to another Instance named PREV.
> In this situation the listener has started the listening process for
> instance PREV A N D N O T for the instance ORCL.
>
> I want to configure the listener so that it will react on both the alias OWS
> and the alias PRV.
>
> I Think I make a mistake with the last part in the listener.ora file.
> The last part of the file is italic and bold.
>
> Below the contents of this file:
>
> ****************************************************************************
> ********
> ################
>
> # Filename......: listener.ora
>
> # Node..........: local.world
>
> # Date..........: 24-MAY-94 13:23:20
>
> ################
>
> LISTENER =
>
> (ADDRESS_LIST =
>
> (ADDRESS=
>
> (PROTOCOL= IPC)
>
> (KEY= oracle.world)
>
> )
>
> (ADDRESS=
>
> (PROTOCOL= IPC)
>
> (KEY= ORCL)
>
> )
>
> (ADDRESS=
>
> (COMMUNITY= NMP.world)
>
> (PROTOCOL= NMP)
>
> (SERVER= NT-SERVER3)
>
> (PIPE= ORAPIPE)
>
> )
>
> (ADDRESS=
>
> (COMMUNITY= TCP.world)
>
> (Host = nt-server3)
>
> (PROTOCOL= TCP)
>
> (Port= 1521)
>
> )
>
> (ADDRESS=
>
> (COMMUNITY= TCP.world)
>
> (Host = nt-server3)
>
> (PROTOCOL= TCP)
>
> (Port= 1526)
>
> )
>
> )
>
> STARTUP_WAIT_TIME_LISTENER = 0
>
> CONNECT_TIMEOUT_LISTENER = 10
>
> TRACE_LEVEL_LISTENER = ADMIN
>
> SID_LIST_LISTENER =
>
> (SID_LIST =
>
> (SID_DESC =
>
> (SID_NAME = ORCL)
>
> )
>
> )
>
> PASSWORDS_LISTENER = (oracle)
>
> ****************************************************************************
> ********
>
> Please If you know more let me know.
>
> Derk van der Wal
> Geometra
> The Netherlands
> vdwal_at_tref.nl
>
> Background info:
>
> On one Windows NT server (name NT-SERVER3) with Oracle Workgroup Server
> 7.3.3. there are running two SID's. Of both the service and the instance is
> started. The first is called ORCL (default) and the second is called PREV.
>
> I use a small workgroup with some NT-cliënts. On this cliënt I have
> confiugured the connection to the Oracle database with SQL-NET easy
> configuration.
>
> I'm working with the Named Pipes protocol.
Received on Fri Dec 10 1999 - 11:49:44 CET