This content has been marked as final. Show 8 replies
database B must be able to initiate packet exchange with system having database A on random high port
How can I test it?
Yes you might need to open the firewall.1 person found this helpful
1 person found this helpful
934451 wrote:telnet other_system 12345
How can I test it?
When you do a connect user@netservicename the net serivice name should come out of your tnsnames.ora file so check your tnsnames.ora entry for the target instance and verify your database link connect information matches. Normally for the using clause I just use the tnsname.ora net service name (alias) so if I can connect using sqlplus user@tns then the link is going to work providing I get the remote database name correct in the link.1 person found this helpful
HTH -- Mark D Powell --
PS in your db link you have connect to databaseB. I take it that this enty actually uses the remote Oracle username rather than what you posted.
Edited by: Mark D Powell on Feb 1, 2013 7:14 AM
From forums and other sources and you say, I MIGHT need to open firewall. I am really trying to understand here, does it imply we can make dblink work between servers without opening firewall. Like I need a confirmation saying without firewall opened, IT IS IMPOSSIBLE for dblinks to work.
Yes you might need to open the firewall.
That is a way of testing if firewall is opened. Firewall is not opened
telnet other_system 12345
Yes it does.
I take it that this enty actually uses the remote Oracle username rather than what you posted.
Hi,1 person found this helpful
Firewall has to be opened to allow this access if there is a firewall between the two servers. Just think of it as one database is a client and the other is a server there is nothing clever or speical anout the networking for database links.
Thank you all for the inputs.