Re: ORA-12154: TNS: could not resolve service name..when using hsodbc

avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<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:
> 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.
>
> 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,
> avsrk

It doesn't really make sense to post this question without the relevant *.ora files. No one here is clairvoyant and crystall balls have sold out here.
General note: syntax errors like missing parentheses in tnsnames.ora also result in ora-12154. Please use a magnifying glass to check whether the () match.

Sybrand Bakker
Senior Oracle DBA Received on Thu Jun 26 2003 - 09:45:57 CEST