Home » Server Options » Streams & AQ » Streams Replication Working or Not?
Streams Replication Working or Not? [message #255868] Thu, 02 August 2007 03:36 Go to next message
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.
Re: Streams Replication Working or Not? [message #255871 is a reply to message #255868] Thu, 02 August 2007 04:00 Go to previous messageGo to next message
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?
Re: Streams Replication Working or Not? [message #255918 is a reply to message #255868] Thu, 02 August 2007 06:35 Go to previous message
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.
Previous Topic: Will Suppliment logging finish
Next Topic: Which data is replicated.
Goto Forum:
  


Current Time: Thu Mar 28 16:15:43 CDT 2024