Forum Stats

  • 3,854,291 Users
  • 2,264,347 Discussions
  • 7,905,634 Comments

Discussions

Setup Streams failed

haans
haans Member Posts: 27
edited Jun 27, 2013 11:47PM in Streams

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

Tagged:

Answers

  • haans
    haans Member Posts: 27

    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;

This discussion has been closed.