Home » Infrastructure » Windows » Intermittent 0313 error
Intermittent 0313 error [message #100894] Mon, 09 February 2004 23:55 Go to next message
Etienne LAUR
Messages: 3
Registered: February 2004
Junior Member
I Have an VB6 application running with Oracle 8 Database.

This application works fine on the LAN, but there are intermittent 03113 errors when trying remote connexions.

Server : W2K;Oracle8

Client : W98,WXP

tnsnames.ora:

BACMRE01.CA12 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 129.12.33.4)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bacmre01.ca12)
    )
  )

sqlnet.ora :

SQLNET.AUTHENTICATION_SERVICES= (NTS)

AUTOMATIC_IPC=OFF

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
TRACE_LEVEL_SERVER=16
TRACE_DIRECTORY_SERVER=E:TEMP
TRACE_FILE_SERVER=CA12.TRC
TRACE_LEVEL_CLIENT=16
TRACE_DIRECTORY_CLIENT=E:TEMP
TRACE_FILE_CLIENT=CLI.TRC
TRACE_UNIQUE_CLIENT=TRUE

trace file :

nsrdr: got NSPTDA packet

nsrdr: NSPTDA flags: 0x40

nsrdr: normal exit

nsdo: entry

nsdo: cid=1, opcode=85, *bl=2037, *what=0, uflgs=0x0, cflgs=0x1

nsdo: nsctx: state=6, flg=0x620c, mvd=0

nsdo: gtn=143, gtc=143, ptn=10, ptc=2048

nserror: entry

nsdo: error exit

nsdo: nsctxrnk=0

nsdo: error exit

nioqer: entry

nioqer: incoming err = 12151

nioqce: entry

nioqce: exit

nioqer: returning err = 3113

nioqer: exit

nioqrc: exit

nioqds: entry

nioqds: disconnecting...

Have you an idea about this problem ?

Thanks.

 
Re: Intermittent 0313 error [message #100899 is a reply to message #100894] Wed, 11 February 2004 03:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10702
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
if you are not using any of those tracing and authentication services,
comment all entries in sqlnet.ora and try again,
Re: Intermittent 0313 error [message #100900 is a reply to message #100899] Wed, 11 February 2004 04:04 Go to previous messageGo to next message
Etienne LAUR
Messages: 3
Registered: February 2004
Junior Member
I've added those tracing services in order to find the problem. So without the tracing services, there is exactly the same problem.
Re: Intermittent 0313 error [message #101461 is a reply to message #100894] Tue, 12 October 2004 06:17 Go to previous message
LS
Messages: 1
Registered: October 2004
Junior Member
any luck in resolving this issue?

what do you mean by remote?

i'm looking at similar issues, with no fix/resolution.

It is a VB6 application that functions on a typical wired windows based desktop but we are trying to use a wireless laptop. after some idle time, say 20 minutes, the connection is dropped or lost. The trace logs show:

[[07-OCT-2004 11:32:41]] nioqper: error from nioqrc
[[07-OCT-2004 11:32:41]] nioqper: nr err code: 0
[[07-OCT-2004 11:32:41]] nioqper: ns main err code: 12547
[[07-OCT-2004 11:32:41]] nioqper: ns (2) err code: 12560
[[07-OCT-2004 11:32:41]] nioqper: nt main err code: 517
[[07-OCT-2004 11:32:41]] nioqper: nt (2) err code: 54
[[07-OCT-2004 11:32:41]] nioqper: nt OS err code: 0
[[07-OCT-2004 11:32:41]] nioqer: entry
[[07-OCT-2004 11:32:41]] nioqer: incoming err = 12151
[[07-OCT-2004 11:32:41]] nioqce: entry
[[07-OCT-2004 11:32:41]] nioqce: exit
[[07-OCT-2004 11:32:41]] nioqer: returning err = 3113
[[07-OCT-2004 11:32:41]] nioqer: exit
[[07-OCT-2004 11:32:41]] nioqrc: exit
[[07-OCT-2004 11:32:41]] nioqbr: entry
[[07-OCT-2004 11:32:41]] nioqbr: state = normal (0)
[[07-OCT-2004 11:32:41]] nioqsm: entry
[[07-OCT-2004 11:32:41]] nioqsm: Sending break packet (1)...

I've tried enabling SQLNET.EXPIRE_TIME = 5 in the sqlnet.ora of the database server to have it probe for dead connections.

I haven't found anything googling "oracle wireless"

I'm thinking the problem could be the wireless adapater, maybe the wireless access point, or even something missing or modified in the mobile-laptop-processor.

finding and fixing the issue is difficult.
Previous Topic: error symcjit.dll
Next Topic: create database error
Goto Forum:
  


Current Time: Fri May 27 01:40:29 CDT 2022