The Capture queue has 0 messages and does not grow though the "status" issued from sp_ctrl shows that it is running. The event log shows the following:
sp_ctrl (wpst4002:2109)> show log reverse
03/27/08 16:34 Warning: 12035 - OCISessionBegin failed with ORA-1034. [sp_ordr(osp)/18637]
03/27/08 16:33 Warning: 12035 - OCISessionBegin failed with ORA-1034. [sp_ordr(osp)/18637]
03/27/08 16:33 Warning: 12035 - OCISessionBegin failed with ORA-1034. [sp_ocap(osp)/18962]
The "show capture detail" output is:
Host: wpst4002
Operations
Source Status Captured Since
---------- --------------- ---------- ------------------
o.w141prbr Running 0 20-Mar-08 19:54:13
Oracle current redo log : 61548
Capture current redo log : 61017
Capture log offset : 8398352
Last redo record processed:
None
Capture state : Initializing
Activation id : 0
Error count : 0
Operations captured : 0
Transactions captured : 0
Concurrent sessions : 0
HWM concurrent sessions : 3
Checkpoints performed : 39600
Total operations processed : 25113871
Total transactions completed : 13743804
Redo records in progress : 0
Redo records processed : 55497358
Redo records ignored : 30382179
Redo records - last HRID : N/A
And the latest *ocap* log in $SP_SYS_VARDIR/log directory shows that the following entry is appended to the log at all times:
08-03-20 19:54:13.574013 18962 1 ocap_conn = 0
08-03-20 19:55:13.651499 18962 1 ocap_conn = 0
08-03-20 19:56:13.740749 18962 1 ocap_conn = 0<
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center