Re: connect to the databases without using tnsnames.ora?
Thanks all for the answers. We do use Oracle Names here. Cc Harvest. --- [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 09/05/2002 06:23 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > 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: [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: > 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). __ 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: [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).
RE: connect to the databases without using tnsnames.ora?
Correct. And since I use ONames, a TNSNAMES.ORA file is not supposed to be required on the client. QCO, however, still requires it, but there are workarounds. Tbink about it. What's the point of centralizing your instance names in ONames if you still require that same info to be somehow magically synched on each client? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 06, 2002 11:59 AM > 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 -- 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).
Re: connect to the databases without using tnsnames.ora?
On Friday 06 September 2002 12:38, Philip Douglass wrote: > > As for 3rd party products mistakenly requiring a tnsnames.ora file, that > is a valid complaint. And it isn't even limited to 3rd party tools. Some > of Oracle's own tools only give you the option of connecting to databases > that are listed in your tnsnames.ora file, which when using the host > naming method is not required! > I discovered that a couple of years ago with Forms 6 on Solaris. Won't work without a tnsnames.ora, which we didn't use there. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
Re: connect to the databases without using tnsnames.ora?
I use host naming extensively here. We do use tnsnames.ora for our apps so that we can take advantage of failover, but for my everyday work, I connect to the databases with host naming. You don't need a tnsnames.ora to do that OR a complex connect string (which is basically a tnsnames.ora entry rolled up into one line). When I connect to one of my servers, it is generally like this: sqlplus scott/tiger@hostname This is possible because the listener for each database is listening on the default port (1521) and the name is resolved through the usual suspects for TCP/IP name resolution, in our case, DNS. The listener then receives the request and connects it to the database with the matching global_dbname. Very simple. You just can't use connection pooling, heterogeneous services or application failover with this method. As for 3rd party products mistakenly requiring a tnsnames.ora file, that is a valid complaint. And it isn't even limited to 3rd party tools. Some of Oracle's own tools only give you the option of connecting to databases that are listed in your tnsnames.ora file, which when using the host naming method is not required! -- Philip Douglass Internet Networking Group Database Administrator SIRS Publishing, Inc. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 12:08 PM I think the best way is to go to SQLNET.ORA and look for the ordering of the NAME.DIRECTORY_PATH. Remove one by one and you know what is being used. Mostly i think it will be Name Server. A query: Is HOST NAMING used widely? Naveen -Original Message- Sent: Friday, September 06, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Cc I believe the Java thin client can connect without using the tnsnames.ora file. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 05, 2002 8:23 PM To: Multiple recipients of list ORACLE-L 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: [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: DENNIS WILLIAMS 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: Naveen Nahata 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: Philip Douglass 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).
Re: connect to the databases without using tnsnames.ora?
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 <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/05/2002 06:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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: [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: 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).
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 - [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).
Re: connect to the databases without using tnsnames.ora?
Actually, I am talking about my experince with Forte for Java. When establishing a connection to a database using a GUI. It will ask you for the username, password and SID as well as server name or IP address, and then it connects. I am completely oblivious as to where it keeps the parameters I have given it to I'm assuming it stores it somewhere. Not strictly a tnsnames.ora file but a config file somewhere that's specific to Forte. I also have the same experience with JDeveloper. What I meant is that JDBC itself does not use tnsnames.ora but something like it. Thanks for clarifying. ltiu Naveen Nahata wrote: >JDBC Oracle thin driver DOES NOT require any config file. > >The connection url needs to be of the form jdbc:oracle:thin:@host:port:SID > >Naveen > >-Original Message- >Sent: Friday, September 06, 2002 9:33 PM >To: Multiple recipients of list ORACLE-L > > >Are you talking about the JDBC Oracle Thin Driver? > >This is because you configure it separately. It still has a tnsnames.ora > type config somewhere hidden in it's own config file. Just that it does >not use the regular tnsnames.ora. > >ltiu > >DENNIS WILLIAMS wrote: > > > >>Cc >> I believe the Java thin client can connect without using the >>tnsnames.ora file. >> >>Dennis Williams >>DBA >>Lifetouch, Inc. >>[EMAIL PROTECTED] >> >> >>-Original Message- >>Sent: Thursday, September 05, 2002 8:23 PM >>To: Multiple recipients of list ORACLE-L >> >> >>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: 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).
RE: connect to the databases without using tnsnames.ora?
Title: RE: connect to the databases without using tnsnames.ora? 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).
RE: connect to the databases without using tnsnames.ora?
JDBC Oracle thin driver DOES NOT require any config file. The connection url needs to be of the form jdbc:oracle:thin:@host:port:SID Naveen -Original Message- Sent: Friday, September 06, 2002 9:33 PM To: Multiple recipients of list ORACLE-L Are you talking about the JDBC Oracle Thin Driver? This is because you configure it separately. It still has a tnsnames.ora type config somewhere hidden in it's own config file. Just that it does not use the regular tnsnames.ora. ltiu DENNIS WILLIAMS wrote: >Cc > I believe the Java thin client can connect without using the >tnsnames.ora file. > >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > > >-Original Message- >Sent: Thursday, September 05, 2002 8:23 PM >To: Multiple recipients of list ORACLE-L > > >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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata 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).
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).
RE: connect to the databases without using tnsnames.ora?
I think the best way is to go to SQLNET.ORA and look for the ordering of the NAME.DIRECTORY_PATH. Remove one by one and you know what is being used. Mostly i think it will be Name Server. A query: Is HOST NAMING used widely? Naveen -Original Message- Sent: Friday, September 06, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Cc I believe the Java thin client can connect without using the tnsnames.ora file. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 05, 2002 8:23 PM To: Multiple recipients of list ORACLE-L 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: [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: DENNIS WILLIAMS 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: Naveen Nahata 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).
Re: connect to the databases without using tnsnames.ora?
Are you talking about the JDBC Oracle Thin Driver? This is because you configure it separately. It still has a tnsnames.ora type config somewhere hidden in it's own config file. Just that it does not use the regular tnsnames.ora. ltiu DENNIS WILLIAMS wrote: >Cc > I believe the Java thin client can connect without using the >tnsnames.ora file. > >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > > >-Original Message- >Sent: Thursday, September 05, 2002 8:23 PM >To: Multiple recipients of list ORACLE-L > > >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: 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).
RE: connect to the databases without using tnsnames.ora?
Rich - Can you explain what you mean by "mistakenly require"? Is it because you are using Oracle Names? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 06, 2002 9:38 AM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
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 [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).
RE: connect to the databases without using tnsnames.ora?
Cc I believe the Java thin client can connect without using the tnsnames.ora file. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 05, 2002 8:23 PM To: Multiple recipients of list ORACLE-L 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: [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: DENNIS WILLIAMS 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).
RE: connect to the databases without using tnsnames.ora?
Title: RE: connect to the databases without using tnsnames.ora? > -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.
RE: connect to the databases without using tnsnames.ora?
Most likely Oracle Names is in use. If so, you do not need tnsnames.ora file. - Kirti -Original Message- Sent: Thursday, September 05, 2002 8:23 PM To: Multiple recipients of list ORACLE-L 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: [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: Deshpande, Kirti 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).
Re: connect to the databases without using tnsnames.ora?
CC Harvest, hi, just read net8 admin guide and you will find he can use names server, use hostname naming method.These method do not use tnsnames.ora file. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] === 2002-09-05 17:23:00 ,you wrote£º=== >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: [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). = = = = = = = = = = = = = = = = = = = = zhu chao [EMAIL PROTECTED] 2002-09-06 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zhu chao 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).