oracle10g schedule problem
上一篇 /
下一篇 2008-06-05 21:14:35
/ 个人分类:Tool
sql>select job_name,status,additional_info from user_scheduler_job_details;
EXP_JOB
JOB_NAME
--------------------------------------------------------------------------------
STATUS
------------------------------
ADDITIONAL_INFO
--------------------------------------------------------------------------------
FAILED
ORA-27369: job of typeEXECUTABLE failedwith 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"
在你的脚本中如果涉及有连接数据库时,即使是连接本地数据库也要使用连接字符串来连接数据库。
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG: