Stream capture process start failure
Hi all,
I am new to oracle streams and trying to set up streams on the same schema from one DB to other DB.Both DB is
the capture process always aborts with the following error messsages as soon as i start the capture process.I was following the best practis for 10GR2 demo in the link http://streams.us.oracle.com
Dbms_Capture_Adm.Start_Capture(Capture_Name => 'SOURCE$CAP');
procedure also for setting up the log miner data dictionary but it also does not help.
Errors in file /home/oracle/oracle/product/10.2.0/db/admin/source/bdump/source_c001_26546.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 58:
PLS-00302: component 'GET_CHECKPOINT_SCNS' must be declared
ORA-06550: line 1, column 37:
PL/SQL: Statement ignored
the source_c001_26546.trc contain the following content:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining options
ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db
System name: Linux
Node name: Source
Release: 2.4.21-32.EL
Version: #1 Fri Apr 15 21:29:19 EDT 2005
Machine: i686
Instance name: source
Redo thread mounted by this instance: 1
Oracle process number: 25
Unix process pid: 25787, image: oracle@Source (C001)
*** SERVICE NAME:(SYS$USERS) 2007-04-29 14:28:15.565
*** SESSION ID:(291.4360) 2007-04-29 14:28:15.565
*** 2007-04-29 14:28:15.565
Begin knlcDumpCapCtx:*******************************************
Error 604 : ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 58:
PLS-00302: component 'GET_CHECKPOINT_SCNS' must be declared
ORA-06550: line 1, column 37:
PL/SQL: Statement ignored
Capture Name: SOURCE$CAP : Instantiation#: 18
*** 2007-04-29 14:28:15.565
++++ Begin KNST dump for Sid: 291 Serial#: 4360
Init Time: 04/29/2007 14:28:15
++++Begin KNSTCAP dump for : SOURCE$CAP
Capture#: 1 Logminer_Id: 22 State: DICTIONARY INITIALIZATION [ 04/29/2007 14:28:15]
Capture_Message_Number: 0x0000.00000000 [0]
Capture_Message_Create_Time: 01/01/1988 00:00:00
Enqueue_Message_Number: 0x0000.00000000 [0]
Enqueue_Message_Create_Time: 01/01/1988 00:00:00
Total_Messages_Captured: 0
Total_Messages_Created: 0 [ 01/01/1988 00:00:00]
Total_Messages_Enqueued: 0 [ 01/01/1988 00:00:00]
Total_Full_Evaluations: 0
Elapsed_Capture_Time: 0 Elapsed_Rule_Time: 0
Elapsed_Enqueue_Time: 0 Elapsed_Lcr_Time: 0
Elapsed_Redo_Wait_Time: 0 Elapsed_Pause_Time: 0
++++End KNSTCAP dump
++++ End KNST DUMP
+++ Begin DBA_CAPTURE dump for: SOURCE$CAP
Capture_Type: LOCAL
Version:
Source_Database: SOURCE.CN.ORACLE.COM
Use_Database_Link: NO
Logminer_Id: 22 Logfile_Assignment: IMPLICIT
Status: ENABLED
First_Scn: 0x0000.000be528 [779560]
Start_Scn: 0x0000.000be528 [779560]
Captured_Scn: 0x0000.000be528 [779560]
Applied_Scn: 0x0000.000be528 [779560]
Last_Enqueued_Scn: 0x0000.00000000 [0]
Capture_User: STRMADMIN
Queue: STRMADMIN.SOURCE$CAPQ
Rule_Set_Name[+]: "STRMADMIN"."RULESET$_89"
Checkpoint_Retention_Time: 60
+++ End DBA_CAPTURE dump
+++ Begin DBA_CAPTURE_PARAMETERS dump for: SOURCE$CAP
PARALLELISM = 1 Set_by_User: NO
STARTUP_SECONDS = 0 Set_by_User: NO
TRACE_LEVEL = 0 Set_by_User: NO
TIME_LIMIT = -1 Set_by_User: NO
MESSAGE_LIMIT = -1 Set_by_User: NO
MAXIMUM_SCN = 0xffff.ffffffff [281474976710655] Set_by_User: NO
WRITE_ALERT_LOG = TRUE Set_by_User: NO
DISABLE_ON_LIMIT = FALSE Set_by_User: NO
DOWNSTREAM_REAL_TIME_MINE = TRUE Set_by_User: NO
+++ End DBA_CAPTURE_PARAMETERS dump
+++ Begin DBA_CAPTURE_EXTRA_ATTRIBUTES dump for: SOURCE$CAP
+++ End DBA_CAPTURE_EXTRA_ATTRIBUTES dump
++ LogMiner Session Dump Begin::
SessionId: 22 SessionName: SOURCE$CAP
Start SCN: 0x0000.00000000 [0]
End SCN: 0x0000.00000000 [0]
Processed SCN: 0x0000.00000000 [0]
Prepared SCN: 0x0000.00000000 [0]
Read SCN: 0x0000.00000000 [0]
Spill SCN: 0x0000.00000000 [0]
Resume SCN: 0x0000.00000000 [0]
Branch SCN: 0x0000.00000000 [0]
Branch Time: 01/01/1988 00:00:00
ResetLog SCN: 0x0000.0006f8fa [456954]
ResetLog Time: 04/25/2007 17:45:37
DB ID: -1555758726 Global DB Name: SOURCE.CN.ORACLE.COM
krvxvtm: Enabled threads:
Current Session State: 0x0, Current LM Compat: 0x0
Flags: 0x3fa002d0, Real Time Apply is On
+++ Additional Capture Information:
Capture Flags: 5
Logminer Start SCN: 0x0000.000be528 [779560]
Enqueue Filter SCN: 0x0000.000be528 [779560]
Low SCN: 0x0000.00000000 [0]
Capture From Date: 01/01/1988 00:00:00
Capture To Date: 01/01/1988 00:00:00
Restart Capture Flag: NO
Ping Pending: NO
Buffered Txn Count: 0
-- Xid Hash entry --
-- LOB Hash entry --
-- No TRIM LCR --
Unsupported Reason: 14
--- LCR Dump not possible ---
End knlcDumpCapCtx:*********************************************
*** 2007-04-29 14:28:15.568
error 604 in STREAMS process
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 58:
PLS-00302: component 'GET_CHECKPOINT_SCNS' must be declared
ORA-06550: line 1, column 37:
PL/SQL: Statement ignored
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 58:
PLS-00302: component 'GET_CHECKPOINT_SCNS' must be declared
ORA-06550: line 1, column 37:
PL/SQL: Statement ignored
Any one can help me on this,since i am stuck here.
thanks in advance.