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

This is interesting!! I'll give it a try.

Thanks.

ltiu

Adams, Matthew (GEA, MABG, 088130) wrote:

> No it does not.
>
> try the following from the command line
> (with no tnsnames.ora file)
> (substitute valid values for machine, port, sid, etc)
>
>
> sqlplus
> username@(description=(address=(protocol=tcp)(host=machine1)(port=1521))(connect_data=(sid=sid1)))
>
>
> it will work.
>
> A similar syntax can be used in defining database links, by passing all
> need for tnsnames.ora file
>
> ----
> Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
> Their fundamental design flaws are completely
> hidden by their superficial design flaws.
> - Douglas Adams
>
> -----Original Message-----
> From: Hemant K Chitale [mailto:hkchital_at_singnet.com.sg]
> Sent: Friday, September 06, 2002 12:59 PM
> 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_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).
>
> Hemant K Chitale
> Now using Eudora Email. Try it !
>
> My home page is : http://hkchital.tripod.com
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hemant K Chitale
> INET: hkchital_at_singnet.com.sg
>
> 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: ltiu
  INET: ltiu_at_alumni.sfu.ca

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).