GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center