Data Integration

Get Involved. Join the Conversation.

Comments

  • Frank Cruz

    Hello
    In what versions are your services?
    I have a similar problem communicating ODI agents in the cloud with an external base.

  • Julien Testut

    Hello,

    Are you using Data Integration Platform Cloud in this environment? Are you referring to a communication issue between two Agents?

    Thanks,
    Julien

  • Mark Hamilton

    I dont think the Windows agent is supported. Only Linux at the moment.

  • Julien Testut

    Hi Frank,

    Please open up a Support request on My Oracle Support to track this and have our Support troubleshoot it.

    Thanks,
    Julien

  • Mark Hamilton

    Hi Shrinidhi,

    Ok. I assume I just need to do the SSL part from the link you sent. 

    I ran the command to create a SSL Trust-Store unlock password. I created a password and then ran the start agent command again.

    I get another error:  ERROR java.io.IOException: Keystore was tampered with, or password was incorrect

     

    From the below i checked the properties file and #1 is already set but #2 is not in the file. I did #3 as described above. Sorry but could you be more specific? Thanks

    Set the following in the agent.properties file:

    1. agentUseSSL = true
    2. agentTrustStorePath= <path to SSL trust store>
    3. Execute and set the unlock password for the trust store configured above.
    4. To create a SSL Trust-Store unlock password:

      .${AGENT_INSTANCE_HOME}/bin/createTrustStoreUnlockPassword.sh

       

      Regards,

      Mark

     

  • Shrinidhi Kulkarni
  • Mark Hamilton

    Hi Julien,

    I have just now tried it on Linux and the configure agent file does create the agent instance fully. It seems like the windows zip file download has a folder called ODI missing from within it as per my previous message. Thanks for the support. I will suggest we raise a support ticket for that.

    I am having trouble starting it now on Linux and i will post a new discussion here for that.

    Thanks,

    Mark

  • Julien Testut

    Hi Mark,

    It would be best to open up a support request on My Oracle Support about this. I cannot reproduce the "too many argument" error but I only have access to a Linux environment so it could be a difference between the Linux and Windows Agents... On Linux the command seems to work even so it obviously fails given that I cannot access your system.

    Thanks,
    Julien

  • Mark Hamilton

    1. This is my configure agent script without the password shown. When I run it like this i get a message saying that i have too many arguments.

    C:\MH_Oracle_Installs\DIPCAgent\dicloud\dicloudConfigureAgent.bat 
    dipcagent001
    -recreate 
    -debug 
    -dipchost=psm-eduoracle.console.oraclecloud.com
    -dipcport=443
    -user=MarkH
    -password=*********
    -authType=OAUTH2 
    -idcsServerUrl=https://idcs-b04de8c998444222bf67ed5c04f9393f.identity.oraclecloud.com
    -agentIdcsScope=https://34964AFB5BA84C77AD41792A35132E12.adipc.ocp.oraclecloud.com:443urn:opc:resource:consumer::all 
    -agentClientId=24ea22a0d35d427f912a62c6068dffbf
    -agentClientSecret=0524cf21-012e-48e7-954c-bae4d2f6592e

    2. When I run it without the arguments then I am prompted for 4 arguments (host, port, idcsserverurl and scope). This does not work either and I get a long error message in the command shell. Please see the attached file. The first error looks to be this one and then it tries to delete the instance folder after that.

    [global] (oracle.dicloud.agent.deployment.AgentDeployer getOdiHome) odiPluginHome : C:\MH_Oracle_Installs\DIPCAgent\dicloud\agent\oracle\plugins\odi doesn't exist

    Please can you help?

    Thanks

    Mark

  • Julien Testut

    Hi Mark,

    Please refer to this doc link for the parameters to pass to dicloudConfigureAgent: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/you-perform-tasks.html#GUID-4C5A810C-0A3A-4E5C-B55B-2B492C725FEC. The command will look like this: ./dicloudConfigureAgent.sh <agentInstanceDirectory> -recreate -debug -dipchost=<dipc.example.host.com> -dipcport=<port> -user=<diuser> -password=<dipassword> -authType=<BASIC/OAUTH2> -idcsServerUrl=<idcs server url> -agentIdcsScope=<agent IDCS Client Scope> -agentClientId=<Agent IDCS clientID> -agentClientSecret=<Agent IDCS clientSecret>

    Thanks,
    Julien

  • Julien Testut

    Hi Dvi,

    DIPC and ODI are different offerings, at this time we do recommend using ODI on OCI Marketplace for ETL use cases: https://cloudmarketplace.oracle.com/marketplace/en_US/listing/59419903.

    Please reach out to your Oracle account team if you need any assistance with ODI.

    Thanks,
    Julien

  • Jayant Mahto

    If multiple agents (in different compute instances) are required configuration then it can be done manually. However, I am assuming that multiple compute instances are being configured for HA kind of need and in that case the repository should also be in HA setup. In that case an external repository DB can be setup manually (and embedded MySQL repository should be ignored).

  • Julien Testut

    Hi Raghvendra,

    This is not supported in DIPC, you would need full ODI access using either ODICS, ODI on-prem or the recently released ODI on OCI Marketplace. I'd recommend getting in touch with your Oracle team to assess what option is the best for your use case.

    Thanks,
    Julien

  • Begoña Villamor

    Hi Dragos,

    Did you managed to set up ODI Studio with DIPC? Did you need a database (out of DIPC) to create ODI repository? 

    Thanks!

  • Begoña Villamor

    Hi Siddharth,

    the referenced document seems to apply only to user-managed DIPC (classic) because one of the steps includes connecting with SSH to the DIPC virtual machine where the ODI server is installed and downloading some files. 

    The product change name in January 2019 is a nightmare because some documentation has not been updated becoming confusing.

    2018 name - 2019 name

    DIPC Autonomous -> DIPC

    DIPC -> DIPC Classic

     

    Begoña Villamor.