Idle Disconnection over IPSEC VPN [message #67531] |
Sat, 18 September 2004 13:01 |
Neal S.
Messages: 1 Registered: September 2004
|
Junior Member |
|
|
Hi.
Im running oracle 8.1.7.0
Connecting via SQLWorksheet, over a IPSec VPN Tunnel connection.
Connects fine, can access the DB fine. After about 1-5 minutes of inactivity I get this error:
ORA-03113: end-of-file on communication channel
TNSPING, and PING ok. I suspect there is something going on with the VPN/Firewall rules.
SQL Trace of the eror is:
nsopen: opening transport...
ntpcon: entry
ntpcon: toc = 1
sntpcall: entry
snlpcss: entry
-<ERROR>- snlpcss: Unable to spawn Oracle oracle80 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) ORCL, error 2.
ntpcon: exit
nserror: entry
-<ERROR>- nserror: nsres: id=0, op=65, ns=12547, ns2=12560; nt[[0]]=517, nt[[1]]=0, nt[[2]]=0
-<ERROR>- nsopen: unable to open transport
nsmfr: entry
nsmfr: 456 bytes at 0x1160758
nsmfr: normal exit
nsopen: error exit
nscall: error exit
nricdt: Call failed...
nricdt: exit
nricall: Failed to copy originating community name value binding
nricall: Exiting NRICALL with following termination result -1
nricall: exit
-<ERROR>- osnqper: error from nricall
-<ERROR>- osnqper: nr err code: 12206
-<ERROR>- osnqper: ns main err code: 12547
-<ERROR>- osnqper: ns (2) err code: 12560
-<ERROR>- osnqper: nt main err code: 517
-<ERROR>- osnqper: nt (2) err code: 0
-<ERROR>- osnqper: nt OS err code: 0
osnqme: entry
osnqme: reporting ns (2) error: (12547) as rdbms err (12547)
osnqme: exit
-<ERROR>- onstns: Couldn't connect, returning 12547
onstns: exit
osnqtg: Count in the OSN global area is now 0
nrigbd: entry
nrigbd: exit
osnqtg: Count in the NL global area is now 0
Anyone have similar issues?
Client is W2K,SP4
VPN tunnel is using Forticlient (Fortinet) 3DES-SHA1
Thanks!
Neal
|
|
|
Re: Idle Disconnection over IPSEC VPN [message #109932 is a reply to message #67531] |
Wed, 02 March 2005 01:10 |
msayeed
Messages: 1 Registered: March 2005
|
Junior Member |
|
|
Hello Neal,
I understand this was posted a long time ago, but I am having the exact same problem (the OS version is the same and the IPSec tunnel config is also the same) and I have tried everything I could. If you were able to resolve your issue, I would highly appreciate it if you share information with me.
Anyone else who may have suggested resolutions may also replyto this.
Thanks and regards,
-Mohammad
|
|
|