Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Replication Help
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:
/*---
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 ??
>
>> > obvious thing that I can understand is that the relevant packages (like
> > I am using Oracle 8.0.4 and Replication Manager 1.6.0.0.0 and the one