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