Stream issue
edited Feb 20, 2011 2:20AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hi ,
My database stream setup is on 10.2.0.4. in linux platform .Data is not moving from one database to another. It is showing waiting state
I have given the below Output.
Please help me..
SQL> conn STRMADMIN/STRMORAADMIN
Connected.
SQL> COLUMN apply_name FORMAT A20 HEADING 'Apply'
SQL> COLUMN process_name FORMAT A07 HEADING 'Process'
SQL> COLUMN sid FORMAT A08 HEADING 'Sid'
SQL> COLUMN state FORMAT A17 HEADING 'State'
SQL> COLUMN total_messages_dequeued FORMAT 99G999G999G999 HEADING 'Nb Msg dequeued'
SQL> COLUMN total_applied FORMAT 999G999G999G999 HEADING 'Total TX Applied'
SQL> SELECT r.apply_name, substr(s.program, instr(s.program,'(')+1,4) process_name,
Connected.
SQL> COLUMN apply_name FORMAT A20 HEADING 'Apply'
SQL> COLUMN process_name FORMAT A07 HEADING 'Process'
SQL> COLUMN sid FORMAT A08 HEADING 'Sid'
SQL> COLUMN state FORMAT A17 HEADING 'State'
SQL> COLUMN total_messages_dequeued FORMAT 99G999G999G999 HEADING 'Nb Msg dequeued'
SQL> COLUMN total_applied FORMAT 999G999G999G999 HEADING 'Total TX Applied'
SQL> SELECT r.apply_name, substr(s.program, instr(s.program,'(')+1,4) process_name,
0