RE: Multiple Homes and CONNECT

From: Juan miradna <jmirandavigo_at_hotmail.com>
Date: 2000/06/27
Message-ID: <8jamao$q801@cesio.mundo-r.com>#1/1

Hello Joseph:
I has this problem. I has 2 instances and I can´t connect to one. You must create the instance alias with SQL Net easy and then change the listener file (in c:\orant\network\listener.ora) Then you must shutdown the PC.

This listener.ora work´s for me:

SQLNET.AUTHENTICATION_SERVICES = (NONE)
USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL=IPC)

          (KEY= gal.world)

        )
        (ADDRESS=


          (PROTOCOL=IPC)

          (KEY= GAL)

        )
        (ADDRESS =


          (COMMUNITY = TCP.world)

          (PROTOCOL = TCP)

          (Host = cor0000s004)

          (Port = 1521)

        )

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

      (GLOBAL_DBNAME = gal.world)
      (SID_NAME = GAL)
      (PRESPAWN_MAX = 10)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = Test.world)
      (SID_NAME = Test)
      (PRESPAWN_MAX = 10)

    )
  )

I add the last part SID_DESC ....

    Good look

Joseph Morales <joseph.morales_at_unisys.com> escribió en el mensaje de noticias 8j90rq$i6o$1_at_mail.pl.unisys.com...

> I have two (Oracle 8.1) Oracle Homes on my system, and I'm having trouble
> connecting to the second one in Server Manager. I haven't yet disabled any
> of the default user IDs. For the first Oracle Home, I can connect with
>
>     connect interal/oracle_at_oracle
>
> For the second Oracle Home, I have an instance with an SID of Two, so I
> tried
>
>     connect interna/oracle_at_two
>
> But this didn't work. Is there some special syntax trick for making this
> connection?
>
> Thanks in advance for any suggestions.
>
> Joseph Morales
>
>

Received on Tue Jun 27 2000 - 00:00:00 CDT