GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Bi directional streams replication

edited Feb 28, 2010 5:01PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered
 Dear All, I have read  about Bi directional Streams Replication.....

I have two Oracle 10.2  Servers lrc1, lrc2

when i am trying to configure Streams , i have  faced the problem that  both have same global database name
'ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM' and global_names parameter is true...

so when i am creating database link on lrc1 to lrc2  with service naming  "rempri"... database link (streamss) created but when i am trying to test it was giving an error Ora:02085....
and says that STREAMSS.REGRESS.RDBMS.DEV.US.ORACLE.COM  is trying to connect ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center