3 Replies Latest reply on Dec 26, 2011 9:27 AM by 883367

    ORA-06502:PL/SQL:numeric or value error in DBMS_STREAMS_ADM.MAINTAIN_SCHEMA

    883367
      Hi,

      I am tring to configure upstream replication. I have done reqired configurations of creating stream admin, db link at both source and target. Gettiing following error when i execute folli\owing script.
      Script:
      ========================================================
      BEGIN
      DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS(
      schema_names => 'TEST1',
      source_database => 'BASE51.REGRESS.RDBMS.DEV.US.ORACLE.COM',
      source_directory_object => 'STREAMS_DIR',
      destination_database => 'ORCL.LOCALDOMAIN',
      destination_directory_object => 'STREAMS_DIR',
      include_ddl => TRUE
      );
      END;
      /

      Error:
      ==============================================
      BEGIN
      *
      ERROR at line 1:
      ORA-06502: PL/SQL: numeric or value error
      ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2963
      ORA-06512: at "SYS.DBMS_STREAMS_MT", line 6338
      ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7524
      ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2624
      ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2685
      ORA-06512: at line 2

      I am unable to find the root cause for above error.

      Following are entires created for additional information:

      > select script_id,status from DBA_RECOVERABLE_SCRIPT ;
      Script ID Status
      ----------------------------------- ------------
      B4BED3FE81B255EEE040007F01003A84 GENERATING
      select * from dba_recoverable_script_errors;
      no rows selected
      select * from DBA_RECOVERABLE_SCRIPT_BLOCKS;
      no rows selected

      Let me know if you need any more info which could help