All, I am trying to set up a job for pushing deferred transactions to a remote database. When I run the job, I am getting:
Wed Jun 12 09:26:48 2002 Errors in file /u800/app/oracle/admin/trl1/udump/ora_28709.trc: ORA-12012: error on auto execute of job 22 ORA-23354: deferred RPC execution disabled for "TRL2.WORLD" ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1520 ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1583 ORA-06512: at line 1 Which leads me to: ORA-23354: 23354, 00000, "deferred RPC execution disabled for \"%s\" with \"%s\"" // *Cause: Deferred RPC can not be executed at the destination with // the specified catchup value because their propogation has // been disabled. // *Action: Enable deferred RPC execution with the // dbms_defer_sys.set_disabled call. So, I go to the destination and execute: SQL> execute dbms_defer_sys.set_disabled(destination=>'trl1.world',disabled=>false); PL/SQL procedure successfully completed. Unfortunately this does not seem to clear the problem. Is anyone familier enough with the dbms_defer_sys package to tell me what I'm missing? TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
