Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: **HELP** SQL*Net w/ multiple instances
Alan:
Thanks very much, I'll do that. Oracle has so many warnings about not editing the files directly I was afraid to try, but I'll back it up and go ahead.
Bob
In article <6ntdkb$5vr$1_at_nnrp1.dejanews.com>,
alanlee1_at_my-dejanews.com wrote:
>
> 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
>
-----== 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