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 - [EMAIL PROTECTED] > Their fundamental design flaws are completely > hidden by their superficial design flaws. > - Douglas Adams > > -----Original Message----- > From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] > 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 > >[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). > > 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: [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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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).
