深蓝快车
专业技术服务提供商;专业存储设备提供商

DataStage连接Oracle 数据库失败,但是job一运行就报错ORA-121541;TNS:no listener -->解决方法

产品

技术

配件

IT疑难问题解决方案1

IT疑难问题解决方案2

小型机服务

服务器服务

存储服务

维保

机房搬迁

操作系统|双机

数据库

备份/恢复

Oracle灾备

应急服务

楼宇监控

深蓝快车

技术中心

案例

联系我们

datastage 无法启动服务
datastage连接中断(81002)
datastage 连接 Oracle 数据库问题
datastage源端能连接数据库,但是job一运行就报错ORA-12154;TNS:could not resolve the connect identifier specified;
datastage sequence 调度出现的错误问题
datastage sequence 调度失败
datastage sequence 调度失败
datastage VersionControl问题
DataStage Designer-->job-->ORA-01400:cannot insert NULL into
DataStage Administrator-->login failed
DataStage Director Moniter-->Job 状态长时间 Running
DataStage Director-->job-->inserted value too large for column,row rejected
DataStage Director-->login failed
DataStage Director-->job-->ORA-00060:deadlock detected while waiting for resource
DataStage Director Detail-->ORA-01017: invailed username/password;logon denied
DataStage Director-->job-->ORA-01427: single-row subquery returns more than one row
DataStage Director Detail-->ORA-01830: date format picture ends before converting entire input string
DataStage Director-->job-->ORA-01843: not a valid month into
DataStage Director-->job-->ORA-02291:integrity constraint () violated - parent key not found
DataStage Director Detail-->ORA-12154: TNS:could not resolve service name
DataStage Director Detail-->ORA-12170: TNS: Connect timeout occurred
DataStage Director Detail-->ORA-12535:TNS: Operation timed out
DataStage连接Oracle 数据库失败,但是job一运行就报错ORA-121541;TNS:no listener
DataStage Designer-->job-->ORA-01400:cannot insert NULL into
DataStage Director RunMainControl Abort状态
ORA-12154: TNS: 无法处理服务名
ORA-12203: TNS:无法与目标连接
ORA-12500:TNS:监听程序无法启动专用服务器进程
TNS-12560:协议适配器错误
ORA-00202: control file: +DATA
ORA-00311: cannot read header from archived log
ORA-00334: archived log: +DATA/
ORA-15081 failed to submit an I/O operation to a disk
ORA-27072: File I/O error
Linux-x86_64 Error: 5: Input/output error
ora.asm ora.asm.type OFFLINE OFFLINE TTTTDB1
Oracle RAC ASM1 CRS-0184: Cannot communicate with the CRS daemon
Oracle RAC ASM2 CRS-0184: Cannot communicate with the CRS daemon
ora.CRS.dg ora....up.type OFFLINE OFFLINE TTTTDB1
CRS-0184: Cannot communicate with the CRS daemon
CRS-0223: Resource 'ora.asm' has placement error
CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds
CRS-2660: Resource 'ora.TTTTDB1.gsd' or all of its instances are disabled
CRS-4000: Command Startfailed, or completed with errors
CRS-4124: Oracle High Availability Services startup failed
CRS-4530 Communications failure contacting Cluster Synchronization Services daemon
CRS-4530 Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
CRS-4535: Cannot communicate with ClusterReady Services
CRS-4535: Cannot communicate with ClusterReady Services
ora.ttttdb.db OFFLINE OFFLINE Instance Shutdown
DATA MOUNTED CONNECTED
ora.DATA.dg ora....up.type OFFLINE OFFLINE TTTTDB1
DATA UMOUNTED
Oracle Grid CRS-0184: Cannot communicate with the CRS daemon
ora....B1.lsnr application OFFLINE OFFLINE TTTTDB1
ORA-01102: cannot mount database in EXCLUSIVE mode
ora.scan1.vip ora....ip.type OFFLINE OFFLINE TTTTDB1
ORA-00204: error in reading (block 3, # blocks 8) of controlfile
ORA-00205: error in identifying control file, check alert log for more inf.
oracle非法关机引起redolog丢失,导致数据库实例无法正常启动(ORA-00313 ORA-00312 ORA-00376)
ORA-00376:此时无法读取文件3
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00821: Specified value of sga_target 4072M is too small, needs to be at least 13896M,数据恢复技术服务
ORA-00845: MEMORY_TARGET not supported on this system
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01113:文件7需要介质恢复
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file,数据恢复技术服务
ora-01190:控制文件或数据文件3来自最后一个RESETLOG之前
ORA-01552 cannot use system rollback segment for non-system tablespace
ORA-01624: 日志3是紧急修复实例
ORA-01658 oracle导入数据出错:ORA-01658:无法为表空间TESt中的段创建INITIAL区
ORA-00823: Specified value of sga_target greater than sga_max_size
ORA-03113: end-of-file on communication channel,数据恢复技术服务
ora-04031 无法分配XXX字节的共享内存(XXX)”的解决办法
ORA-07391: sftopn: fopen error, unable to open text file
ORA-27072: File I/O error
ORA-32001: write to SPFILE requested bu no SPFILE specified at startup.
SQL 错误: ORA-65096: 公用用户名或角色名无效
ASM Disk Group mount failure,数据恢复技术服务
ASM Disk Group 中只能mount 一个节点DATA的磁盘
CRS-4535: Cannot communicate with Cluster Ready Services,数据恢复技术服务
CRS-0184: Cannot communicate with the CRS daemon,数据恢复技术服务
CRS-0215: Could not start resource 'ora.test.db 2 1',数据恢复技术服务
CRS-4124: Oracle HighAvailability Services startup failed,数据恢复技术服务
CRS-4535: Cannot communicate with Cluster Ready Services,数据恢复技术服务
[INS-06006] Passwordless SSH connectivity not set up between the following node(s),数据恢复技术服务
[INS-20802] Oracle Cluster Verification Utility failed,数据恢复技术服务
[INS-32016] The selected Oracle home contains directories or files,数据恢复技术服务
[INS-40724] No locally defined network interface matches the SCAN,数据恢复技术服务
CRS-0215: Could not start resource 'ora.test.db 2 1',数据恢复技术服务
invalid stored block lengs,数据恢复技术服务
libmpfr.so.1()(64bit) is needed by cpp-4.4.6-3.el6.x86_64
oracle实例名: error while loading shared libraries: libskgxp10.so: cannot open shared object file: No such file or directory.
Linux-x86_64 Error
Oracle Custer Verification Utility Failed (see details) Recommended,数据恢复技术服务
ohasd failed to start at/u01/app/11.2.0/grid/crs/install/rootcrs.pl line 443,数据恢复技术服务
SP2-0042: unknown command "DATAFILE" - rest of line ignored.
TNS-12541: TNS: 无监听程序
ORA-00334: archived log: '+DATA//dbm/onlinelog/group_1.log
ORA-01034: ORACLE not available,数据恢复技术服务
ORA-01078: failure in processing system parameters,数据恢复技术服务
ORA-01110 数据文件坏,数据恢复技术服务
ORA-01589: must use RESETLOG or NORESETLOGS option for database open,数据恢复技术服务
ORA-02019: connection description for remote database not found,数据恢复技术服务
ORA-003111:cannot read header from archived log
ORA-12504: TNS:listener was not given the SID in CONNECT_DATA,数据恢复技术服务
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor,数据恢复技术服务
TNS-12535: TNS: 操作超时,数据恢复技术服务
ORA-15018: diskgroup cannot be created,数据恢复技术服务
ORA-15081 failed to submit an IO operation to disk
oracle Database 11.2 Error Messages
oracle Database 19C Error Messages
oracle Database 21C Error Messages
Oracle Database 技术支持电话: 13301272832 (微信同号)
Moble: 13301272832 (微信同号)
Tel:  010-82666745
联系人:   霍经理
QQ:   619804118
E-mail:   bjslkc@163.com
公司:北京深蓝融鑫科技发展有限公司

DataStage Director-->login failed-->解决方法

DataStage Designer-->login failed-->解决方法

DataStage Administrator-->login failed-->解决方法

DataStage Director RunMainControl Abort状态-->解决方法

DataStage Director-->ORA-12541: TNS: no listenter -->解决方法

DataStage Director Moniter-->Job 状态长时间 Running-->解决方法

DataStage Director Detail-->ORA-12535:TNS: Operation timed out-->解决方法

DataStage Director Detail-->ORA-01830: date format picture ends before converting entire input string-->解决方法

DataStage Director Detail-->ORA-12170: TNS: Connect timeout occurred-->解决方法

DataStage Director Detail-->ORA-01017: invailed username/password;logon denied-->解决方法

DataStage Director Detail-->JOB失败-->abnormal termination of stage detected-->解决方法

DataStage Director Detail-->ORA-12154: TNS:could not resolve service name-->解决方法

DataStage Designer-->job-->ORA-01400:cannot insert NULL into -->解决方法

DataStage Director-->job-->ORA-00060:deadlock detected while waiting for resource -->解决方法

DataStage Director-->job-->ORA-02291:integrity constraint () violated - parent key not found -->解决方法

DataStage Director-->job-->ORA-01843: not a valid month -->解决方法

DataStage Director-->job-->ORA-01427: single-row subquery returns more than one row -->解决方法

DataStage Director-->job-->inserted value too large for column,row rejected-->解决方法

DataStage RunMainControl Abort状态-->解决方法

DataStage 定时调度失败-->Contab failed-->解决方法

datastage 无法启动服务 -->解决方法 datastage sequence 调度出现的错误问题 -->解决方法 datastage sequence 调度不起JOB 问题 -->解决方法 datastage sequence 调度失败 问题 -->解决方法 datastage sequence Job 自动失败 问题 -->解决方法 Job control process has failed. -->解决方法 datastage 字符集问题 -->解决方法 datastage VersionControl问题 -->解决方法 datastage 连接 Oracle 数据库问题 -->解决方法

datastage源端能连接数据库,但是job一运行就报错ORA-12154;TNS:could not resolve the connect identifier specified;

datastage源端能连接数据库,但是job一运行就报错ORA-12154;TNS:could not resolve the connect identifier specified datastage在单独打开源端和目标端都能连接上数据库并能查看数据,就是单独执行datastage的job的时候就报错: Oracle_Connector_0: The connector could not establish connection to Oracle server misorcl. Method: OCIServerAttach, Error code: 12,154,-->解决方法 Error message ORA-12154: -->解决方法 TNS:could not resolve the connect identifier specified. (CC_OraConnection::verifyConnection, file CC_OraConnection.cpp, line 4,390);

datastage连接中断(81002)-->解决方法

TWS中的“Error 81002 waiting for job”-->解决方法 "Error 81002 waiting for job" in TWS, can the allowed runtime be extended?TWS中的“Error 81002 waiting for job”. TWS 中运行的 Informatica 和 Datastage 当作业运行时间超过 4 小时 TWS 作业使用失败并出现以下错误.

"Error calling subroutine: *DataStage*DSR.ADMIN (Action=10); check DataStage is set up correctly in project UV (Internal Error (39207))" Now when I click on OK button I get another error saying "Error calling subroutine: *DataStage*DSR_SELECT(Action=2); check DataStage is set up correctly in project uv (The connection is broken(81002))" Now when I click on OK button I get another error saying "Error calling subroutine: *DataStage*DSR.ADMIN(Action=2); check DataStge is set up correctly in project uv (The connection is broken(81002))" Now when I click on OK button I get another error saying "Access on this host has been temporarily restricted to Administrators only, until there is at least 1 project" All these errors happen in succession. I am not able to understand why is this happening. I am logging in is a Administrator, I have 2 projects test and Tutorial1. I am using Redhat 6.2 server. and oracle server database.

ORA-12500: TNS:listener failed -->解决方法 ORA-12500: TNS:listener failed to start a dedicated server process Cause: The process of starting up a dedicated server process failed. The executable could not be found or the environment may be set up incorrectly. Action: Turn on tracing at the ADMIN level and reexecute the operation. Verify that the ORACLE Server executable is present and has execute permissions enabled. Ensure that the ORACLE environment is specified correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being called may not be installed on the local hard drive. Please check that the correct Protocol Adapter are successfully linked.

中国·北京 重庆 联系方式:
北京 联系方式:
1)联系人:   霍 工
2)手 机: 13301272832 (微信同号)
3)QQ: 619804118
4)联系电话:(010)82666745
5)传   真:(010)82666745
6)E-mail:   bjslkc@163.com
7)公司:北京深蓝融鑫科技发展有限公司
8)公司地址、乘车路线及公司位置地图
 

Beijing ShenLan Rongxin Technology Development Co., Ltd. All Rights Reserved.
北京深蓝融鑫科技发展有限公司 版权所有,不得转载.
主体备案编号:京ICP备05042544号