OraFAQ Forum: Streams & AQ » Data Replication same Database

Home » Server Options » Streams & AQ » Data Replication same Database (Oracle 10g rel 2,Windows Server 2003)

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

Data Replication same Database [message #342137]

Thu, 21 August 2008 08:14

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.

Report message to a moderator

Re: Data Replication same Database [message #342143 is a reply to message #342137]

Thu, 21 August 2008 09:09

Michel Cadot
Messages: 68548
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

Report message to a moderator

Re: Data Replication same Database [message #342157 is a reply to message #342143]

Thu, 21 August 2008 10:08

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 29 21:51:42 CST 2023