This discussion is archived
5 Replies Latest reply: Jan 24, 2013 6:25 AM by Osama_Mustafa RSS

Streams apply process aborting with ORA-1013

Tarek.Z Newbie
Currently Being Moderated
Hello

A sream apply process is gutting aborted whenever is started by error ORQ-01013

environment 11.2.0.2 RAC

SQL> exec dbms_apply_adm.stop_apply('BPRA_BANNER$APP');

PL/SQL procedure successfully completed.

SQL> exec dbms_apply_adm.start_apply('BPRA_BANNER$APP');

PL/SQL procedure successfully completed.

SQL> select apply_name,status from dba_apply;

APPLY_NAME STATUS
-------------------- --------
BPRA_BANNER$APP ABORTED

Any ideas or help in troubleshooting this issue ?

Thanks
  • 1. Re: Streams apply process aborting with ORA-1013
    Fran Guru
    Currently Being Moderated
    welcome to OTN forums.

    ORA-1013 could be:

    - The operation has been explicitly shut down by the user.
    - Timeout
    - By other Error

    Use "select ERROR_MESSAGE from dba_apply;" to get more information. Furthermore post a few lines of alert.log to check more information.
  • 2. Re: Streams apply process aborting with ORA-1013
    ShishirTekadeR Explorer
    Currently Being Moderated
    select * from dba_apply;and also provide alert log error...


    *****************************************
    Best Regards,
    Shishir Tekade.
    My Blog: http://shishirtekade.blogspot.com
  • 3. Re: Streams apply process aborting with ORA-1013
    Tarek.Z Newbie
    Currently Being Moderated
    Hello

    SQL> select ERROR_MESSAGE from dba_apply;

    ERROR_MESSAGE
    --------------------------------------------------------------------------------
    ORA-01013: user requested cancel of current operation

    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Thu Jan 24 09:57:43 2013
    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Thu Jan 24 09:58:36 2013
    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Thu Jan 24 10:00:00 2013
    OS Pid: 7596 executed alter system set events '1013 trace name errorstack level 12'
    Thu Jan 24 10:00:55 2013
    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Thu Jan 24 10:01:26 2013
    OS Pid: 7596 executed alter system set events '1013 trace name errorstack off'
    Thu Jan 24 10:29:39 2013
    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Thu Jan 24 10:46:20 2013
    OS Pid: 6744 executed alter system set events '1013 trace name errorstack level 12'
    Streams process BPRA_BANNER$APP altered (1) on instance 1
  • 4. Re: Streams apply process aborting with ORA-1013
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    user12120232 wrote:
    Hello

    SQL> select ERROR_MESSAGE from dba_apply;

    ERROR_MESSAGE
    --------------------------------------------------------------------------------
    ORA-01013: user requested cancel of current operation

    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Thu Jan 24 09:57:43 2013
    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Thu Jan 24 09:58:36 2013
    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Thu Jan 24 10:00:00 2013
    OS Pid: 7596 executed alter system set events '1013 trace name errorstack level 12'
    Thu Jan 24 10:00:55 2013
    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Thu Jan 24 10:01:26 2013
    OS Pid: 7596 executed alter system set events '1013 trace name errorstack off'
    Thu Jan 24 10:29:39 2013
    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Thu Jan 24 10:46:20 2013
    OS Pid: 6744 executed alter system set events '1013 trace name errorstack level 12'
    Streams process BPRA_BANNER$APP altered (1) on instance 1
    Stop Stream processes and reissue the command.
  • 5. Re: Streams apply process aborting with ORA-1013
    karan Pro
    Currently Being Moderated
    Try the following

    exec dbms_apply_adm.set_parameter('BPRA_BANNER$APP','disable_on_error','N');

    exec dbms_Apply_adm.stop_apply('BPRA_BANNER$APP');

    exec dbms_Apply_adm.start_apply('BPRA_BANNER$APP');

    Regards
    Karan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points