Home » RDBMS Server » Server Administration » EXECUTABLE JOB fail
EXECUTABLE JOB fail [message #256792] Mon, 06 August 2007 13:10 Go to next message
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
Re: EXECUTABLE JOB fail [message #256799 is a reply to message #256792] Mon, 06 August 2007 13:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Are you sure it exists on the SERVER?

Regards
Michel
Re: EXECUTABLE JOB fail [message #256870 is a reply to message #256799] Mon, 06 August 2007 23:38 Go to previous messageGo to next message
khosravi
Messages: 68
Registered: April 2006
Member
yes ,i am sure
Re: EXECUTABLE JOB fail [message #256881 is a reply to message #256870] Tue, 07 August 2007 00:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
But maybe it is 'C:\RMAN.BAT'?

Regards
Michel
Re: EXECUTABLE JOB fail [message #256937 is a reply to message #256881] Tue, 07 August 2007 03:43 Go to previous messageGo to next message
khosravi
Messages: 68
Registered: April 2006
Member
'c:\rman.bat' exists
Re: EXECUTABLE JOB fail [message #256938 is a reply to message #256937] Tue, 07 August 2007 03:48 Go to previous messageGo to next message
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?
Re: EXECUTABLE JOB fail [message #256944 is a reply to message #256937] Tue, 07 August 2007 04:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
'c:\rman.bat' exists

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

In UPPER case.

Regards
Michel
Re: EXECUTABLE JOB fail [message #256957 is a reply to message #256938] Tue, 07 August 2007 04:54 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: EXECUTABLE JOB fail [message #256974 is a reply to message #256959] Tue, 07 August 2007 05:20 Go to previous messageGo to next message
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
Re: EXECUTABLE JOB fail [message #257095 is a reply to message #256974] Tue, 07 August 2007 10:20 Go to previous messageGo to next message
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?
Re: EXECUTABLE JOB fail [message #257116 is a reply to message #257095] Tue, 07 August 2007 10:48 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
but now i have another question . what service i must run for executable jobs in unix plateform?


On Unix there are few services for

OEM
ISQLPLUS
AGENT

Not like windows.
Re: EXECUTABLE JOB fail [message #257130 is a reply to message #257116] Tue, 07 August 2007 11:14 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

In windows platform...

we need to also start below services if we are using...

1.oem ----OracleDBConsole<sid>
emctl start dbconsole 


2.isqlplus---<OracleOraDb10g_home1iSQL*Plus>
isqlplusctl start


3.agent
emctl agent start


Regards
Taj


Previous Topic: what is difference between startup mount and startup nomount
Next Topic: Reindex database
Goto Forum:
  


Current Time: Thu Dec 12 05:46:34 CST 2024