OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » EXECUTABLE JOB fail

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXECUTABLE JOB fail [message #256792]

Mon, 06 August 2007 13:10

khosravi
Messages: 68
Registered: April 2006

Member

hello

i have created this job

BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'bj2',
job_type => 'EXECUTABLE',
job_action => 'c:\rman.bat',
enabled => TRUE
);
END;
/

when i execute this i receive this error:

Details ORA-27370: job slave failed to launch a job of type EXECUTABLE ORA-27300: OS system dependent operation:accessing execution agent failed with status: 2 ORA-27301: OS failure message: The system cannot find the file specified. ORA-27302: failure occurred at: sjsec 6 ORA-27303: additional information: The system cannot find the file specified.

but i am sure that 'c:\rman.bat' exists

can you help me?
thnaks

Report message to a moderator

Re: EXECUTABLE JOB fail [message #256799 is a reply to message #256792]

Mon, 06 August 2007 13:29

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are you sure it exists on the SERVER?

Regards
Michel

Report message to a moderator

Re: EXECUTABLE JOB fail [message #256870 is a reply to message #256799]

Mon, 06 August 2007 23:38

khosravi
Messages: 68
Registered: April 2006

Member

yes ,i am sure

Report message to a moderator

Re: EXECUTABLE JOB fail [message #256881 is a reply to message #256870]

Tue, 07 August 2007 00:18

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

But maybe it is 'C:\RMAN.BAT'?

Regards
Michel

Report message to a moderator

Re: EXECUTABLE JOB fail [message #256937 is a reply to message #256881]

Tue, 07 August 2007 03:43

khosravi
Messages: 68
Registered: April 2006

Member

'c:\rman.bat' exists

Report message to a moderator

Re: EXECUTABLE JOB fail [message #256938 is a reply to message #256937]

Tue, 07 August 2007 03:48

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

And the user that is running the oracle service has permission do read it?

Report message to a moderator

Re: EXECUTABLE JOB fail [message #256944 is a reply to message #256937]

Tue, 07 August 2007 04:19

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

'c:\rman.bat' exists

Quote:

But maybe it is 'C:\RMAN.BAT'?

In UPPER case.

Regards
Michel

Report message to a moderator

Re: EXECUTABLE JOB fail [message #256957 is a reply to message #256938]

Tue, 07 August 2007 04:54

khosravi
Messages: 68
Registered: April 2006

Member

hello ThomasG

how i can find out this ? what is your mean about "has permission do read it" ?

[Updated on: Tue, 07 August 2007 04:56]

Report message to a moderator

Re: EXECUTABLE JOB fail [message #256959 is a reply to message #256957]

Tue, 07 August 2007 05:02

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

You don't even know what permissions are?
And you try to create an Oracle job?

You know, permissions on a file?

"Right-Click -> Properties" in Explorer, tab "Security"?

http://support.microsoft.com/kb/308418

Report message to a moderator

Re: EXECUTABLE JOB fail [message #256974 is a reply to message #256959]

Tue, 07 August 2007 05:20

khosravi
Messages: 68
Registered: April 2006

Member

i know what is permission
and i know that for executing a program i must have necessary permission

i thought your mean is doing something in Oracle

Report message to a moderator

Re: EXECUTABLE JOB fail [message #257095 is a reply to message #256974]

Tue, 07 August 2007 10:20

khosravi
Messages: 68
Registered: April 2006

Member

i find solution
i runed "OracleJobSchedule[sid]" Service in windows
and the problem resolved

but now i have another question . what service i must run for executable jobs in unix plateform?

Report message to a moderator