Home » Server Options » Streams & AQ » Data Replication same Database (Oracle 10g rel 2,Windows Server 2003)
Data Replication same Database [message #342137] Thu, 21 August 2008 08:14 Go to next message
mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA
Member

Dear All,

Last Few months ago I configured Oracle 10g streams in 3 different databases.I walked many forums and I successsfully built Oracle Streams.

Now I also want to configure streams in same database but different schemas. Some data replicate remote database and some data replicate same database but different schemas.

My databases are HRM,Billing & Monitoring.

My source database is HRM. Data will replicate from HRM to Billing and Monitoring and vise-virsa. Also data will replicate HRM database to another schema of HRM database(HRM-Guard).


Regard
Dhaka,Asraf.
Re: Data Replication same Database [message #342143 is a reply to message #342137] Thu, 21 August 2008 09:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The only difference is that you have to add a rule to give the target schema.

Regards
Michel
Re: Data Replication same Database [message #342157 is a reply to message #342143] Thu, 21 August 2008 10:08 Go to previous message
mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA
Member

Thanks

I used parameter global_names=true.
Database Name :HRM.world
Instance name :HRM

My source database HRM database has two schema (HRM,HRMGuard).
I create two streams administrator (strmadmin for HRM,and strmadmin2 for HRMGuard)

In My HRM database I create two TNS (HRM,and HRMGuard)
---
Setup Streams
conn strmadmin/strmadmin@hrm
create database link HRMGuard conn ..... using 'HRMguard';
---
conn strmadmin2/strmadmin2@hrmguard
create database link HRM ... conn ..... using 'HRM';

Then I configure Capture,Propagation and apply process for both streams Administrator in HRM database.

But When I start any DML operation in HRM's schema propagation stopp and disable.

In Atert Log file:
Propagation Schedule for (STRMADMIN2.CAPTURE_HRMGuard, HRM.DEPT) encountered following error:
ORA-02019: connection description for remote database not found
Thu Aug 21 17:18:03 2008
Propagation Schedule for (STRMADMIN.CAPTURE_HRM, HRMGuard) encountered following error:
ORA-02019: connection description for remote database not found
-------------------------
I could not understand why propagation stop and Remote connection is not work.


Previous Topic: Accessing SINGLE QUEUE simultaneously from two scripts
Next Topic: Streams - Mismatched columns
Goto Forum:
  


Current Time: Fri Mar 29 08:56:17 CDT 2024