hi all,
at first ,i start my extract process einit140 and pump process pump140 , the status is running ,but when i try to insert data into oracle , einit140 can get the data into ./dirdat ,but pump140 abended with no error . I can't find reason why it abended . I collapsed. plz help me . i'm appreciated.
status
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
GGSCI (cdh02 as ogg@poc) 93> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EINIT140 00:00:00 00:00:03
EXTRACT ABENDED PUSH140 00:00:00 00:01:07
PUSH140.rpt
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2016-11-24 17:57:48 INFO OGG-02095 Successfully set environment variable NLS_LANG=american_america.AL32UTF8.
extract push140
passthru
SETENV (NLS_LANG = "american_america.AL32UTF8")
rmthost 192.168.8.140 ,mgrport 1357
rmttrail ./dirdat/po
table poc.AST_SEC_SHARES_BAL_HA_REALTIME;
2016-11-24 17:57:48 INFO OGG-01971 The previous message, 'INFO OGG-02095', repeated 1 times.
2016-11-24 17:57:48 INFO OGG-01851 filecaching started: thread ID: 139769185351424.
2016-11-24 17:57:48 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/opt/ogg/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
2016-11-24 17:57:53 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).
2016-11-24 17:57:53 INFO OGG-01052 No recovery is required for target file ./dirdat/po000000000, at RBA 0 (file not
opened).
2016-11-24 17:57:53 INFO OGG-01478 Output file ./dirdat/po is using format RELEASE 12.2.
***********************************************************************
** Run Time Messages **
***********************************************************************
2016-11-24 17:57:53 INFO OGG-02243 Opened trail file ./dirdat/po000000000 at 2016-11-24 17:57:53.890772.
[root@cdh02 dirrpt]#
[root@cdh02 dirrpt]#
./dirdat
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[oracle@cdh02 dirdat]$ ll
total 8
-rw-r-----. 1 oracle dba 21252 Nov 24 17:31 po000000000
einit140.rpt
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"
2016-11-24 17:13:10 INFO OGG-02089 Source redo compatibility version is: 11.2.0.0.0.
2016-11-24 17:13:10 INFO OGG-01513 Positioning to Sequence 176, RBA 15941136, SCN 0.1239795 (1239795).
2016-11-24 17:13:10 INFO OGG-01516 Positioned to Sequence 176, RBA 15941136, SCN 0.1239795 (1239795), 2016-11-24 下
午5:12:21.
2016-11-24 17:13:10 WARNING OGG-06590 The output trail file ./dirdat/po000000000 is not found, rescan for previous one
s.
2016-11-24 17:13:10 INFO OGG-01478 Output file ./dirdat/po is using format RELEASE 9.0/9.5.
***********************************************************************
** Run Time Messages **
***********************************************************************
2016-11-24 17:13:10 INFO OGG-01517 Position of first record processed Sequence 176, RBA 15941136, SCN 0.1239795 (12
39795), 2016-11-24 下午5:12:21.
2016-11-24 17:17:42 INFO OGG-06507 MAP (TABLE) resolved (entry poc.AST_SEC_SHARES_BAL_HA_REALTIME): table "POC"."AS
T_SEC_SHARES_BAL_HA_REALTIME".
2016-11-24 17:17:42 WARNING OGG-06439 No unique key is defined for table AST_SEC_SHARES_BAL_HA_REALTIME. All viable co
lumns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2016-11-24 17:17:42 INFO OGG-06509 Using the following key columns for source table POC.AST_SEC_SHARES_BAL_HA_REALT
IME: BIZ_DATE, SYS_CODE, ORG_NO, CUST_NO, ASSET_ACCT, STKHLD_ACCT, TRD_MKT_CODE, STK_CODE, SEC_CATE, NEW_SEC_CATE, SEC_A
BBR, CRRC_CODE, CUST_NAME, SEAT_NO, SHARES_BAL, SHARES_USABLE_BAL, IN_TRANSIT_SHARES_BUY_QTY, IN_TRANSIT_SHARES_SELL_QTY
, SHARES_FRZ_NUM_VOL, SHARES_NFRZ_QTY, SHT_SELL_CUST_SURPLUS_STK_QTY, BUY_COST, FLOAT_PL, SEC_MKT_VAL, LAST_PRICE, SHARE
S_NATURE, DATE_TIME.