Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!newsfeed2.scan-plus.net!news.germany.com!postnews.google.com!o5g2000hsb.googlegroups.com!not-for-mail From: Carlos Newsgroups: comp.databases.oracle.tools Subject: Re: OCI Multiple homes Date: 10 May 2007 00:11:34 -0700 Organization: http://groups.google.com Lines: 57 Message-ID: <1178781094.437471.201000@o5g2000hsb.googlegroups.com> References: <1178703732.820571.131600@e51g2000hsg.googlegroups.com> <1178711912.314643.264740@q75g2000hsh.googlegroups.com> <1178718418.106242.295220@y5g2000hsa.googlegroups.com> NNTP-Posting-Host: 195.53.128.4 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1178781096 4613 127.0.0.1 (10 May 2007 07:11:36 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 10 May 2007 07:11:36 +0000 (UTC) In-Reply-To: User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: o5g2000hsb.googlegroups.com; posting-host=195.53.128.4; posting-account=v-zykAwAAADju6kwCHhel-_TxejVCoOK Xref: news.f.de.plusline.net comp.databases.oracle.tools:35696 On 9 mayo, 19:40, sybra...@hccnet.nl wrote: > On 9 May 2007 06:46:58 -0700, Carlos > wrote: > > >Sybrand, I'm afraid I disagree. > > >Different ORACLE_HOMEs may have different aliases in their respective > >tnsnames.ora (maybe they will connect to different groups of > >instances, different environments, etc, etc...) > > >What I said is that the OP should put the *apropriate* alias in the > >files and connect using them in the correct way (whatever this way > >is). > > >It was you who figured out that the two tnsnames.ora should be the > >same, not me. > > >Cheers. > > Carlos, > I'm afraid I consider this as promoting maintaining messes. > The mess you describe above is the perfect reason to > either set up a central tnsnames.ora or abandon tnsnames.ora > completely and setup OID. > Apparently you never have been in the situation you describe. I have. > I don't want to jump around every individual workstation because > Oracle was upgraded. In fact this was on of the reasons NOT to > upgrade, and to continue to use desupported versions, without a proper > support contract in place. > > Sorry to say so, but you shouldn't learn people how NOT to do their > job. > > -- > Sybrand Bakker > Senior Oracle DBA Sybrand: "Apparently you never have been in the situation you describe." Yes I have. I know it can be a mess, but my point was I didn't assume anything (the OP didn't say anything about it, I don't know the OP's environtment) I only said you must put *appropriate* entries in the respective tnsnames.ora (no matter if you centralise, or use symbolic links, or whatever). Finally, It's quite right what you said, but I was not saying otherwise (or at least I didn't mean it). I was only NOT assuming any OP's environment. BTW: I don't want to start another futile 'war of words'. ;-) Cheers. Carlos.