473,320 Members | 1,861 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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@demo;
select * from all_catalog@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
Jul 19 '05 #1
5 32190
TC
Remote mysql database using tnsnames.ora ?

Or am I missing something over here ?

//tc

"Subrahmanyam Arya" <av***@mailcity.com> wrote in message
news:25**************************@posting.google.c om...
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@demo;
select * from all_catalog@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

Jul 19 '05 #2
av***@mailcity.com (Subrahmanyam Arya) wrote in message news:<25**************************@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@demo;
select * from all_catalog@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
Jul 19 '05 #3
Hi there,
Obviously no..tnsnames.ora on the Oracle end is configured properly.
but i still get that error

Any clue,
avsrk

"TC" <do******@donotuse.com> wrote in message news:<qmoKa.18840$3d.12014@sccrnsc02>...
Remote mysql database using tnsnames.ora ?

Or am I missing something over here ?

//tc

"Subrahmanyam Arya" <av***@mailcity.com> wrote in message
news:25**************************@posting.google.c om...
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@demo;
select * from all_catalog@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

Jul 19 '05 #4
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

sy******@yahoo.com wrote in message news:<a1**************************@posting.google. com>...
av***@mailcity.com (Subrahmanyam Arya) wrote in message news:<25**************************@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@demo;
select * from all_catalog@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

Jul 19 '05 #5
You must have made a mistake when manually editing your tnsnames.
There's no rule prohibiting manual modifications in tnsnames (as a
matter of fact, I can't remember the last time I used a tool such as
netasst to edit it), but Oracle doesn't allow any syntax mistake at
all (such as extra parenthesis, anything misspelled, ...).

Daniel
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

Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Galina | last post by:
Hello I have created a trigger not to let records with certain fields null to be inserted into the table: BEGIN IF :new.RUL_CODE is null or :new.FES_UINS_CODE is null or :new.FES_UIO_CALOCC is...
1
by: Alan Brown | last post by:
Hi All, I've been trying to access an 8.1.6 oracle database, running on solaris 7, remotely from another solaris 7 server. The remote database server (on the same subnet, same vlan as the remote...
2
by: Ping | last post by:
Where can i find the initialization file to change some parameters? This file used to be init<sid>.ora in previous versions of oracle. Oracle 9.2 on xp is in question. Thanks in advance ...
6
by: bdj | last post by:
Hello! I have at set of tnsnames.ora. I wich to make an union, e.g. a single file of it. How can I do that easy? Greetings Bjørn
3
by: Michael John | last post by:
Hey, how can I get ORA-..... error messages in languages other than english. I did a alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1'; but this only threw an ORA-00922. Or I'm wrong...
2
by: mpatel6 | last post by:
I had this error in alert log and my instance was down, anybody can help me? Errors in file /u01/app/oracle/admin/sotstest/bdump/sotstest_p004_626740.trc: ORA-07445: exception encountered: core...
2
by: hemantmudaliar | last post by:
The Trigger is giving following exception java.sql.SQLException: ORA-04091: table PSCONTENT.VGNASCHANNEL is mutating, trigger/function may not see it ORA-06512: at...
2
by: Nestor Fra | last post by:
Hi guys I'm tried to open a conection with oracle databse, but I received thoses error(see below). My knwologed about db it's very poor (like my dba), how I can explain to him more clear where...
0
by: bdthanki | last post by:
Hi ! I am migrating Oracle 9.0.0.0 to Oracle 9.2.0.0. As per the migration procedure i had executed catpatch.sql sucessfully. Now, at the time of exeuting utlrp.sql ; i am getting follwing error...
0
by: Zahi Savion | last post by:
Hi All, I tried evething: but no help, I'm connecting from my home trough 1.5 MB ADSL Line to Oracle Server and getting ORA-12170 Oracle 10g Actions that didn't help:
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.