Re: How to connect 2 instance?

From: <xsun1913_at_my-dejanews.com>
Date: Mon, 02 Nov 1998 16:41:31 GMT
Message-ID: <71knbs$vqp$1@nnrp1.dejanews.com>

In article <3646273d.7625254_at_news.twsc.pouchen.com.tw>,   violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
> Hello,
> If I have 2 instances on NT with 2

services:OracleServiceORA1,OracleServiceORA2,
> (instances were created by oradim.exe
> and I don't want to set ORACLE_SID in REGEDIT)
>
> should I start 2 Listener Services on control pannel(OracleTNSListener)?
> How to config 2 listener services on listener.ora?
> Is 1 Listener service enough?
> How to config the listener.ora?
>
> And how to start / stop each listener?
> Could you give me any solution?

You need one listener server on NT. You could start and stop the service from control panel or from the DOS prompt. The following is an example of listener.ora:

LISTENER =
  (ADDRESS_LIST =

       (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= PROD)
        )
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= ORCL)
        )
        (COMMUNITY=TCP.world)
        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = some_nt_server)
          (Port = 1526)
        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 30
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = PROD.world)
      (SID_NAME = PROD)
      (ORACLE_HOME = C:\ORANT)
      (PRESPAWN_MAX = 10)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = ORCL.world)
      (SID_NAME = ORCL)
      (ORACLE_HOME = C:\ORANT)
      (PRESPAWN_MAX = 10)

    )

 )

---

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 02 1998 - 10:41:31 CST