ORA-27369 - Operation not permitted STANDARD_ERROR="
Hi,
I created the following scheduler job to do expdp:
BEGIN
sys.dbms_scheduler.create_job(
job_name => '"SYS"."EXPORT_DADOS_SCHEMA"',
job_type => 'EXECUTABLE',
job_action => '/u01/backup/expdpn.sh',
repeat_interval => 'FREQ=DAILY;BYHOUR=23;BYMINUTE=0;BYSECOND=0',
start_date => systimestamp at time zone '-4:00',
job_class => '"DEFAULT_JOB_CLASS"',
comments => 'Exporta os dados de um schema',
auto_drop => FALSE,
enabled => FALSE);
sys.dbms_scheduler.set_attribute( name => '"SYS"."EXPORT_DADOS_SCHEMA"', attribute => 'logging_level', value => DBMS_SCHEDULER.LOGGING_OFF);
sys.dbms_scheduler.enable( '"SYS"."EXPORT_DADOS_SCHEMA"' );
END;
Content file expdpn.sh:
#!/bin/bash
. /u01/oracle11g.sh
rm -rf /u01/backup/rmdp.dmp
rm -rf /u01/backup/rmdp.log
expdp system/dw7txp508432@sesa directory=backup dumpfile=rmdp.dmp logfile=rmdp.log schemas=rm flashback_time=systimestamp
The scheduler runs normally, the dmp file is generated successfully.
But the following error (failed) occurs in the scheduler log:
ORA-27369: o trabalho do tipo EXECUTABLE falhou com código de saída: Operation not permitted STANDARD_ERROR=" Export: Release 11.2.0.3.0 - Production on Qua Set 26 07:28:00 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Conectado a: Oracle Database 11g Release 11.2.0.3.0"
Can someone help me.
Thanks,
Rodrigo