1.PWC端问题 LD_LIBRARY_PATH未设置
node01_etlserver    MAPPING    PWXPC_10005    [ERROR] PowerExchange AllocEnv failed
node01_etlserver    MAPPING    PWXPC_12019    [ERROR] Error occurred loading library [libdtlscli.so: cannot open shared object file: No such file or directory]Database driver event...Error occurred loading library [libdtlscli.so]

解决方法：设置LD_LIBRARY_PATH到安装路径即可

2.PWC端问题PWX_HOME未设置
node01_etlserver    MAPPING    PWXPC_10035    [ERROR] Error message: [
[Informatica][SCLI PWX Driver] PWX-00001 Error opening repository "dtlmsg.txt". RCs = 268/150/2.
[Informatica][SCLI PWX Driver] PWX-00001 Error opening repository "dtlmsg.txt". RCs = 268/150/2.
]

解决方法：设置PWX_HOME到安装路径即可

3.PWX端注册配置文件被删除了
node01_etlserver    READER_1_1_1    PWXPC_10035    [ERROR] Error message: [
[Informatica][SCLI PWX Driver] PWX-00264 DBAPI Error. DB_DESCRIBE failed for file d8orcl.PWX_MBDWV2A.
[Informatica][SCLI PWX Driver] PWX-01252 DBNTC Initial "Describe" CONVERSE failed to location "ORCL", rcs 260/2006/2138.
[Informatica][SCLI PWX Driver] PWX-02006 SQL prepare error. SQLCODE = 2138.
[Informatica][SCLI PWX Driver] PWX-02138 Error loading data map "d8orcl.PWX".
[Informatica][SCLI PWX Driver] PWX-00268 DBAPI Error. DB_OPEN failed for file /PWX/pwx_XTRT/d8orcl.pwx.dmx.
[Informatica][SCLI PWX Driver] PWX-00150 DBAPI SEQ Filename "/PWX/pwx_XTRT/d8orcl.pwx.dmx" Open error reason 2 .]
解决方法：有备份的恢复，没有只有重新在Navigator做了

4.mappinp增加cdc的表
解决方法：
dbmover.cfg cold start
增加
RESTART1=CURRENT_RESTART
RESTART2=CURRENT_RESTART5


5.oracle 归档日志错误操作
rman中执行 DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
 --删除日志后错误
node01_etlserver : PWXPC_10034 : [ERROR] CDCDispatcher cannot fetch changed data from the PowerExchange Listener. Error code: [271]

rman中执行
change archivelog all validate;  可能可以解决

6.Navigator中表的压缩没有设置
  重新设置，并且冷启动pwccl