1 Reply Latest reply: Jun 27, 2013 10:47 PM by haans RSS

    Setup Streams failed

    haans

      Hi,

       

      I encountered the following error while trying to setup streams replication at the database level using dbms_streams_adm.maintain_global.

       

      Can help please?

       

      Thanks. Desmond

       

      begin

      *

      ERROR at line 1:

      ORA-23616: Failure in executing block 6 for script

      E00C49DDDB27C899E040A8C04C0119DA with

      ORA-06550: line 21, column 3:

      PL/SQL: ORA-00942: table or view does not exist

      ORA-06550: line 21, column 3:

      PL/SQL: SQL Statement ignored

      ORA-06550: line 23, column 3:

      PL/SQL: ORA-00942: table or view

      ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 659

      ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 682

      ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2427

      ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 3004

      ORA-06512: at line 2

       

       

       

       

      SQL> select forward_block

        from dba_recoverable_script_blocks

      where script_id = 'E00C49DDDB27C899E040A8C04C0119DA'

         and block_num = 6;  2    3    4 

       

       

      FORWARD_BLOCK

      --------------------------------------------------------------------------------

      --

      -- Datapump FULL MODE IMPORT

      --

      DECLARE

        h1                NUMBER := NULL;

       

       

       

       

      SQL>

      SQL> select * from dba_recoverable_script_errors;

       

       

      SCRIPT_ID                         BLOCK_NUM ERROR_NUMBER

      -------------------------------- ---------- ------------

      ERROR_MESSAGE

      --------------------------------------------------------------------------------

      ERROR_CRE

      ---------

      E00C49DDDB27C899E040A8C04C0119DA          6        -6550

      ORA-06550: line 21, column 3:

      PL/SQL: ORA-00942: table or view does not exist

      ORA-06550: line 21, column 3:

      PL/SQL: SQL Statement ignored

      ORA-06550: line 23, column 3:

      PL/SQL: ORA-00942: table or view

       

       

      SCRIPT_ID                         BLOCK_NUM ERROR_NUMBER

      -------------------------------- ---------- ------------

      ERROR_MESSAGE

      --------------------------------------------------------------------------------

      ERROR_CRE

      ---------

      26-JUN-13

       

       

      E00C49DDDB27C899E040A8C04C0119DA          6        -6550

      ORA-06550: line 21, column 3:

      PL/SQL: ORA-00942: table or view does not exist

      ORA-06550: line 21, column 3:

      PL/SQL: SQL Statement ignored

       

       

      SCRIPT_ID                         BLOCK_NUM ERROR_NUMBER

      -------------------------------- ---------- ------------

      ERROR_MESSAGE

      --------------------------------------------------------------------------------

      ERROR_CRE

      ---------

      ORA-06550: line 23, column 3:

      PL/SQL: ORA-00942: table or view

      26-JUN-13

       

       

      E00C49DDDB27C899E040A8C04C0119DA          6        -6550

      ORA-06550: line 21, column 3:

      PL/SQL: ORA-00942: table or view does not exist

       

       

      SCRIPT_ID                         BLOCK_NUM ERROR_NUMBER

      -------------------------------- ---------- ------------

      ERROR_MESSAGE

      --------------------------------------------------------------------------------

      ERROR_CRE

      ---------

      ORA-06550: line 21, column 3:

      PL/SQL: SQL Statement ignored

      ORA-06550: line 23, column 3:

      PL/SQL: ORA-00942: table or view

      26-JUN-13

        • 1. Re: Setup Streams failed
          haans

          The error indicated that it stopped in "datapump FULL MODE IMPORT".

           

          Further check in the destination DB, found that the "database directory objects" is missing. This folder in the OS is required for the data pump export utility to work.

           

          Solution:

           

          Do this in downstream DB

          1. create directory streams_dp_dir as '/u01/streams_dp_dir';

           

          FORWARD_BLOCK

          --------------------------------------------------------------------------------

          --

          -- Datapump FULL MODE IMPORT

          --

          DECLARE

            h1                NUMBER := NULL;