Data Integration

Get Involved. Join the Conversation.

Posts

  • 1-2 of 2
  • Gleb Otochkin
    DIPC for Big Data cannot see the running manager2
    Topic posted May 16, 2019 by Gleb OtochkinGreen Ribbon: 100+ Points, tagged Big Data / Data Lake, Data Replication, DIPC 
    Title:
    DIPC for Big Data cannot see the running manager
    Summary:
    Trying to run replication to Kafka connect and getting an error
    Content:

    When I try to run replication task from Oracle db to Kafka topic I am getting error in DIPC

    "GoldenGate manager is not running for agent, ogghost1.c.myhostname.internal:7005. Start the GoldenGate manager for the agent"

    The agent shows the manger is on and when I go to the host where agent runs I see the manager is online:

    GGSCI (ogghost1) 2> info all

    Program     Status      Group       Lag at Chkpt  Time Since Chkpt

    MANAGER     RUNNING                                           
    JAGENT      STOPPED                                           
    PMSRVR      RUNNING                                           


    GGSCI (ogghost1) 3> 

     

    Have anybody had the same issue? 

    Thanks,

    Gleb

    Version:
    18.4.3
  • Nagesh Nadimatla Ext
    Redshift Data server connectivity issue with standalone...85.0
    Topic posted February 23, 2018 by Nagesh Nadimatla ExtGreen Ribbon: 100+ Points, tagged Big Data / Data Lake, Cloud, ODI, Tip 
    Title:
    Redshift Data server connectivity issue with standalone agent in ODI 12.2.1 on windows server
    Summary:
    Redshift Data server connectivity issue with standalone agent in ODI 12.2.1 on windows server
    Content:

    I have configured Redshift Data server in ODI for this i have copied the suitable JDBC drivers for Redshift in odi installed folder.

    After this when I am trying to test Red shift connection from local agent it is connecting successfully. But trying to test it from standalone agent it is giving below mentioned error.

     

    I have done below changes in Redhsift Dataserver and added the Jdbc drivers in below mentioned paths. Before testing the connection i have restarted Admin server and ODI Agents :

    JDBC Driver:com.amazon.redshift.jdbc42.Driver

    JDBC URL: jdbc:redshift://endpoint:port/database

    pastedImage_2.png

    Path

    C:\Oracle\product\middleware\odi\odi\sdk\lib\RedshiftJDBC42-1.2.10.1009.jar

    C:\Oracle\config\odidev-domain\lib\RedshiftJDBC42-1.2.10.1009.jar

    C:\%APPDATA%\Roaming\odi\oracledi\userlib\RedshiftJDBC42-1.2.10.1009.jar

     

    Error:

    oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.amazon.redshift.jdbc42.Driver]

    at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:439)

    at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)

    at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1118)

    at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:664)

    at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$9.doInBackground(SnpsDialogTestConnet.java:622)

    at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

    at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)

    at java.lang.Thread.run(Thread.java:748)

     

    Please guide me to resolve this issue. Thank you in Advance.