Thanks for the feedback.
I believe that I will be adding the error recovery plan for these problems.
The server DB is up and running just fine, so I don't think that's the
problem.
> John Hoskins
> TDS Computing Services
> Internet Technology Team
> [EMAIL PROTECTED]
> 608.664.8263
> 608.664.8288 (fax)
>
> ----------
> From: Mary Hill[SMTP:[EMAIL PROTECTED]]
> Sent: 4/16/1999 11.32 AM
> To: Hoskins, John D.
> Cc: 'nd4 forum'
> Subject: Re: [ND] errors in sqlnet.log file.
>
> 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/bi
> n/
> >
> 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]
