duplicate database link

[akhadar]

Hello friends
while configuring the Replication(updatable snapshot) on cluster machines(oracle 8i with win2000) getting message as there is a duplicate database link exists.Unless this prolem is not solved it is not possiable to have all the tables replicated at snapshot site. Iam able to configure the same replication on test machine successfully.Is there any special requirement while preparing the replication on cluster machine.AT present the database is standalone still i didnot add it into the cluster group .Any remarks on this topic will be very helpful for me.
regards
akhadar

[julian]

It could be that an invalid object is causing the duplicate database link name. If you have no invalid objects then, the database link name specified when you used CREATE DATABASE LINK statement already exists. Specify a new name or drop the existing link.

You are hitting a small problem anayway. I would suggest drop the link with "drop database link link_name;". Then, create it again using the complete description instead of the alias:

create database link linkname (connect to user identified by password) (using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.x.xx)(PORT=1521))(CONNECT_DATA=(SID=sid_name)));

I am using DB links from OPS enviroment to a replication website and have hit your problem. It is easy to fix.

[akhadar]

Thank u julian for helping me throughout the configuration of Oracle Fail safe.Now OFS is working fine.only thing is replication. I will try with the option what u have given manually,since i was trying to configure it through wizard.I will try and back again.
regards
akhadar

[julian]

I've done almost the same you are doing but manually. I do not like very much wizards (except for Oracle Reports where I make the basic layout with the Wizard and then contune manually). If you need sample commands on how to replicate tables (say every 10th minute) just let me know.

[akhadar]

No problem with the replication of tables,now iam also replicating the tables from master to snapshot through built in procedures.What i want to ask u is why this fellow identifying duplicate database link even though initially there is no such link exists on the database.Can u expand this please.
regards
akhadar