Re: tnsnames.ora not working ?

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: developer_at_dev_db
> 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: techlist_at_voyager.phys.utk.edu

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