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.