2 Replies Latest reply: Nov 17, 2011 12:56 PM by User275737 RSS

    ORA-23324: error ORA-12541: TNS:no listener, while creating deferror entry

    User275737
      I need Help for the following error message while pushing the dererred transactions from the snapshot to Master in advanced replication.

      The Snapshot site has some deftran which supposed to propagate daily push.

      SQL>
      SQL> -- push existing transactions
      SQL> declare
      rc binary_integer;
      begin
      rc := dbms_defer_sys.push('XXXX.WORLD');
      dbms_output.put_line(to_char(rc));
      end;
      /
      declare
      *
      ERROR at line 1:
      ORA-23324: error ORA-12541: TNS:no listener, while creating deferror entry at
      "XXXX.WORLD" with error -12541
      ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1716
      ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1804
      ORA-06512: at line 4

      Thank you in advance.