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