| help needed in Oracle 8.1.7 replication [message #75088] |
Thu, 02 August 2001 09:24  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
