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

Are you running Oracle 8?

If so, you should try the "net8" assistant. Sqlnet Easyconfig is intended for "client" side installation/configuration.

Occasionaly, I still modify the config files by hand - but you should have been able to accomplish what you wanted with net8 assistant.

SCott
meyer_b_at_rocketmail.com wrote:

> 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