ORA-12154: TNS: could not resolve service name..when using hsodbc
Date: 25 Jun 2003 08:19:59 -0700
Message-ID: <25c1993e.0306250719.2cacd61a_at_posting.google.com>
Dear oracle gurus,
I am unable to get past the error ORA-12154: TNS: could not resolve
service name on my host when using hsodbc to talk to a remote mysql
database. i got from the meta link all the needed documenatation to
configure inithsodbc.ora,listener.ora,tnsnames.ora and related errors
Here is what it says
ORA-12154:
I did this query and the host value and SQL*Net alias match.
I dont know what is that i am missing
Your help is greatly appreciated.
-thanks,
SQL> select * from all_catalog_at_demo;
select * from all_catalog_at_demo
*
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
Resolution:
The database link uses a SQL*Net alias not specified
in the TNSNAMES.ORA of the database server.
Query the data dictionary to figure out the 'HOST'
specified for the database link:
select db_link, host from user_db_links;
or
select db_link, host from dba_db_links;
The 'HOST' value is the alias of the SQL*Net.
Please make sure it exists in the TNSNAMES.ORA file
present at the Oracle database server.
avsrk
Received on Wed Jun 25 2003 - 17:19:59 CEST