Re: connection concentration & tnsnames.ora practical use?

Manuella,

Named resources would be more tedious to maintain as your number of instances and servers grows, as opposed to a repository served by Oracle Names. But named resources beat IP addresses any day of the week.

You have to watch for middle tier apps that want to do things like literal direct IP address references down to port numbers, those are horrid and would bypass OCM entirely, and usually are when the middle tier people decide to make their own connection management. That makes it hard for DBAs, as also, usually, all the users sign into Oracle as SALES_USER; forty threads with the same login coming down the pipe, it is hard to trace what particular unclosed thread or session is causing trouble.

Just my opinion. Good luck!

RSH. "Manuela Mueller" <520040906697-0001_at_t-online.de> wrote in message news:3C834053.27EDEE91_at_t-online.de...
> RSH wrote:
> >
> > What exactly is the question?
> >
> > CC is to replace or fend off home grown connection concentration
mechanisms
> > whose maintenance or even analysis is a horror.
> >
> > Oracle Names is a good thing; make sure you have several Oracle Names
> > servers in the structure.
> >
> > OCM and OCC in my opinion, are to offer alternatives to homegrown stuff
that
> > people write in the middle tier because they feel they are smarter than
> > Oracle.
> >
> > In my experience so far, it has been Oracle 10-0 over homegrown.
> >
> > RSH.
> >
>
> Hello RSH,
> maybe I didn't make the point clear enough. Question was, is there any
> benefit in using connection concentration in conjunction with local
> naming?
> Is anybody using this two features together?
> I know you can choose between Oracle Names and connection concentration
> or local naming and connection concentration.
> I got the impression that administration/manintenance with the latter
> could easily turn into a nightmare.
> Thank's for your input, got your point on the homegrown stuff.
> Have a nice day
> Manuela Mueller
Received on Wed Mar 06 2002 - 12:48:32 CST