I have a problem with the connectivity. I have created a dblink to the production database by name livelink. I am able to connect to the production database using the host string but while trying to retrieve any data using the database link, I am prompted with the error :
ORA-12535: TNSperation timed out
We connect to the production database by passing thru the firewall.
when u try to access a server which is in DMZ zone u need to have a permission to enter through the firewall.Check with your network people whether u have the access to enter from the workstation through which u are trying to connect.Simply by creating a database link will not solve the problem.
i am able to connect to the remote database thru the firewall using the username and password of the firewall from my workstation to the database of remote server. what could be the problem if i connect thru a db link.
If u are able to connect to the remote server with username then check the global_names parameter on the remote server and make to 'False'.Now u should be able to use the database link from the workstation on which u have the authorization.
So its not the problem with database link it is a problem with firewall permission.