Klint,
Thanks for the feedback.
This app has been working fine, with these occasional errors.
These errors have been showing up mostly today, according to our logs. I'm
considering putting in some db error recovery plans to just have it redo the
call.
> John Hoskins
> TDS Computing Services
> Internet Technology Team
> [EMAIL PROTECTED]
> 608.664.8263
> 608.664.8288 (fax)
>
> ----------
> From: Klinton Lee[SMTP:[EMAIL PROTECTED]]
> Sent: 4/16/1999 11.04 AM
> To: Hoskins, John D.; 'nd4 forum'
> Subject: Re: [ND] errors in sqlnet.log file.
>
> Hi John,
>
> I've seen 12545, error 3113 is similar.
>
> Here are a couple of things to try:
>
> It may be a network 'glitch', if the application was working before.
>
> Offhand, check the configuration/setup (DBAs too, ie...listener process).
> You might want to try fully qualifying your hostname 'easap1' or using the
> IP address.
>
> Hope this helps...
> Klint
>
> -----------------------------------------------------------
> ORA-03113: end-of-file on communication channel
>
> Cause: An unexpected end-of-file was processed on the communication
> channel.
> The problem could not be handled by the Net8, two task, software. This
> message could occur if the
> shadow two-task process associated with a Net8 connect has terminated
> abnormally, or if there is a physical failure of the interprocess
> communication vehicle, that is, the network or
> server machine went down.
>
> Action: If this message occurs during a connection attempt, check the
> setup
> files for the appropriate Net8 driver and confirm Net8 software is
> correctly
> installed on the server. If the
> message occurs after a connection is well established, and the error is
> not
> due to a physical failure, check if a trace file was generated on the
> server
> at failure time. Existence of a trace file
> may suggest an Oracle internal error that requires the assistance of
> customer support.
>
>
> ORA-12545:
> Cause: The address specified is not valid, or the program being connected
> to
> does not exist.
>
> Action: Ensure the ADDRESS parameters have been entered correctly; the
> most
> likely incorrect parameter is the node name. Ensure that the executable
> for
> the server exists (perhaps
> "oracle" is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA
> file
> to change the host name to a numeric IP address and try again.
>
> > -----Original Message-----
> > From: Hoskins, John D. [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, April 16, 1999 8:32 AM
> > To: 'nd4 forum'
> > Subject: [ND] errors in sqlnet.log file.
> >
> >
> > 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=(PROT
> OCOL=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]
> >
>
> _________________________________________________________________________
>
> 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]
>
_________________________________________________________________________
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]
