Re: ORA- 12505

From: Zdenka Spoljaric <928330N_at_KNOTES.KODAK.COM>
Date: 1997/12/10
Message-ID: <348F005B.8055FE28@KNOTES.KODAK.COM>#1/1

This is TNSNAMES.ORA with the definition of the second instance running on the same server

2:tst.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = beq.world)

          (PROTOCOL = BEQ)

          (PROGRAM = oracle73)

          (ARGV0 = oracle73ORCL)

          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')

        )

    )
    (CONNECT_DATA = (SID = tst)
    )
  )

To connect to the second instance Using Server Manager do this:

set instance 2:tst
connect internal

.
.
.

The client will access this instance in the same way,... 2:tst

Good luck !

nimk_at_hotmail.com wrote:

> I have Oracle 7.2 running on NT 3.51. I two have two databases, ORCL
> and DEVL.  I created the DEVL database via the Instance manager.
> When I set the SID in the registry I have no problems connecting
> to either databases.  However when I try to the 16-Bit database tools
> I can only connect to the ORCL database.  When I try to connect
> via SQL*PLUS 3.1, I get ORA-12505, error message.  I also get the same
> problem using Server Manager 2.1.  I have checked the that the listener
> processes are running.  I also used the TNSPING utility to check that the
> aliases as correct.
>
> I would appreciate as solution for this problem.
>
> Thanks.
>
> -------------------==== Posted via Deja News ====-----------------------
>       http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Wed Dec 10 1997 - 00:00:00 CST