[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

I Have an VB6 application running with Oracle 8 Database. ...

<< Back to: [FAQ] Oracle Database FAQ

Question by Etienne
Submitted on 2/10/2004
Related FAQ: [FAQ] Oracle Database FAQ
Rating: Not yet rated Rate this question: Vote
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.



Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.


Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

 

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

 

<< Back to: [FAQ] Oracle Database FAQ

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]
© 2008 FAQS.ORG. All rights reserved.