| Db link OK on server not on PC [message #178680] |
Thu, 22 June 2006 03:34  |
p.dbruin@wanadoo.nl
Messages: 8
Registered: June 2006
Location: Netherlands Den Haag
|
Junior Member |
|
|
Hello,
I am having strange troubles with my database links.
I created a private link for a specific user.
If I try the link from within a SQLplus session on the server it works fine. But if I try it from my pc (with OEM, toad or SQLplus)it replies TNS could not resolve service name......
(ERROR at line 1:ORA-12154: TNS:could not resolve service name)
I queried the PID for the PC session on the server and did a
"ps -auxwwe" to get the environment. It had the same TNS_ADMIN as my working, serverside, sql session ?!?!
Anyone ?
Thanks,
Peter
[Updated on: Thu, 22 June 2006 03:40] Report message to a moderator |
|
|
|
| Re: Db link OK on server not on PC [message #178869 is a reply to message #178680] |
Fri, 23 June 2006 04:13  |
p.dbruin@wanadoo.nl
Messages: 8
Registered: June 2006
Location: Netherlands Den Haag
|
Junior Member |
|
|
SOLVED
The cluster has for each SID a separate listener and each listener has its own TNS_ADMIN.
I deleted all tnsnames files from all those SID specific directories so the ORACLE_HOME will be used.
(This environment is beiing built so I am learning....)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
