ASR setup has failed – Error occurred while dropping database link : ORA-02084 : database name is missing a component while Configuring Multi Master OID replication using “remtool -asrsetup”
This issue is from one of our readers where He was facing issue while configuring OID multimaster replication usign remtool.
remtool : REplication Mangement TOOL is command like tool to manage OID replication configuration (adding, deleting node, setting up ASR based replication -asrsetup and configuraing LDAP based replica groups). More on remtool here
.
Error Message
________________
ASR setup has failed.
Error occurred while dropping database link.
XXXX.xxx.CO.IN : ORA-02084: database name is missing a component
________________
This error could occur if your database global name contains a word that belongs to the list of Oracle Database Reserved Words (Example AT, BY, IN, IS) for list of all reserved words check view V$RESERVED_WORDS
.
Fix is to remove any reserved words from you database global name (for all databases which are part of OID Multimaster Replication)
.
References
- 879160.1 ORA-02084:Database Name Is Missing A Component (Oracle Support Note)
- 1018063.102 ORA-02084: WHILE RENAMING OF GLOBAL_NAME IRRESPECTIVE OF NEW NAME (Oracle Support Note)
- Mihajlo Tekic’s Oracle Tech Blog
About the Author Atul Kumar
Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.