| Database Link gives TNS Error.:)RA-12154 [message #31991] |
Tue, 27 July 2004 21:58 |
Kuntal
Messages: 9
Registered: February 2004
|
Junior Member |
|
|
Hi,
I have a two Oracle 8i databases (DB1 and DB2). DB1 is on AIX platform while DB2 is on Windows 2000 platform. I have created a public database link from DB1 to DB2 inorder to access a table on DB2 under a specific user.
create public database link atdn_db1
connect to usr1 identified by passwd
using 'db1';
now when i issue a query
select count(*) from usr1.table1@atdn_db1;
gives the following error.
ORA-12154: TNS:could not resolve service name.
I have checked the parameters in both the database and found that the global_names = FALSE is both.
I need a urgent soultion. Any insight as to where i am going wrong will be of great help.
Thanks
Kuntal
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
