This content has been marked as final. Show 4 replies
1 person found this helpful
Is possible to that with same sids or database names?Generally yes but what type of replication are you planning to setup...stream...Goldengate..Mv..?
Thanks kuljeet.I previously did schema replication and it was not worked with same database names. But i don't have clear idea on other replication types. what I want is to replicate data between two servers with same name.
You cannot have two databases with the same name if the GLOBAL_NAMES parameter is TRUE.1 person found this helpful
yes, you can have two databases with the same name as long as they have different global_name. you can change the global_name to be different from your database name. it's not recommended but doable and you'll need to have a service name match the global_name and create dblink having that name and the service_name.