Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g89E5IL06701 for ; Mon, 9 Sep 2002 10:05:18 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id HAA56073; Mon, 9 Sep 2002 07:05:06 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004CAF01; Mon, 09 Sep 2002 06:48:20 -0800 Message-ID: Date: Mon, 09 Sep 2002 06:48:20 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Jesse, Rich" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Jesse, Rich" Subject: RE: connect to the databases without using tnsnames.ora? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Correct. And since I use ONames, a TNSNAMES.ORA file is not supposed to be required on the client. QCO, however, still requires it, but there are workarounds. Tbink about it. What's the point of centralizing your instance names in ONames if you still require that same info to be somehow magically synched on each client? Rich Jesse System/Database Administrator Rich.Jesse@qtiworld.com Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Hemant K Chitale [mailto:hkchital@singnet.com.sg] > Sent: Friday, September 06, 2002 11:59 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: connect to the databases without using tnsnames.ora? > > > > What do you mean by "mistakenly require a TNSNAMES.ORA file" ? > The TNSNAMES.ORA file is required unless you are using either of > a) Oracle Names > b) Thin Java client > > Hemant > > At 06:38 AM 06-09-02 -0800, you wrote: > >As an FYI, some 3rd-party products still mistakenly require > a TNSNAMES.ORA > >file. Quest's QCO (at least 2.0, haven't D/L'd 2.1 yet and > Quest Support > >tells me it will be fixed in 3.0 next Q1) is one of them. > > > >Also, there is at least one circumstance that requires a > TNSNAMES.ORA on a > >server. I can't remember for the life of me what it is, but > something with > >the Intelligent Agent sticks in my head. > > > >Rich Jesse System/Database Administrator > >Rich.Jesse@qtiworld.com Quad/Tech > International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: Rich.Jesse@qtiworld.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).