Problem with jobs in Enterprise Manager

From: Marc Eggenberger <marc.eggenberger_at_itc.alstom.com>
Date: Tue, 27 May 2003 16:59:09 +0200
Message-ID: <MPG.193d9ba84d0ea0979896a2@H02374>

Hi there.

I have Oracle 8.1.6
Enterprise Manager 2.1.0.1.0
On Windows 2000 Advanced Server

When I submit jobs with a database as target some of the jobs stay at planned and are not executed.

In the nmi.log I have the following entries repeting all over:

Fatal NI connect error 12560, connecting to:  (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEGCR) (ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')) (CONNECT_DATA=(CID=(PROGRAM=E:\Oracle\Ora81\bin\dbsnmp.exe)(HOST=CHKRA- 0001-A054)(USER=SYSTEM))))   VERSION INFORMATION:

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

8.1.6.0.0 - Production
  Time: 27-MAI-2003 16:49:36
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNS: Protokolladapterfehler     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protokolladapter-Fehler
    nt secondary err code: 0
    nt OS err code: 0

I assume that the IA has some problems with connecting. Right? The protocol bequeath is used. Argv0 is ORACLEGCR. I dont have an entry in tnsnames.ora for that. Is is needed? Also for bequeath?

My tnsnames.ora is:

EXTPROC_CONNECTION_DATA.CH.POWER.ALSTOM.COM =   (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

GCR =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chkra-0001-a054)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = GCR)

    )
  )

REP60_CHKRA-0001-A054-ORAREP =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chkra-0001-a054)(PORT = 1949))
    )
    (CONNECT_DATA =
(SERVICE_NAME = GCR)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

HSODBC.CHKRA-0001-A054 = (DESCRIPTION=

            (ADDRESS=(PROTOCOL=tcp)(HOST=CHKRA-0001-A054)(PORT=1521))
            (CONNECT_DATA=(SID=hsodbc))
            (HS=OK)
          ) 

Anyone has some hints where I should look into?

-- 
mfg
Marc Eggenberger

Received on Tue May 27 2003 - 09:59:09 CDT