Home » RDBMS Server » Server Utilities » ORA-27369: job of type EXECUTABLE failed with exit code: Not owner (Oracle 10.2.0.3 ; OS: IBM AIX)
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner [message #295293] Tue, 22 January 2008 00:56 Go to next message
jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007
Junior Member
Hi All,

I planned to create a job to do rman backup daily at 04:00 AM.
1. I created a program as follows
BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM(
program_name => 'rman_backup_prg',
program_action => '/u02/rmanback/rman.sh',
program_type => 'EXECUTABLE',
comments => 'RMAN BACKUP');
END;
/

my rman script is

#!/usr/bin/ksh
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export PATH=$PATH:/u01/app/oracle/product/10.2.0/db_1/bin
/u01/app/oracle/product/10.2.0/db_1/bin/exp rman/cat@catdb file=/u02/rmanback/rm
an_220108.dmp log=/u02/rmanback/rman_220108.log owner=rman statistics=none comp
ress=n buffer=400000
compress *.dmp
exit

2. I created a schedule as follows

BEGIN
DBMS_SCHEDULER.CREATE_SCHEDULE(
schedule_name => 'rman_backup_schedule',
start_date => SYSTIMESTAMP,
end_date => '31-DEC-16 05.00.00 AM',
repeat_interval => 'FREQ=DAILY; BYHOUR=4',
comments => 'Every day at 4 am');
END;
/

3. I created ajob as follows.

BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'rman_backup_job',
program_name => 'rman_backup_prg',
schedule_name => 'rman_backup_schedule',
enabled=> true,
auto_drop=> false
);
END;
/

While I am running the job I am getting the following error anybody help me.

ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 2

If I removed "compress *.dmp" line in rman script it is working fine.

Regards,
Kiran
Re: ORA-27369: job of type EXECUTABLE failed with exit code: Not owner [message #295294 is a reply to message #295293] Tue, 22 January 2008 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button to verify.

"ls -l *.dmp"
Are you able to manually compress the files WITH THE USER THAT EXECUTES THE JOB?

Regards
Michel
Re: ORA-27369: job of type EXECUTABLE failed with exit code: Not owner [message #295306 is a reply to message #295294] Tue, 22 January 2008 01:42 Go to previous messageGo to next message
jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007
Junior Member
Hi Michel,

Thanks for you guidance. I can abel to compress *.dmp file from OS user oracle/root manually. Any suggessions please.

Regards,
Kiran
Re: ORA-27369: job of type EXECUTABLE failed with exit code: Not owner [message #295312 is a reply to message #295306] Tue, 22 January 2008 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who is the owner of the file? Who is the owner of directory? Who is the owner of the instance? Who is the owner of the shell?...

Regards
Michel
Re: ORA-27369: job of type EXECUTABLE failed with exit code: Not owner [message #295318 is a reply to message #295312] Tue, 22 January 2008 02:06 Go to previous messageGo to next message
jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007
Junior Member
Hi Michel,

I gave complete path of for compress command and for dump file.
Its worked now.

Regards,
Kiran
Re: ORA-27369: job of type EXECUTABLE failed with exit code: Not owner [message #295328 is a reply to message #295318] Tue, 22 January 2008 02:31 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Doh! Thanks for the feedback.

Regards
Michel
Previous Topic: SQL Loader-Need to update or insert
Next Topic: problem to open SQLLDR
Goto Forum:
  


Current Time: Sun Dec 04 12:41:22 CST 2016

Total time taken to generate the page: 0.11982 seconds