OraFAQ Forum: Networking and Gateways » Remote Access Oracle 7.3.4 over VPN

Home » RDBMS Server » Networking and Gateways » Remote Access Oracle 7.3.4 over VPN

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Remote Access Oracle 7.3.4 over VPN [message #66850]

Tue, 04 February 2003 05:20

Luca
Messages: 5
Registered: November 2001

Junior Member

Hi,
I've a trouble accessing an Oracle DB behind a FireWall from remote Windows Client. I've mapped client's IP address by a NAT on Firewall and open all ports for incoming/outgoing traffic. I've configured TNSNAMES.ORA on the client (using NAT Server IP Address) and I could TNSPING the server but when I try to open a Sql.Plus session I get TNS Error ORA-12203. I read about "connection manager" but I think I can't use it on 7.3.4 version. I also checked server's listener log file and it seems ok (I read "establish connection on SID).
Could you help me?
Thanks for attention,
Luca

Report message to a moderator

Re: Remote Access Oracle 7.3.4 over VPN [message #66852 is a reply to message #66850]

Tue, 04 February 2003 06:09

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Case of IP redirection against firewalls and in DMZ ( de-militarized zones).
long story short,
set this registry settting in the server and bounce the server (and db).
USE_SHARED_SOCKET = TRUE
try again.
if this is not helping you, there are some other things to ponder.

Report message to a moderator

Re: Remote Access Oracle 7.3.4 over VPN [message #67703 is a reply to message #66850]

Thu, 20 January 2005 19:38

vds
Messages: 1
Registered: January 2005

Junior Member

vsd

Report message to a moderator

Previous Topic:	printing problem
Next Topic:	network traffic caused by oracle9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 03:34:19 CST 2024