Message-ID: <F001.004CB271.20020909095329@fatcity.com>
Date: Mon, 09 Sep 2002 09:53:29 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: CC Harvest <ccharvest@yahoo.com>
Subject: Re: connect to the databases without using tnsnames.ora?
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Thanks all for the answers. We do use Oracle Names
here.

Cc Harvest.

--- Jared.Still@radisys.com wrote:
> Neither sqlnet.ora or tnsnames.ora are required.
> 
> You can connect to a database by specifying the full
> connect string.
> 
> This will work from sqlplus:
> 
>   connect 
>
system/manager@(description=(address=(protocol=tcp)(host=remedydev)(port=1521))(connect_data=(sid=orcl)))
> 
> It works, but is not terribly convenient.
> 
> I don't imagine your dba was doing this though. 
> Could it be that
> Oracle Names servers are being used?  They don't
> require tnsnames.ora 
> files.
> 
> Jared
> 
> 
> 
> 
> 
> 
> CC Harvest <ccharvest@yahoo.com>
> Sent by: root@fatcity.com
>  09/05/2002 06:23 PM
>  Please respond to ORACLE-L
> 
>  
>         To:     Multiple recipients of list ORACLE-L
> <ORACLE-L@fatcity.com>
>         cc: 
>         Subject:        connect to the databases
> without using tnsnames.ora?
> 
> 
> 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?
> 
> Cc Harvest
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: CC Harvest
>   INET: ccharvest@yahoo.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).
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: Jared.Still@radisys.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).


__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: ccharvest@yahoo.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).