OraFAQ Forum: Streams & AQ » Streams Replication Working or Not?

Home » Server Options » Streams & AQ » Streams Replication Working or Not?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Streams Replication Working or Not? [message #255868]

Thu, 02 August 2007 03:36

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I have two database db1 and db2. I want to data replication of prod7 schema from db1 to db2. Both prod schema contains almost same data(a little different) I have done this.
[hide]

1.CONFIGURING STREAM ADMINISTRATOR.(both database)
2.CREATE DATABASE LINK(both databse)
3.SPECIFY SUPPLIMENT LOGGING(source database)
4 ENABLE FORCE LOGGING(source database)
5.CREATING CAPTURE PROCESS(source database)

After creating this process whenever I query it will show.

SQL> select capture_name,queue_name,queue_owner,start_scn,status,capture_type from dba_capture;

 CAPTURE_NAME  QUEUE_NAME   QUEUE_OWNER    START_SCN STATUS   CAPTURE_TY
 ------------------------------ ------------------------------ ------------------------------ ---------- 
 STREAMS_CAPTURE STREAMS_CAPTURE_Q  STRMADMIN   3823913 DISABLED LOCAL

6.CREATING ANYDATA QUEUE(both database)
7.CREATING PROPAGATION(source database)
8 CREATING APPLY PROCESS(destinatin database)
9.PERFORMING INSTANTIATION

SQL>DECLARE
 iscn  NUMBER;         
BEGIN
 iscn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER@TERMINUS.NET;
 DBMS_APPLY_ADM.SET_SCHEMA_INSTANTIATION_SCN(
   source_schema_name    => 'PROD7',
   source_database_name  => 'TERMINUS.NET',
   instantiation_scn     => iscn,
   recursive             => true);
END;
/

Can anyone please tell me what to do now.
Anything, any comment any suggestion is expected.

Report message to a moderator

Re: Streams Replication Working or Not? [message #255871 is a reply to message #255868]

Thu, 02 August 2007 04:00

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I identified the error. Error is in propagation.

ORA-04052: error occurred when looking up remote object STRMADMIN.DBMS_AQADM@SATURN.NET
ORA-00604: error occurred at recursive SQL level 4
ORA-12170: TNS:Connect timeout occurred
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1087
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7616
ORA-06512: at "SYS.DBMS_AQADM", line 631
ORA-06512: at line 1

I cannot connect by using

connect use/pass@db_link

It also give me same messgae. TNS:CONNECT timeout.

But I can easily get by using

select user_name from dba_users@db_link

Where is the problem?

Report message to a moderator

Re: Streams Replication Working or Not? [message #255918 is a reply to message #255868]

Thu, 02 August 2007 06:35

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I fixed this problem.
The problem was I enabled global_names to true. But I have not rename the global_names which one I use as a link in source database.

Whenever I rename global_names to specified one it seems to work ok.
Thanks.

Report message to a moderator

Previous Topic:	Will Suppliment logging finish
Next Topic:	Which data is replicated.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 17:27:36 CST 2024