5 Replies Latest reply: Jan 24, 2013 8:25 AM by Osama_Mustafa RSS

    Streams apply process aborting with ORA-1013

    Tarek.Z
      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
          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
            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
              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
                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
                  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