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

Hi sybrand,
I cross checked all the paranthesis and syntax. Interestingly, if i were to edit the tnsnames.ora i face this problem. I tried launching netasst and deleted and recreated the alias and the problem disappeared.

Does it have some thing to do with not editing this file manually ???

-thx,
avsrk

sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0306252345.58437965_at_posting.google.com>...
> 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 - 23:24:48 CEST