软件开发Oracle商业智能

datastagev8.1 无法连接oracle

监听器已经配置好了一下两种方式,均可成功登陆sqlplus scott/tigersqlplus scott/tiger@orcl但是,我在datastage中,新建了一个并行的job,把oracle中的一个表的数据导出到一个文件中去。编译通过了,执行的时候,报错。以下是日志信息 ##I IIS-DSEE-TFCN-00001 15:32:14(000) IB...显示全部
监听器已经配置好了一下两种方式,均可成功登陆
sqlplus scott/tiger
sqlplus scott/tiger@orcl

但是,我在datastage中,新建了一个并行的job,把oracle中的一个表的数据导出到一个文件中去。
编译通过了,执行的时候,报错。

以下是日志信息
##I IIS-DSEE-TFCN-00001 15:32:14(000)
IBM WebSphere DataStage Enterprise Edition 8.1.0.5000
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 15:32:14(001) conductor uname: -s=Linux; -r=2.6.18-238.el5; -v=#1 SMP Sun Dec 19 14:22:44 EST 2010; -n=tlpc; -m=x86_64
##I IIS-DSEE-TOSH-00002 15:32:14(002) orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 15:32:14(003) orchsort: loaded
##I IIS-DSEE-TOSH-00002 15:32:14(004) orchstats: loaded
ORA-12514: TNS:listener does not currently know of service requested i
>##E IIS-DSEE-TDOR-00578 15:32:14(006) Connect failed: ORA-12514: TNS:listener does not currently know of service requested i
>##E IIS-DSEE-TDOR-00140 15:32:14(007) APT_OraReadOperator: connect failed.
>##E IIS-DSEE-TOPK-00007 15:32:14(011) <_PEEK_IDENT_> Input dataset does not have field: "CSMC".
>##E IIS-DSEE-TOPK-00007 15:32:14(012) <_PEEK_IDENT_> Input dataset does not have field: "ZDBZ".
>##E IIS-DSEE-TOPK-00007 15:32:14(013) <_PEEK_IDENT_> Input dataset does not have field: "CSMS".
>##E IIS-DSEE-TOPK-00007 15:32:14(014) <_PEEK_IDENT_> Input dataset does not have field: "CSZ".
>##E IIS-DSEE-TFSR-00019 15:32:14(016) Could not check all operators because of previous error(s)
##W IIS-DSEE-TFIP-00093 15:32:14(017) When checking operator: The modify operator has a binding for the non-existent output field "CSMC".
##W IIS-DSEE-TFIP-00093 15:32:14(018) When checking operator: The modify operator has a binding for the non-existent output field "ZDBZ".
##W IIS-DSEE-TFIP-00093 15:32:14(019) When checking operator: The modify operator has a binding for the non-existent output field "CSMS".
##W IIS-DSEE-TFIP-00093 15:32:14(020) When checking operator: The modify operator has a binding for the non-existent output field "CSZ".
##W IIS-DSEE-TFIP-00096 15:32:14(021) When checking operator: The modify operator keeps field "CSMC" which is not present in the output interface.
##W IIS-DSEE-TFIP-00096 15:32:14(022) When checking operator: The modify operator keeps field "ZDBZ" which is not present in the output interface.
##W IIS-DSEE-TFIP-00096 15:32:14(023) When checking operator: The modify operator keeps field "CSMS" which is not present in the output interface.
##W IIS-DSEE-TFIP-00096 15:32:14(024) When checking operator: The modify operator keeps field "CSZ" which is not present in the output interface.
>##E IIS-DSEE-TCOS-00029 15:32:14(025) Creation of a step finished with status = FAILED.收起
参与3

返回resistant的回答

resistantresistant软件开发工程师长城信息有限公司
兄弟,是连接数据库时,连接串出错,没连接上吧,现在解决了?
互联网服务 · 2013-01-25
浏览1850

回答者

resistant
软件开发工程师长城信息有限公司

resistant 最近回答过的问题

回答状态

  • 发布时间:2013-01-25
  • 关注会员:2 人
  • 回答浏览:1850
  • X社区推广