who have an example of apply forwarding?

[oldboy]

see title.

who have an complete example of apply forwarding?


thanks.

[oldboy]

Primary Database Sharing Data with Several Secondary Databases by stream is the example,but i encounter the error. primary database does not replicate to other secondary database,and does not error display.

who do it?

[davey23uk]

you seem to have an aversion to supplying any details or doing any research of your own

[oldboy]

hi.
you are right.
my english is not very good.

[oldboy]

now ,the result is primary database can replicate to other secondary database,but secondary database is replicated only to primary database,not forwarded to other secondary database.

[oldboy]

see Attachment:

[oldboy]

set attachment

[oldboy]

1.insert value in orc0,the result is the data is replicated at the orc1 and orc2

SQL> connect strmadm/strmadm@orc0;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as strmadm

SQL> Insert Into strmusr.product(Id,Name,description,price) Values(strmusr.product_id.Nextval,'ZLSOFT2','zlsoft software',800000);

1 row inserted

SQL> Select * From strmusr.product@Orc2.net;

ID NAME DESCRIPTION PRICE
--------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
1 ZLSOFT2 zlsoft software 800000.00

SQL> Select * From strmusr.product@Orc1.net;

ID NAME DESCRIPTION PRICE
--------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
1 ZLSOFT2 zlsoft software 800000.00
2.insert value in orc1,the result is the data is replicated at the orc0,but is not at the orc2

SQL> connect strmadm/strmadm@orc1;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as strmadm

SQL> Insert Into strmusr.product(Id,Name,description,price) Values(strmusr.product_id.Nextval,'ZLSOFT2','zlsoft software',800000);

1 row inserted

SQL> commit;

Commit complete

SQL> Select * From strmusr.product@Orc2.net;

ID NAME DESCRIPTION PRICE
--------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
1 ZLSOFT2 zlsoft software 800000.00

SQL> Select * From strmusr.product@Orc1.net;

ID NAME DESCRIPTION PRICE
--------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
1 ZLSOFT2 zlsoft software 800000.00
2 ZLSOFT2 zlsoft software 800000.00

SQL> Select * From strmusr.product@Orc0.net;

ID NAME DESCRIPTION PRICE
--------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
2 ZLSOFT2 zlsoft software 800000.00
1 ZLSOFT2 zlsoft software 800000.00
3.insert value in orc2,the result is the data is replicated at the orc0,but is not at the orc1

SQL> connect strmadm/strmadm@orc2;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as strmadm

SQL> Insert Into strmusr.product(Id,Name,description,price) Values(strmusr.product_id.Nextval,'ZLSOFT2','zlsoft software',800000);

1 row inserted

SQL> commit;

Commit complete

SQL> Select * From strmusr.product@Orc0.net;

ID NAME DESCRIPTION PRICE
--------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
3 ZLSOFT2 zlsoft software 800000.00
2 ZLSOFT2 zlsoft software 800000.00
1 ZLSOFT2 zlsoft software 800000.00

SQL> connect strmadm/strmadm@orc2;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as strmadm

SQL> Select * From strmusr.product@Orc1.net;

ID NAME DESCRIPTION PRICE
--------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
1 ZLSOFT2 zlsoft software 800000.00
2 ZLSOFT2 zlsoft software 800000.00


SQL> Select * From strmusr.product@Orc2.net;

ID NAME DESCRIPTION PRICE
--------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
1 ZLSOFT2 zlsoft software 800000.00
3 ZLSOFT2 zlsoft software 800000.00

SQL>

[oldboy]

davey23uk
can you help me at the problem?