Hello All,
I have a test environment . It has a single virtual box machine with single database. Here for me source and target databases are same.
Source Schema and table name is splex.
Target Schemal and table name is splex_target.
Database is oracle.
performed some transactions but post process was stopped. Please assist us .
Brief Status for localhost.localdomain
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 13020 13-Feb-19 03:25:14
Capture Running 32690 13-Feb-19 06:07:07
Read Running 32712 13-Feb-19 06:07:14
Export Running 32727 13-Feb-19 06:07:18
Import Running 32730 13-Feb-19 06:07:18
Post Stopped - due to error
Cmd & Ctrl Running 3745 13-Feb-19 06:56:17
sp_ctrl (localhost.localdomain:2100)> list config
File Name State Datasource
-------------------------------------------------- ---------- ---------------
ORA_config Inactive o.SOURCE_SID
Last Modified At: 12-Feb-19 10:34 Size: 151
demo_config Active o.orclcdb
Last Modified At: 13-Feb-19 06:19 Size: 219 Internal Name: .conf.4
sp_ctrl (localhost.localdomain:2100)> view config demo_config
datasource:o.orclcdb
#source tables target tables routing map
##splex.demo_src splex.demo_dest target_system@o.target_sid
splex.itest splex_target.itest 192.168.99.100@o.orclcdb
error message from event log.
)
Info 2019-02-13 06:08:31.129610 13020 1285547968 Poster exited with code=1, pid = 32731 (posting from o.orclcdb, queue localhost, to o.orclcdb)
Notice 2019-02-13 06:19:35.143388 13731 1215862720 User command: oracle edit/create config demo_config (from localhost)
Notice 2019-02-13 06:19:55.121896 13731 1215862720 User command: oracle start post (from localhost)
Info 2019-02-13 06:19:55.124019 1236 1285547968 Poster launched, pid = 1236 (posting from o.orclcdb, queue localhost, to o.orclcdb)
Notice 2019-02-13 06:20:02.232718 1236 2789451520 s:5 Poster: Oracle error: ORA-00942: table or view does not exist rowid:AAASGDAAQAAAACtAAA (posting from o.orclcdb
, queue localhost, to o.orclcdb) [module opo]
Error 2019-02-13 06:20:03.260320 1236 2789451520 Poster stopped: Internal error encountered; cannot continue (posting from o.orclcdb, queue localhost, to o.orclcdb)
Info 2019-02-13 06:20:04.285437 13020 1285547968 Poster exited with code=1, pid = 1236 (posting from o.orclcdb, queue localhost, to o.orclcdb)
Notice 2019-02-13 06:21:08.621977 32712 1366443968 Reader: Table "SPLEX"."ITEST" (obj_id:13595755) was truncated (from o.orclcdb) [module ord]
Info 2019-02-13 06:56:00.314115 3644 1388566464 Available instance - ORACLE_SID: orclcdb, ORACLE_HOME: /u01/app/oracle/product/version/db_1, Oracle version: 180 [o
ra_setup]
Notice 2019-02-13 06:56:00.549822 13020 1285547968 SharePlex for Oracle RAC/OPS, "Trial Key" will expire on Midnight of Mar 14, 2019
Notice 2019-02-13 06:56:00.706940 32712 1366443968 Reader: Replicating according to target compatibility of "9.2.0" (from o.orclcdb) [module sys]
Notice 2019-02-13 06:57:02.441178 3745 2311833536 User command: oracle activate config demo_config (from localhost)
Info 2019-02-13 06:57:02.446960 3793 1285547968 Activation launched, pid = 3793 (activating datasource o.orclcdb)
Notice 2019-02-13 06:57:02.615997 3793 903763904 Activation: Replicating according to target compatibility of "9.2.0" (activating datasource o.orclcdb) [module sys]
Notice 2019-02-13 06:57:02.616434 3793 903763904 Activation: Replicating according to target compatibility of "9.2.0" (activating datasource o.orclcdb) [module sys]
Notice 2019-02-13 06:57:04.636088 3793 903763904 Activation: Oracle compatible parameter='18.0.0' (activating datasource o.orclcdb) [module ocf]
Warning 2019-02-13 06:57:04.986224 3793 903763904 Activation: 13007 - No unique keys or primary key for object id 74115 (activating datasource o.orclcdb) [module osp]
Info 2019-02-13 06:57:08.149446 3793 903763904 Deactivation of "demo_config", actid 3, for database o.orclcdb started
Info 2019-02-13 06:57:08.150059 3793 903763904 Activation of "demo_config", actid 4, for database o.orclcdb complete
Info 2019-02-13 06:57:08.191264 13020 1285547968 Activation exited normally, pid = 3793 (activating datasource o.orclcdb)
Notice 2019-02-13 06:57:36.842920 3745 2311833536 User command: oracle start post (from localhost)
Info 2019-02-13 06:57:36.851505 3840 1285547968 Poster launched, pid = 3840 (posting from o.orclcdb, queue localhost, to o.orclcdb)
Notice 2019-02-13 06:57:42.719523 3840 3516651264 s:5 Poster: Oracle error: ORA-00942: table or view does not exist rowid:AAASGDAAQAAAACtAAA (posting from o.orclcdb
, queue localhost, to o.orclcdb) [module opo]
Error 2019-02-13 06:57:43.610892 3840 3516651264 Poster stopped: Internal error encountered; cannot continue (posting from o.orclcdb, queue localhost, to o.orclcdb)
Info 2019-02-13 06:57:44.623460 13020 1285547968 Poster exited with code=1, pid = 3840 (posting from o.orclcdb, queue localhost, to o.orclcdb)
Please assist me here.
Thank you.