Re: Help with TNSNames problem with multiple homes?

Roger,

bequeth is *not* similar to tcp local loopback, it is a listenerless protocol - handy when you're on one machine, and short on resources.

Frank

Roger Crowley wrote:

> Without going into any detail (I'm not sure if you've already tried
> these steps), you need to check your listener.ora file to make sure you
> have a "sid_desc" entry under "sid_list_listener" for each of your
> databases (I assume you have a different SID for each database or
> you'll need two listeners, monitoring two different ports). Then make
> sure your tnsnames.ora has an entry for each database (you'll connect
> to whatever you choose as the entry's alias), remembering that
> the "sid=" argument has changed to "service_name=" in 8.1.6 (8i). You
> need to set the TNS_ADMIN environment variable to point to where your
> listener and tnsnames files are. If you want to connect from the same
> machine (not something I do myself), I believe you need a "local" entry
> in your tnsnames that has the "bequeath" protocol (different set of
> parameters than the other entries), where "bequeath" means "connect to
> myself in loopback".
>
> Also, in 8.1.6 (at least the client I have), Enterprise Manager modules
> have been replaced by DBA Studio (where Instance Mgr, Schema Mgr, etc
> are all combined into a single app).
>
> In article <39ee147a.11930795_at_news.mcit.com>,
> holdenje_at_nospam.msu.edu (Holden) wrote:
> > I noticed that it didnt install the schema manager and others (I
> > assume version 2.1?) you have to do a custom install and select them,
> > I believe.
> >
> > On 17 Oct 2000 09:33:06 -0500, don <chambers_at_inquiregroup.com> wrote:
> >
> > >I have just built my new desktop and canot get connectivity to
 Oracle.
> > >I am using Oracle 8.1.6. I installed the client software and used
> > >Net8 easy config to setup a service to point to my 8i database and to
> > >and older 8.0 database. This works with no problems.
> > >
> > >I then installed the Enterprise Manager version 2.0.4 which must be
> > >installed under a different home. I cannot use net8 easy config for
> > >this instalation because it only works for one home.
> > >
> > >I then compied by tnsnames.ora file to the proper loaction in the new
> > >home (net80/admin) but I can't connect to 8i using this. I am able
 to
> > >connect to the 8.0 database using this tnsnames.ora file.
> > >
> > >On my old machine this is what I did and it worked. I tried getting
> > >the tnsname.ora file from my old machine but this did not solve the
> > >problem.
> > >
> > >Can anyone offer a solution?
> > >
> > >I have a newer verion of enterprise manager which I installed first
> > >but it appears that some things are missing such as schema manager.
> > >Did I not install everything or has there been a change?
> > >
> > >Thanks,
> > > Don
> > > chambers_at_inquiregroup.com
> >
> >
>
> --
> Have a good day!
> Roger Crowley DBA
> MedImpact Healthcare Systems, Inc.
> San Diego CA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 23 2000 - 17:18:03 CEST