0 Replies Latest reply: Sep 26, 2012 8:24 AM by 964535 RSS

    ORA-27369 - Operation not permitted STANDARD_ERROR="

    964535
      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