适用于:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.1 - Release: 10.1 to 10.2
HP-UX PA-RISC (64-bit)
症状:
当program_type是可执行的时,DBMS_SCHEDULER作业计划失败。接收到如下错误信息:
ORA-12012: error on auto execute of job 71010
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing execution agent failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sjsec 3
原因:
在大多数UNIX上,这个可执行的作业需要拥有操作系统用户(nobody)权限。
就像Solaris操作系统的环境,在HP-UX中,‘nobody’用户不是一个低权限的用户,并且它不是已知的。
什么是低权限用户,就是root.sh移动extjob到extjob.nobody。当extjob变得不可得到,这个计划作业就会以如下信息而告之失败:‘No such file or directory’。
解决:
对于10.1版本,请在如下文件参考权限设置:
Ø Error in writing to file $ORACLE_HOME/bin/extjob (Permission denied)
对于10.2.0.1版本,请作如下操作:
在安装期间执行root.sh脚本文件之后,使用root用户输入如下命令:
# cd oracle_home/bin
# mv extjob.nobody extjob
# chown extjob extjob
# chmod 6555 extjob
上述步骤都记录在HP-UX平台上的oracle安装指南中,如下:
Oracle� Database Installation Guide
10g Release 2 (10.2) for hp-ux PA-RISC (64-Bit)
Part Number B19068-02
4 Postinstallation Tasks
For 10.2.0.2 and above:
The right 'extjob' settings are:
$ ls -l extjob
-rwsr-x--- 1 root oinstall 26951 Nov 16 15:29 extjob
$ ls -l ex*.ora
-rw-r----- 1 root oinstall 1534 Dec 21 2005 externaljob.ora
This is verified in
> SCHEDULED JOB RUNNING SHELL SCRIPT FAILS WITH ORA-27369
as well as > Scheduled Job Running Shell Script Fails With ORA-27369
and 11g documentation: http://st-doc.us.oracle.com/review/HPDBI/html/post_inst_task.htm#CHDICIGE
Therefore, starting 10.2.0.2 please follow the settings in
> Scheduled Job Running Shell Script Fails With ORA-27369