3 Replies Latest reply on Aug 4, 2009 9:35 PM by rsar001

    Error in the alert Log

    rsar001
      Hi There,
      Recently I started seeing these errors in the alert log for one of the databases:

      Tue Aug 04 05:05:00 2009
      Errors in file c:\oracle\product\10.2.0\admin\xxxxxx\bdump\xxxxxx_j000_6104.trc:
      ORA-12012: error on auto execute of job 130961
      ORA-27370: job slave failed to launch a job of type EXECUTABLE
      ORA-27300: OS system dependent operation:accessing execution agent failed with status: 109
      ORA-27301: OS failure message: The pipe has been ended.
      ORA-27302: failure occurred at: sjsec 9
      ORA-27303: additional information: The pipe has been ended.


      So, I tried looking at the trace file associated with the error, and here is what I get:


      $ cat ebcd01_j000_6104.trc
      Dump file c:\oracle\product\10.2.0\admin\xxxxxx\bdump\xxxxxx_j000_6104.trc
      Tue Aug 04 05:05:00 2009
      ORACLE V10.2.0.3.0 - Production vsnsta=0
      vsnsql=14 vsnxtr=3
      Oracle Database 10g Release 10.2.0.3.0 - Production
      Windows Server 2003 Version V5.2 Service Pack 1
      CPU : 4 - type 586, 2 Physical Cores
      Process Affinity : 0x00000000
      Memory (Avail/Total): Ph:1095M/4095M, Ph+PgF:7747M/12110M, VA:1367M/2047M
      Instance name: ebcd01

      Redo thread mounted by this instance: 1

      Oracle process number: 53

      Windows thread id: 6104, image: ORACLE.EXE (J000)


      *** ACTION NAME:(DEL_ARCH_EBCP01) 2009-08-04 05:05:00.191
      *** MODULE NAME:(DBMS_SCHEDULER) 2009-08-04 05:05:00.191
      *** SERVICE NAME:(SYS$USERS) 2009-08-04 05:05:00.191
      *** SESSION ID:(871.15642) 2009-08-04 05:05:00.191
      *** 2009-08-04 05:05:00.191
      ORA-12012: error on auto execute of job 130961
      ORA-27370: job slave failed to launch a job of type EXECUTABLE
      ORA-27300: OS system dependent operation:accessing execution agent failed with status: 109
      ORA-27301: OS failure message: The pipe has been ended.
      ORA-27302: failure occurred at: sjsec 9
      ORA-27303: additional information: The pipe has been ended.

      I'm not sure what job is causing this as there is no reference and also not sure how to resolve this issue!! How can I properly trace back these errors? Any ideas or tips to what should I do?

      I'm running 10.2.0.3 database on windows 2003 server.

      Thanks