var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Oracle 8.1.7 connecting DB through a firewall
Hiho hiho all!
I got a little question.
I'm trying to connect to an Oracle 8i DB through a firewall. I created a port forward by doing:
ssh -L 1521:<IP of DB-Server>:1521 <IP of firewall-Server>
then I set up the tnsnames.ora like this:
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(SERVICE_NAME = <machine name of DB server>)
but I always get the following error:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
Can anyone help me with this?
P.S.: 'tnsping db' worked.
Which platform and version are you on?
Usually what you are experiencing happens (if the firewall is correctly set) on Windows.
If you are on this platform set in the registry in the key
and restart the listnener.
On unix environments this is not an issue.
Also on Win32 there is a problem in 8.1.7: the key is not recognized and you have to patch at least 126.96.36.199
I'm using Linux on firewall and client side...
So that's not what I can do