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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -----Original Message----- Sent: Thursday, September 05, 2002 10:28 PM To: Multiple recipients of list ORACLE-L > -----Original Message----- > From: CC Harvest [mailto:[EMAIL PROTECTED]] > > Does anyone here knows how to setup the connections to > the database server without using tnsnames.ora? > > Our DBA didn't use it. But I don't know how and why? > Could anyone tell me the other options? To add to what other posters have said: If the DBA was indeed using Oracle Names, you would see the configuration parameters for the names server in the sqlnet.ora file, which would be in the same directory where you would expect to find the tnsnames.ora file. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
