Home » Server Options » Replication » help needed in Oracle 8.1.7 replication
help needed in Oracle 8.1.7 replication [message #75088] Thu, 02 August 2001 09:24 Go to next message
suchintya
Messages: 2
Registered: August 2001
Junior Member
hi,
I have a problem in replicating between two Oracle 8.1.7 instances.While creating new master replication object group an error occurs as shown.

SQL> exec dbms_REPCAT.CREATE_MASTER_REPGROUP (gname=>'RFG_TEMP');
begin dbms_REPCAT.CREATE_MASTER_REPGROUP (gname=>'RFG_TEMP'); end;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_ASYNCRPC_PUSH" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_DEFER_REPCAT", line 59
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 784
ORA-06512: at "SYS.DBMS_REPCAT", line 485
ORA-06512: at line 1

This sql works perfectly fine in Oracle 7.3.4.Can you please help me out..I have run the dbmsdefr.sql in rdbmsadmin but still the package dbms_asyncrpc_push is not compiling.Am i missing something????

Thanks in Advance,
Suchintya

----------------------------------------------------------------------
Re: help needed in Oracle 8.1.7 replication [message #75113 is a reply to message #75088] Thu, 18 October 2001 20:16 Go to previous message
sandeep bhan
Messages: 1
Registered: October 2001
Junior Member
Be sure al the dbms packages are valid .
check table usEr_objects

CONNECT to sys
sql>select OBJECT_NAME,OBJECT_TYPE,STATUS from user_objects
where OBJECT_TYPE='PACKAGE';

if the status of packages mentioned in error is invalid ,then u have to recompile it

----------------------------------------------------------------------
Previous Topic: Snapshots
Next Topic: Re: Data Conversion
Goto Forum:
  


Current Time: Fri Mar 29 04:07:38 CDT 2024