Re: Help on multi-Instance on a server

From: <mouyang_at_hotmail.com>
Date: 1997/10/16
Message-ID: <876968449.21530@dejanews.com>#1/1

Hi Mr.Wall:
Thank you for your help.
I modified the listener.ora same as you said, and I set the tnsnames.ora correctly using sqlnet conf. tool, but I cannot connect to the instance "test", the error messages are:"ORACLE not available" and "smsget: error attaching to SGA".
In NT instance manager window, the status of "test" is: Services started
Instance stopped
so I think where the rub is. But I cannot start up the instance "test", such as using svrmgr. I need further help. Thanks.

M. Ouyang

P.S. my tnsnames.ora :

################
# 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=


          (PROTOCOL= IPC)

          (KEY= TEST.world)

        )
        (ADDRESS=


          (PROTOCOL= IPC)

          (KEY= TEST)

        )
        (ADDRESS=


          (COMMUNITY= NMP.world)

          (PROTOCOL= NMP)

          (SERVER= EDU)

          (PIPE= ORAPIPE)

        )
        (ADDRESS=


          (COMMUNITY= TCP.world)

          (PROTOCOL= TCP)

          (Host= edu)

          (Port= 1521)

        )
        (ADDRESS=


          (COMMUNITY= TCP.world)

          (PROTOCOL= TCP)

          (Host= edu)

          (Port= 1526)

        )
        (ADDRESS=


          (COMMUNITY= SPX.world)

          (PROTOCOL= SPX)

          (Service= edu_lsnr)

        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (SID_NAME = TEST)
    )
  )
PASSWORDS_LISTENER = (oracle)

In article <622dvs$3bt_at_news9.noc.netcom.net>,   "Craig M. Wall" <cwall_at_petersons.com> wrote:

>
>
> 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...
>

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

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