1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-28584:heterogeneous apply internal error.

Discussion in 'General' started by SWankhede, Oct 10, 2013.

  1. SWankhede

    SWankhede Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Can anybody help me to solve my problem, it’s very urgent
    I want to insert data into table using heterogeneous connection , source db is ORACLE 11 g and target db is Microsoft SQL Server 2008 R2 . when I am select or insert record into remote database table through sql plus it’s work fine. But when I am try to insert data through STREAM Method. It’s give Following error.
    ORA-28584:heterogeneous apply internal error.
    ORA-02063: Preceding line from SQLSERVER (i.e SQLSERVER is my database link name).
     

    Attached Files:

  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Have you installed the Oracle Gateway 11g to allow heterogeneous services? I believe you will need to have that installed before any inserts/updates/deletes not executed through SQL*Plus will succeed without error.
     
  3. SWankhede

    SWankhede Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    I want to insert,update,delete record through SQL DEVELOPER and Yes , I have Insatlled oracle gateway , but in that gateway there is no tnsnames.ora only listener.ora is present and it is as follows.
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = D:\product\11.2.0\tg_1)
    (PROGRAM = extproc)
    (ENVS = "EXTPROC_DLLS=ONLY:D:\app\AdminValuD-17\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =
    (SID_NAME = SQL_Server)
    (ORACLE_HOME = D:\product\11.2.0\tg_1)
    (PROGRAM = dg4odbc)
    (ENVS = "EXTPROC_DLLS=ONLY:D:\app\AdminValuD-17\product\11.2.0\dbhome_1\bin\dg4odbc.exe")
    )
    )
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    # (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )

    ADR_BASE_LISTENER = D:\product\11.2.0\tg_1