Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error in the alert Log

rsar001Aug 4 2009 — edited Aug 4 2009
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

Comments

sb92075
ORA-27303: additional information: The pipe has been ended.
Your pipe burst.

Restart the s/w that was reading data from Oracle's pipe.
591186
Metalink notes:
Command Bat File Scheduled Through Dbms_schedule In Em Fails ORA-27370-285313.1
Problem: OS Command Job on Windows fails with ORA-27370: Job Slave Failed To Launch -758739.1


HTH
Anantha
rsar001
I found the problem.. the executable job was referring to a none existing batch file..

I have refreshed the database from production some time ago and the jobs I have setup are referring to production scripts and paths (which we didnt have on dev)..

This is now resolved.


Thanks
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 1 2009
Added on Aug 4 2009
#general-database-discussions
3 comments
1,882 views