| Database link 9i - RDB [message #63554] |
Fri, 15 October 2004 04:52  |
Maarten
Messages: 9
Registered: October 2004
|
Junior Member |
|
|
Hi,
I have got two databases; a Oracle 9.2.0.1.0 and a RDB (Oracle Rdb OCI Server Release 7.1.5.9.1 - Production, Level 1.7
Oracle Rdb SQL Release 7.1.0.4.0 - Production)
I want to compare the data of two tables, one in the 9i dbase and the other in RDB, so I created a db link in the 9i database as in
CREATE PUBLIC DATABASE LINK name_of_my_link
CONNECT to user_account IDENTIFIED BY password
USING 'this_instance';
but I get the error:
SQL> select * from all_tables@whsdata;
select * from all_tables@whsdata
*
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
But I can start up a SQL session and log on to the RDB database without any problems, so tnsnames.ora is correct. Has anybody got an idea what could be wrong?
Thanks! Maarten.
|
|
|
|
| Re: Database link 9i - RDB [message #63589 is a reply to message #63554] |
Tue, 19 October 2004 05:30  |
Ankur
Messages: 22
Registered: August 2000
|
Junior Member |
|
|
Please check the global_names parameter of the server on which you have created the database link.
If it is set to true the database link name should be same as the global_name of the remote database.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
