新加的一个SCHEDULER作业，用普通用户执行报权限不足
作业上线后alter日志里面报：
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
trace文件里记录：
*** 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)
从这两行可以看出来是SCHEDULER调度作业出现了问题，ACTION NAME其实就是SCHEDULER作业的job_name
检查这个作业
大概意思如下：
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" << EOF
spool $LOGFILE
select sysdate from dual;
spool off
exit
EOF
刚开始怀疑是这个用户没有相应的执行权限，但是查看权限后并不是这个原因
后来查阅了一些资料，解决了这个问题
# cd $ORACLE_HOME/rdbms/admin/
# chown root:oinstall externaljob.ora
# chmod 640 externaljob.ora
# ll externaljob.ora
-rw-r----- 1 root oinstall 1534 Oct 15 17:51 externaljob.ora
# vim externaljob.ora
run_user = oracle
run_group = oinstall
# ll ../../bin/extjob
-rwxr-x--- 1 oracle oinstall 1223972 Nov 26 2012 ../../bin/extjob
# chmod 4750 ../../bin/extjob
# ll ../../bin/extjob
-rwsr-x--- 1 oracle oinstall 1223972 Nov 26 2012 ../../bin/extjob
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024