not able to access remote database usinf db link [message #457078] |
Fri, 21 May 2010 00:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shashikoor
Messages: 25 Registered: April 2006 Location: india
|
Junior Member |
|
|
Hi ,
We have created a new db link.
But we are not able access the remote database. When we are trying to access any table using db link system is getting hanged.
We would like to know what are the parameters/permissions which affect the db link access either at data base level or at server level.
One observation we made is that that particular db link is not getting dropped when we tried to drop it.
Can any body please help.
Advance Thanks,
shashanka.
|
|
|
|
Re: not able to access remote database usinf db link [message #457092 is a reply to message #457080] |
Fri, 21 May 2010 00:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Use SQL*Plus and copy and paste your session.
Before Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
In addition, from the database server with the account that starts the instance and the same Oracle home that has been used to start the instance, execute "tnsping <the service name your gave at db link creation>" and post it.
Regards
Michel
|
|
|