1 Reply Latest reply: Oct 19, 2013 6:42 AM by Hoek RSS

    Problem in Oracle CDC Create Subscription option

    809520

      Hi All,

       

      I am facing a problem setting up CDC in test environment after cloning from DEV. We are using Oracle 11g and OWB 11g2 versions.

       

      For setting up CDC through OWB client, when we started start CDC, job throws runtime error saying error mapping function at DBMS Subscribe. I also tried to create CDC setup through scrips. My initial CDC setup is done, but when I start to create subscription, it throughs the same error as I encountered in OWB Start CDC. Not sure if it is some error with DB configuration or Package itself.

       

      Here is the relevant details.

       

      SELECT * FROM CHANGE_SETS;

       

      PR10TEST HOTLOG_SOURCE 19-OCT-13      Y  19-OCT-13 

       

      So, Change Set does exist along with Change Source as HOTLOG_SOURCE which is active. Now I want to create subscription as shown below. Command is run from Publisher schema


      BEGIN
      DBMS_CDC_SUBSCRIBE.CREATE_SUBSCRIPTION(
            change_set_name => 'PR10TEST',
            description => 'Common subscription ',
            subscription_name => 'PR10TESTNew'
      );
      END;

      --------

      Error starting at line 74 in command:
      BEGIN
      DBMS_CDC_SUBSCRIBE.CREATE_SUBSCRIPTION(
            change_set_name => 'PR10TEST',
            description => 'Common subscription ',
            subscription_name => 'PR10TESTNew'
      );
      END;
      Error report:
      ORA-06521: PL/SQL: Error mapping function
      ORA-06512: at "SYS.DBMS_CDC_ISUBSCRIBE", line 104
      ORA-06512: at "SYS.DBMS_CDC_SUBSCRIBE", line 120
      ORA-06512: at line 2
      06521. 00000 -  "PL/SQL: Error mapping function"
      *Cause:    An error was detected by PL/SQL trying to map the mentioned
                 function dynamically.
      *Action:   Check the stacked error (if any) for more details.

       

      I am stuck up here. I even tried to recompile CDC package but no luck.

       

      Please provide your inputs. Thanks in advance.