ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle10g schedule problem

oracle10g schedule problem

原创 Linux操作系统 作者:benn_wpj 时间:2008-06-05 21:14:35 0 删除 编辑

sql>select job_name,status,additional_info from user_scheduler_job_details;

EXP_JOB

JOB_NAME
--------------------------------------------------------------------------------
STATUS
------------------------------
ADDITIONAL_INFO
--------------------------------------------------------------------------------
FAILED
ORA-27369: job of type EXECUTABLE failed with exit code: 255
STANDARD_ERROR="execve: Exec format error"

EXP_JOB
FAILED
ORA-27369: job of type EXECUTABLE failed with exit code: 255


$ORACLE_HOME/bin/extjob
chmod a+rx $ORACLE_HOME/bin/extjob 或者使用命令chmod a+rx {you_script}


sql>select job_name,status,additional_info from user_scheduler_job_details;

EXP_JOB

JOB_NAME
--------------------------------------------------------------------------------
STATUS
------------------------------
ADDITIONAL_INFO
--------------------------------------------------------------------------------
FAILED
ORA-27369: job of type EXECUTABLE failed with exit code: Operation not permitted

STANDARD_ERROR="
Export: Release 10.2.0.3.0 - Production on Thu Jun 5 12:51:39 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

JOB_NAME
--------------------------------------------------------------------------------
STATUS
------------------------------
ADDITIONAL_INFO
--------------------------------------------------------------------------------


EXP-00056: ORACLE error 12162 encountered
ORA-12162: TNS:net service name"

在你的脚本中如果涉及有连接数据库时,即使是连接本地数据库也要使用连接字符串来连接数据库。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/13790829/viewspace-332643/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-04-26

  • 博文量
    57
  • 访问量
    137425