RE: connect to the databases without using tnsnames.ora?

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_at_qtiworld.com              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:ccharvest_at_yahoo.com]
>
> 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: Rich.Jesse_at_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_at_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).