From: Scott Cote <scottcote@contractor.net>
Subject: Re: **HELP** SQL*Net w/ multiple instances
Date: 1998/07/07
Message-ID: <35A29D02.7E6CDFA@contractor.net>#1/1
Content-Transfer-Encoding: 7bit
References: <6nt8cl$u81$1@nnrp1.dejanews.com> <6ntdkb$5vr$1@nnrp1.dejanews.com> <6ntjac$e8v$1@nnrp1.dejanews.com>
Content-Type: text/plain; charset=us-ascii
Organization: Flashnet Communications, http://www.flash.net
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc


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@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@nnrp1.dejanews.com>,
>   alanlee1@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@nnrp1.dejanews.com>,
> >   meyer_b@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