Re: ORA-12500 TNS-12560 TNS-00530

From: Rogbaker <Rogbaker_at_gdi.net>
Date: 13 Mar 2003 11:15:08 -0800
Message-ID: <e40a12ea.0303131115.5d014575@posting.google.com>

Flavio,
Actually there are two databases on that machine WDEV and TEST. The TEST database is shutdown. In the nmi.log, the error code differs slightly for those two databases.
In the nmi.log, the pertinent messages for WDEV are:

---

Fatal NI connect error 12640, connecting to:  

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEWDEV)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)

))'))(CONNECT_DATA=(CID=(PROGRAM=E:\oracle\ora81\bin\dbsnmp.exe)(HOST=ESC-AD-ORAWEB1)(USER=SYSTEM))))

  VERSION INFORMATION:

	TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
8.1.7.0.0 - Production
	Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version

8.1.7.0.0 - Production
  Time: 13-MAR-2003 12:06:17
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12640
    TNS-12640: Authentication adapter initialization failed     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

These errors are occuring every 30 seconds.

"FC" <flavio_at_tin.it> wrote in message news:<ibqba.55817$zo2.1556460_at_news2.tin.it>...
> Nmi.log is the log file created by the Intelligent Agent and you can get
> that error in a variety of situations, one of the most likely to happen
> being the database not yet started. Since the Intelligent Agent 'contacts'
> the services listed in the services.ora file every 30 seconds or so, every
> time it doesn't get an answer, it logs the event in the nmi.log file.
> Is the oracle instance mentioned in the log file below (TEST apparently) the
> one you are trying to connect to or isn't it a test instance or alike that
> is normally shut down?
>
> The second log is probably more significant however I could not understand
> under which circumstances you get this problem, but it's definitely
> something that doesn't happen during the night, the timestamp in these log
> files shows a problem occurring in the morning after 9 o'clock, you should
> pick the log files portions reporting the problem when the job runs
> actually.
>
>
> Bye,
> Flavio
>
>
>
> "Rogbaker" <Rogbaker_at_gdi.net> wrote in message
> news:e40a12ea.0303110627.66812b43_at_posting.google.com...
> > Thanks, that's handy to know about the Truncate option. I will
> > definitely be trying that as one task would be simpler.
> >
> > Yes, the automated task is the same account as what I use when I run
> > it manually in the morning.
> >
> > Here is some more info though. I am seeing errors that I am sure are
> > releated.
> >
> > In the nmi.log I see the following error a lot:
> > ***********************************************************************
> > Fatal NI connect error 12560, connecting to:
> >
> (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLETEST)(ARGS=
> '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(CID=(PRO
> GRAM=E:\oracle\ora81\bin\dbsnmp.exe)(HOST=ESC-AD-ORAWEB1)(USER=SYSTEM))))
> >
> > VERSION INFORMATION:
> > TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
> > Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
> > 8.1.7.0.0 - Production
> > Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version
> > 8.1.7.0.0 - Production
> > Time: 11-MAR-2003 09:21:48
> > Tracing not turned on.
> > Tns error struct:
> > nr err code: 0
> > ns main err code: 12560
> > TNS-12560: TNS:protocol adapter error
> > ns secondary err code: 0
> > nt main err code: 530
> > TNS-00530: Protocol adapter error
> > nt secondary err code: 2
> > nt OS err code: 0
> >
> >
> > ***********************************************************************
> > and in the sqlnet.log I see:
> >
> > Fatal NI connect error 12640, connecting to:
> > (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> >
> > VERSION INFORMATION:
> > TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
> > Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
> > 8.1.7.0.0 - Production
> > Time: 11-MAR-2003 09:22:18
> > Tracing not turned on.
> > Tns error struct:
> > nr err code: 0
> > ns main err code: 12640
> > TNS-12640: Authentication adapter initialization failed
> > ns secondary err code: 0
> > nt main err code: 0
> > nt secondary err code: 0
> > nt OS err code: 0
> >
> >
> > ***********************************************************************
Received on Thu Mar 13 2003 - 13:15:08 CST