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 5 32190
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 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
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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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
...
|
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
|
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...
|
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...
|
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...
|
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...
|
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...
|
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:
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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...
| |