Re: **HELP** SQL*Net w/ multiple instances

From: <alanlee1_at_my-dejanews.com>
Date: 1998/07/07
Message-ID: <6ntdkb$5vr$1@nnrp1.dejanews.com>#1/1

The listener.ora is located at /orant/network/admin and you must append the new SID to it. Try to modify the file like below

  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (SID_NAME = PROD)
    )
  )

Also, you have to modify all your TNSNAME.ORA on all your client to reflect the new SID.

Hope this helps.

Alan Lee
BSI Consulting
Houston, Texas

In article <6nt8cl$u81$1_at_nnrp1.dejanews.com>, meyer_b_at_rocketmail.com wrote:
>
> HELP!
>
> I need to run two instances of Oracle Workgroup Server 7.3.3.3 on an NT 4.0
> box, at least temporarily. I've succesfully created the second installation
> (SID=PROD), but I can't connect to it. I've used SQL*Net Easy config to
> assign a database alias, but SQL*Net still doesn't see it.
>
> My TNSNames.ORA and Listener.ORA files have references only to the original
> instance (ORCL). How can I see both?
>
> On a related note, if the answer is to use Net Manager to configure things,
> please tell me where it's located, because I can't find it!
>
> Thanks in a big, big way.
>
> Bob M.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 07 1998 - 00:00:00 CDT