Home » RDBMS Server » Server Administration » ORA-04052: error occurred when looking up remote object REPADMIN.SYS@DB
ORA-04052: error occurred when looking up remote object REPADMIN.SYS@DB [message #209065] Wed, 13 December 2006 03:27
gsgill76
Messages: 12
Registered: November 2006
Junior Member
Hi, Basically I want to setup Replication between two servers, 'ZEN2K7' & 'DB' (Advanced master-to-master replication, Sync).
This is what i had done so far.
At Server 'ZEN2K7'
CONNECT system/manager@ZEN2K7
CREATE USER repadmin IDENTIFIED BY repadmin;
ALTER USER repadmin DEFAULT TABLESPACE POOL_DATA;
ALTER USER repadmin TEMPORARY TABLESPACE TEMP;
GRANT connect, resource TO repadmin;
EXECUTE dbms_repcat_admin.grant_admin_any_schema('repadmin');
GRANT comment any table TO repadmin;
GRANT lock any table TO repadmin;
EXECUTE dbms_defer_sys.register_propagator('repadmin');
GRANT execute any procedure TO repadmin;
CREATE PUBLIC DATABASE LINK DB USING 'test2';

CONNECT repadmin/repadmin@ZEN2K7
CREATE DATABASE LINK DB CONNECT TO repadmin IDENTIFIED BY repadmin;


At Server 'DB'
CONNECT system/manager@DB
CREATE USER repadmin IDENTIFIED BY repadmin;
ALTER USER repadmin DEFAULT TABLESPACE POOL_DATA;
ALTER USER repadmin TEMPORARY TABLESPACE TEMP;
GRANT connect, resource TO repadmin;
EXECUTE dbms_repcat_admin.grant_admin_any_schema('repadmin');
GRANT comment any table TO repadmin;
GRANT lock any table TO repadmin;
EXECUTE dbms_defer_sys.register_propagator('repadmin');
GRANT execute any procedure TO repadmin;
CREATE PUBLIC DATABASE LINK ZEN2K7 USING 'test1';

CONNECT repadmin/repadmin@DB
CREATE DATABASE LINK ZEN2K7 CONNECT TO repadmin IDENTIFIED BY repadmin;


After this, Create master replication group on ZEN2K7
CONNECT repadmin/repadmin@ZEN2K7 
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP(
gname => '"REPTEST"',
qualifier => '',
group_comment => '');
END;


Then at 'ZEN2K7', when i executing
BEGIN
     DBMS_REPCAT.ADD_MASTER_DATABASE(
     gname => '"REPTEST"',
     master => 'DB',
     use_existing_objects => TRUE ,
     copy_rows => TRUE ,
     propagation_mode =>'SYNCHRONOUS');
END;

I got following error

ORA-04052: error occurred when looking up remote object REPADMIN.SYS@DB
ORA-00604: error occurred at recursive SQL level 2
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 4262
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2156
ORA-06512: at "SYS.DBMS_REPCAT", line 146
ORA-06512: at line 2

I had already execute the 'catrpc.sql' at 'DB' side
I had already check the connection at 'ZEN2K7' side, means I can connect to 'DB' within SQL* Plus at 'ZEN2K7' side.

What else need to do???

Thanks.
Gurpreet S. Gill

Previous Topic: DBMS_SCHEDULER Problem
Next Topic: tablespace defrag
Goto Forum:
  


Current Time: Fri Sep 20 05:53:34 CDT 2024