Re: Replication Help

From: Arulmozhi Sengodan <Arulmozhi.Sengodan_at_us.bosch.com>
Date: Wed, 2 Feb 2000 09:19:45 -0500
Message-ID: <879een$it0$1@proxy2.fe.internet.bosch.de>

I am using HP-UX 10.20. Looks like I am missing some setup script in Advanced Replication.

The error I seem to getting is:

/*-- Connection to: SYSTEM_at_B.WORLD --*/

/*---
Creating user 'REPADMIN' at site 'System390' ---*/

create user REPADMIN identified by REPADMIN;

/*---
Granting admin privileges to user 'REPADMIN' at site 'System390' ---*/

begin
 dbms_repcat_admin.grant_admin_any_schema(  username => 'REPADMIN');
end;
/
/******** Error:

ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYSTEM.DBMS_REPCAT_ADMIN" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2

********/

/*---
Registering user 'REPADMIN' as propagator at site 'System390' ---*/

begin

   dbms_defer_sys.register_propagator(username => 'REPADMIN'); end;
/
/******** Error:

ORA-06550: line 2, column 4:
PLS-00905: object SYSTEM.DBMS_DEFER_SYS is invalid
ORA-06550: line 2, column 4:

PL/SQL: Statement ignored
********/

/*---
Granting privileges to user 'REPADMIN'
---*/

grant execute any procedure to REPADMIN;

---

Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote in message news:3897435B.DC949F97_at_abbnm.com...
> What OS is this on ??
Received on Wed Feb 02 2000 - 08:19:45 CST