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:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-09-08  
 123456
78910111213
14151617181920
21222324252627
282930    

数据统计

  • 访问量: 610
  • 日志数: 28
  • 文件数: 6
  • 建立时间: 2008-04-26
  • 更新时间: 2008-09-03

RSS订阅

Open Toolbar