On Tuesday 20 January 2004 11:20 am, Scott Canaan wrote: > Are you using Oracle Services? I've seen this happen before and we > change SERVICE_NAME to SID and everything works fine.
That does not work for me either. RDB > -----Original Message----- > Reuben D. Budiardja > Sent: Tuesday, January 20, 2004 10:49 AM > To: Multiple recipients of list ORACLE-L > > > Hello, > I'm trying to add description in my > $ORACLE_HOME/network/admin/tnsnames.ora, > but it seems that the client (ie. sqlplus) wont use it. Whenever I try > to > connect to the service using sqlplus, I got : > > $> sqlplus > Enter user-name: [EMAIL PROTECTED] > Enter password: ***** > ORA-12154: TNS:could not resolve service name > > I tried to add the description to my ~/.tnsnames.ora too with no luck. > The > entry in the tnsnames.ora is: > > DEV_DB = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVICE_NAME = dev_db) > ) > ) > > (note: I removed the real hostname for privacy/security reason of > course) > > However, when I use sqlplus using the following way: > > $> sqlplus > > Enter user-name: > developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = > 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) > Enter password: ***** > > It would work, where all the information from the description is just a > copy-paste from the tnsnames.ora file. > > Is there anything I overlook? Sorry if this is kinda a newbie question. > I'm > still learning my way around this. I'm using Oracle9i on Redhat Linux. > > Thanks for any help. > > Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN --------------------------------------------------------- "To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect." - Linus Torvalds - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).