Home » Server Options » Replication » ORA-04052 ERROR during Master Replication
ORA-04052 ERROR during Master Replication [message #75388] Fri, 01 August 2003 07:35
saustin
Messages: 43
Registered: June 2003
Member
Subject: ORA-04052 ERROR during Master Replication.

RDBMS Version: 8.1.7.4
Operating System and Version: LINUX
Error Number (if applicable): ORA-04052
Product (i.e. SQL*Loader, Import, etc.):
Product Version: 8i

ORA-04052 ERROR during Master Replication.

Hi,
We too are getting the ora-04052 error when setting up master replication. The work-around in the tech doc was.

8. Database Links =================
Before the database links are setup it is important that all replicated databases have unique global names. The default global name is the same name as the database name, which can only be changed by recreating the controlfile.
The global name can be changed by :
ALTER DATABASE RENAME GLOBAL_NAME TO <new global name>;
SELECT * FROM GLOBAL_NAME;

Unfortunately this does not change the Global name using sql plus or svrmgrl.

Any ideas ? Many thanks, Steve.
Previous Topic: Replication Very Urgent
Next Topic: Snapshots/Materialized Views - M$Log Tables
Goto Forum:
  


Current Time: Wed Sep 22 13:04:52 CDT 2021