| Intermittent 0313 error [message #100894] |
Mon, 09 February 2004 23:55  |
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 #101461 is a reply to message #100894] |
Tue, 12 October 2004 06:17  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
