Solved

ora-12571 TNS:packet writer failure on site to site vpn

Posted on 2011-09-23
4
1,245 Views
Last Modified: 2012-06-27
I have a site to site VPN set up using a T1 internet connection on both sides and sonicwalls on both sides.

When running a ping test connection is never lost.

I have  some programs that use oracle odac and oracle forms on the remote site that connect to the oracle 11 database on the home site and the programs will crash and give a ora-12571 TNS:packet writer failure.  

I have already tried to change sqlnet.ora on the client, SQLNET.AUTHENTICATION_SERVICES= (NONE) from (NTS) and that did not resolve the issue.  The disconnect seem to occur every 15 minutes or so.

Issue only occurs on site to site vpn setup.  Connections to a different subnet using a MPLS connection are working properly.
Any help would be appreciated.
0
Comment
Question by:OliShim
  • 3
4 Comments
 
LVL 15

Expert Comment

by:Devinder Singh Virdi
Comment Utility
This problem seems to be a firewall issue. I never configured this firewall with oracle.
Just check by disabling firewall and if everything looks good. You may need to take help of system admin.
0
 
LVL 15

Expert Comment

by:Shaju Kumbalath
Comment Utility
Please enable the necessary ports on firewall rather than disabling it.
0
 
LVL 15

Expert Comment

by:Shaju Kumbalath
Comment Utility
Sorry, I misread it. i thought u r not able to establish connection at all. We are also facing same problem oracle connections are dropped after moving databases behind firewall (VLAN).
0
 
LVL 15

Accepted Solution

by:
Shaju Kumbalath earned 250 total points
Comment Utility
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now