PowerExchange 9.5.0 配置文件参考

1:启用Oracle数据库归档

ALTER SYSTEM SET log_archive_dest_1 = 'location=/u01/oracle/Desktop/archivelog' SCOPE=SPFILE;

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

SHUTDOWN IMMEDIATE;

STARTUP;

2: dbmover.cfg

/********************************************************************/

/*  PowerExchange Configuration File

/********************************************************************/

LISTENER=(node1,TCPIP,2480,262144,262144,262144,262144)

NODE=(local,TCPIP,127.0.0.1,2480)

NODE=(node1,TCPIP,127.0.0.1,2480,262144,262144,262144,262144)

NODE=(default,TCPIP,x,2480)

APPBUFSIZE=256000

COLON=:

CONSOLE_TRACE=N

DECPOINT=.

DEFAULTCHAR=*

DEFAULTDATE=19800101

MAXTASKS=30

MSGPREFIX=PWX

NEGSIGN=-

PIPE=|

POLLTIME=1000

PRE861_COMPAT=N

EXT_CP_SUPPT=Y

/*监听配置MAP存放的位置*/

CAPT_PATH=C:\Informatica\PowerExchange9.5.1\capture

CAPT_XTRA=C:\Informatica\PowerExchange9.5.1\capture\xtramaps

LOGPATH=C:\Informatica\PowerExchange9.5.1\capture\logs

/*标记名，oracle实例名*/

ORACLEID=(ETLNODE,orcl,orcl,orcl)   

CAPI_CONNECTION=(NAME=CAPIEDP,TYPE=(UOWC,CAPINAME=CAPIORAD,RSTRADV=60))

CAPI_CONNECTION=(NAME=CAPIORAD,TYPE=(ORCL,ARRAYSIZE=1000,SELRETRY=0,ORACOLL=ETLNODE))

CAPI_CONNECTION=(NAME=CAPXSYNC,DLLTRACE=CPX,TYPE=(CAPX,DFLTINST=ETLNODE,FILEWAIT=60,RSTRADV=600))

3:pwxccl.cfg

/* Name for PWXCMD control

/*CONDENSENAME=PWXCCL1

DBID=ETLNODE 

DB_TYPE=ORA

CAPTURE_NODE_UID=SCOTT

/*CAPTURE_NODE_EPWD=encrypted_password

CAPTURE_NODE_PWD=123456



PROMPT=Y

EXT_CAPT_MASK=C:\Informatica\PowerExchange9.5.1\capture\condenseO 

CHKPT_NUM=3 

CHKPT_BASENAME=C:\Informatica\PowerExchange9.5.1\capture\condenseO.chkpt 

COND_CDCT_RET_P=50 

LOGGER_DELETES_EXPIRED_CDCT_RECORDS=Y



/* 0 = continuous, 1 = Stop at end-of-log (batch)

COLL_END_LOG=0 

/* Number of minutes to wait between CAPI read cycles in seconds

NO_DATA_WAIT=0

/* Number of seconds to wait at the end-of-log for more change data

NO_DATA_WAIT2=10

/* Number of seconds before flushing, or writing, data to the current log file on disk

/* -1 = No flush, 0 = flush every record, 1 to N flush every N seconds

FILE_FLUSH_VAL=5

/* minimum number of FILE_SWITCH_CRIT units after new CDCT source entry (normal,coldstart)

/*FILE_SWITCH_MIN=(0,0)

FILE_SWITCH_CRIT=M 

FILE_SWITCH_VAL=3



CAPT_IMAGE=AI 

SEQUENCE_TOKEN=00

RESTART_TOKEN=00

4:启动服务

dtllst node1

pwxccl