Re: ORA-12500 TNS-12560 TNS-00530

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Thu, 13 Mar 2003 21:00:08 +0100
Message-ID: <ako17vsbssca2r5h4ej8vqmailga3j6ehc@4ax.com>

On 13 Mar 2003 11:15:08 -0800, Rogbaker_at_gdi.net (Rogbaker) wrote:

>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
>******

Your services.ora is incorrect. The Intelligent Agent *has* to use TCP/IP instead of BEQueath. As the services.ora is generated from tnsnames.ora, likely this file and/or sqlnet.ora is also incorrect. Wipe all files in %ORACLE_HOME%\network\agent, stop the Agent service and restart it.
Try setting sqlnet.authentication_services=none in sqlnet.ora Also the Intelligent Agent can't have service_name = in the connect descriptor in tnsnames.ora

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 13 2003 - 14:00:08 CST