Thanks all for the answers. We do use Oracle Names
here.
Cc Harvest.
- Jared.Still_at_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_at_yahoo.com>
> Sent by: root_at_fatcity.com
> 09/05/2002 06:23 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_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_at_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_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).
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_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_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).
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_at_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_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).
Received on Mon Sep 09 2002 - 12:53:29 CDT