| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: tnsnames.ora not working ?
Reuben,
If the normal connection is throwing an error, then it stands to reason that the seond one would not connect either. You need to get a connection working first before you try something else.
The Oracle error you are getting is complaining about the service_name entry. Is this the same value for the database that you are trying to connect to? Is the database advertising itself as a service of dev_db? Fix this first and get the connection to work via the normal method. And then you can try the other method.
And, finally, why in the world do you want to do this?
Good Luck.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mercadante, Thomas F
INET: thomas.mercadante_at_labor.state.ny.us
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).
Received on Tue Jan 20 2004 - 10:19:37 CST
 |
 |