Error 3113 and error 3114 are generated when the database goes
down but NetDynamics still has an open connection. We have this
occur every night when our database is backed up and the NetDynamics
Server is still open. We added error plans which seem to handle this
problem.
The first thing we do when a user enters is execute a dataobject
with the following sql: 'select sysdate from dual;' If the connection
needs to be remade it gets handled at this point with the code
below.
We have this code in our project java file:
//[[SPIDER_EVENT<onAfterInitEvent ()>
protected int onAfterInitEvent ()
{
CSpDataSource ds = CSpider.getDataSource("dsFaculty");
CSpDBErrorRecoveryPlan erPlan1 = new CSpDBErrorRecoveryPlan (
CSpDBErrorRecoveryPlan.IGNORE_ERROR,
3114,
0,
true,
CSpDBErrorRecoveryPlan.RETRY_OUTSIDE_OF_TRANSACTIONS,
1);
ds.addDBErrorRecoveryPlan (erPlan1);
ds = CSpider.getDataSource("dsFaculty");
CSpDBErrorRecoveryPlan erPlan2 = new CSpDBErrorRecoveryPlan (
CSpDBErrorRecoveryPlan.IGNORE_ERROR,
3113,
0,
true,
CSpDBErrorRecoveryPlan.RETRY_OUTSIDE_OF_TRANSACTIONS,
1);
ds.addDBErrorRecoveryPlan (erPlan2);
return (PROCEED_WITH_BUILTIN_HANDLING);
}
//]]SPIDER_EVENT<onAfterInitEvent ()>
"Hoskins, John D." wrote:
> Hi all.
> We have an app that is using a mainframe Oracle 7 db. Our app is running on
> Solaris 2.6, w/ND4.1.3, SqlNet8.0.4.
>
> The users are getting occasional ORA-3113 and ORA-12545 errors, and I found
> the below errors in our sqlnet.log file.
>
> Anyone seen this before and have a clue what might cause this?
> I have our DBA folks looking into it, but thought I would see if anyone here
> had seen it.
>
> ***********************************************************************
> Fatal NI connect error 12545, connecting to:
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/home/oracle/product/8.0.4/bin/
> oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))
> )')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=easap1)(USER=netdyn))))
>
> VERSION INFORMATION:
> TNS for Solaris: Version 8.0.4.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for Solaris: Version 8.0.4.0.0 -
> Production
> TCP/IP NT Protocol Adapter for Solaris: Version 8.0.4.0.0 -
> Production
> Time: 16-APR-99 10:02:53
> Tracing not turned on.
> Tns error struct:
> nr err code: 12206
> TNS-12206: TNS:received a TNS error during navigation
> ns main err code: 12545
> TNS-12545: Connect failed because target host or object does not exist
> ns secondary err code: 12560
> nt main err code: 515
> TNS-00515: Connect failed because target host or object does not exist
>
> > John Hoskins
> > TDS Computing Services
> > Internet Technology Team
> > [EMAIL PROTECTED]
> > 608.664.8263
> > 608.664.8288 (fax)
> _________________________________________________________________________
>
> For help in using, subscribing, and unsubscribing to the discussion
> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
> For dire need help, email: [EMAIL PROTECTED]
--
--------------------------------------------------------
Mary Hill 2919 Taubman Library
[EMAIL PROTECTED] 1135 E. Catherine
University of Michigan Ann Arbor, MI
Med School Information Systems 48109-0726
734-763-6752
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
