none
Sql Server Replication for ORACLE data sync

    Question

  • While creating the oracle publisher, getting the below error

    Failed to execute the HREPL.INITPUBLISHER request to Oracle Publisher 'ORCL'. Verify that the Oracle package code exists on the Publisher, and that the replication administrative user account has sufficient permissions.
    Changed database context to 'master'.
    OLE DB provider "MSDAORA" for linked server "ORCL" returned message "ORA-04063: package body "REPUSER.HREPL" has errors
    ORA-06508: PL/SQL: could not find program unit being called: "REPUSER.HREPL"
    ORA-06512: at line 1
    ".
    Error: 7215, Sev: 17, State: 1, Msg: Could not execute statement on remote server 'ORCL'. (Microsoft SQL Server, Error: 21651)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=21651&LinkId=20476

    ------------------------------
    BUTTONS:

    OK

    Friday, July 05, 2013 9:48 AM