Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "SCHEDULER ORA-27369 Error How to Solve". In the actual case operation process, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

Add a new SCHEDULE job, using ordinary users to execute reports insufficient permissions

After the job was launched, the alter log reported:

ORA-12012: error on auto execute of job 318537

ORA-27369: job of type EXECUTABLE failed with exit code: Permission denied

Tue Oct 15 10:31:00 2013

The trace file records:

*** 2013-10-15 10:30:10.920

*** SESSION ID:(717.33910) 2013-10-15 10:30:10.920

*** CLIENT ID:() 2013-10-15 10:30:10.920

*** SERVICE NAME:(SYS$USERS) 2013-10-15 10:30:10.920

*** MODULE NAME:(DBMS_SCHEDULER) 2013-10-15 10:30:10.920

*** ACTION NAME:(PRODUCT_UP131015103008879041) 2013-10-15 10:30:10.920

MODULE NAME:(DBMS_SCHEDULER)

ACTION NAME:(PRODUCT_UP131015103008879041)

From these two lines, it can be seen that there is a problem with SCHEDULE scheduling job. ACTION NAME is actually the job_name of SCHEDULE job.

Check this assignment.

It roughly means:

begin

dbms_scheduler.create_job(

job_name => 'goolen_job',

job_type => 'EXECUTABLE',

job_action => '/home/oracle/task/goolen.sh',

start_date => systimestamp,

number_of_arguments => 0,

enabled => true,

auto_drop => true,

comments => 'ShangJia');

end;

/

[oracle@goolen]$ cat goolen.sh

#!/ bin/sh

source ~/.bash_profile

export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

DATE=`date +%Y%m%d_%H%M%S`

LOGFILE=/tol/logs/product/goolen.log

$ORACLE_HOME/bin/sqlplus -S "newcourse/XXXXXX"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.