Data Integration

Get Involved. Join the Conversation.

Comments

  • Subrahmanyam Vempati
    Yes Fernando, it is an external network.
  • Fernando Ponte

    Hi Subrahmanyan.

    Unless somebody comes with a workaround, this is not possible.

    I assume the sFTP is external to your network right?

    Cheers

    Fernando

  • Subrahmanyam Vempati

    Hi Julien,

    Thanks for your response, DIPC is actually decommissioned. Its not available now. As an alternative Oracle came up with ODI in Marketplace , which has all the related configurations pre-installed. (RCU,Weblogic(JCS),DB). It will create a VCN where you can start the development.

    Thanks,

    Vempati

  • Subrahmanyam Vempati

    Hi JermeFr,

    Thanks for your quick response, Could you please help us with the below points.

    #1.We have tried creating the ODI instance with Embedded MySQL through marketplace, Could you share some information on how we can create work repositories for higher environments.

    #2: We have also configured ODI instance with Oracle ATP ( Create a new ODI repository in Autonomous Database.) option. Does it create a ODI repository automatically in ATP or we need to run RCU separatley to create ODI repository schemas.?

    Thanks,

    Vempati

  • Jerome Francoisse

    The RCU can be found under /home/opc/oracle/oracle_common/bin/.

    The latest release of ODI Marketplace (v201b) now uses ODI 12.2.1.4 which supports ADW as a repository. During provisioning of ODI Marketplace it is now possible to choose to create a new repository on an existing ADWC instance or to reuse an existing repository on ADWC in addition to the MySQL alternative.

    If you create a new master repository you might want to have a new agent connection to it. The config.sh utility can be found under /home/opc/oracle/oracle_common/common/bin/

    Best regards,

    JeromeFr

     

     

  • Julien Testut

    Hi Vempati,

    You can log into OCI Console and then you will find DIPC under More Oracle Cloud Services > Platform Services. This will redirect you to the DIPC landing page where you can create new instances.
    Please open up a service request on My Oracle Support in case you don't see these links.

    Thanks,
    Julien

  • 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