Re: Help on multi-Instance on a server

From: Craig M. Wall <cwall_at_petersons.com>
Date: 1997/10/23
Message-ID: <62msug$rc0$1i@195.26.68.19>#1/1

IF you have modified tnsnames.ora correctly on your client, you must also modify oracle_home\network\admin\listener.ora to include the new instance parameters then stop and restart the listener service. Crude example follows...

################
# Filename......: listener.ora
# Name..........: Saturn.world

# Date..........: 16-JUN-97 16:44:28

################

LISTENER =
(ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL=IPC)

          (KEY= rep.world)

        )
        (ADDRESS=


          (PROTOCOL=IPC)

          (KEY= rep)

        )
        (ADDRESS=


          (PROTOCOL=IPC)

          (KEY= tst.world)

        )
        (ADDRESS=


          (PROTOCOL=IPC)

          (KEY= tst)

        )
        (ADDRESS =


          (COMMUNITY = TCP.world)

          (PROTOCOL = TCP)

          (Host = 204.32.80.14)

          (Port = 1521)

        )
        (ADDRESS =


          (COMMUNITY = TCP.world)

          (PROTOCOL = TCP)

          (Host = 204.32.80.14)

          (Port = 1526)

        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = rep)
    )
    (SID_DESC =
      (SID_NAME = tst)
    )
  )
PASSWORDS_LISTENER = (oracle)

Craig M. Wall

mouyang_at_hotmail.com wrote in message <876906227.25215_at_dejanews.com>...

>Hi,
>I used NT instance manager create an instance and database, and the
>serveice of that can start but I cannot start up the instance. How
>should I do?
>And , after setting the sql*net, I cannot conect to the new instance,
>it tells me "tns:listener could not resolve SID given...", I think
>I hvae set the SID in sql*net conf rightly. What's the reason?
>Thanks for any help.
>
>Ming Ouyang
>
>-------------------==== Posted via Deja News ====-----------------------
>      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Thu Oct 23 1997 - 00:00:00 CDT