Posts

Posts

  • Moon Ray Lo
    Downtime Handling in OIC35.0
    Topic posted August 3, 2018 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, Cloud, Connection, Database, Integration, Mapping, Orchestration, PaaS, REST, SOAP, xml in Integration > Integration public
    Title:
    Downtime Handling in OIC
    Summary:
    We encountered intermittent connection (2-3 minutes of random downtime) in OIC
    Content:

    Hi,

     

    We encountered intermittent connection (2-3 minutes of random downtime like service not accessible) with OIC, which happens a couple of times in a week. It may not sound a big deal, but this is concerning on a production system, that some integrations are unavailable on that instance (especially there are activities triggered).

    Aside from having error handling (integration level), can you suggest how to handle OIC downtime? I can see there's a 'Load Balancer' for every OIC service, any idea how to leverage on this context?

     

    Appreciate your inputs on this.

     

    Thanks,

    Moon

  • SM
    starting Oracle ICS agentAnswered25.0
    Topic last edited March 1, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Agent, Integration in Integration > Integration public
    Title:
    starting Oracle ICS agent
    Summary:
    starting Oracle ICS agent
    Content:

    Hello,

     

    How can we start the Oracle ICS agent in the background, passing along with the connection parameters?

     

    The document (E85413-03  January 2018), I am following doesn't have any information as such about starting the agent in the background. Please advice.

     

     

    $java -jar connectivityagent.jar

    Proceeding to install a new agent ...

    Enter your OIC username : abc@xyz.com

    Enter password for abc@xyz.com :

     

     

    Thanks!

  • Christopher Maggiulli
    Select statement with DB2 connector doesn't return...Answered85.0
    Topic posted July 3, 2018 by Christopher MaggiulliSilver Crown: 22,500+ Points, tagged Adapters, Agent, Database, Mapping, Orchestration in Integration > Integration public
    Title:
    Select statement with DB2 connector doesn't return anything to map
    Summary:
    Using the DB2 connector to connect to DB2 over port 446, select statement validates and generates and xsd but there is not outbound mapping.
    Content:
    I administer a test and production customer managed OIC environment 18.2.5. We have an on premise connectivity agent that we use for a majority of our integrations. We have an AS400 that uses DB2 as our main ERP. I can connect to it successfully over port 446 (that's the standard port for DB2 on the as400 not 5000, shouldn't matter though). When I created an integration invoking the DB2 adapter using a simple select statement the it validates the query and generates the XSD, but the outbound mapping does not show anything to map to. Has anyone experienced this issue? In our Java applications we connect directly to the database using a jt400 jdbc driver. We had an issue with connecting to MySQL until I found a special driver and added it to the agenthome/third-party/lib folder. I tried to add the jt400 driver to that folder and restart, no fix. This is turning into a huge issue. On the old forum someone told me the DB2 adapter does not allow select statements, but I haven't been able to find that stated in the documentation.i haven't placed a SR yet because we have several open and I'm the only technical person to manage them currently. If I could find my own solution I'd prefer so that I don't clutter Oracle with tickets then become unresponsive.
  • Thirunavukarasur
    OIC on-prim Agent performance improvement125.0
    Topic posted June 26, 2018 by Thirunavukarasur Bronze Medal: 1,250+ Points, tagged Agent in Integration > Integration public
    Title:
    OIC on-prim Agent performance improvement
    Summary:
    How to improve the performance of OIC on-prim agent
    Content:

    We have couple of integrations which times out intermittently and , any suggestion on  how to improve the performance of on-prim agent as well as OIC.  Thank you so much for the help.

    Thanks

    Ravi

  • Moon Ray Lo
    ICS: Agent not showing in DB Connection Agent Confguration...Answered45.0
    Topic posted June 25, 2018 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, Connection, Database in Integration > Integration public
    Title:
    ICS: Agent not showing in DB Connection Agent Confguration after installing the On-Premise Agent
    Summary:
    The agent is not showing in the 'Configure Agents' interface when doing DB Connection setup in ICS
    Content:

    Hi,

    We are using ICS Standard Edition, Version: 18.2.3.0.1 (180419.0000.1063).

    The connectivity agent group we created is visible in 'Agents' page, which has 1 newly linked Agent (ID: PLOACS.AGENT15700) as shown in one of the screenshot (ICS_AgentsList.JPG) after being installed on our server where the DB resides. I tried to create a DB Connection and when I scroll down and access the 'Configure Agent', it is NOT showing on the list as shown in one of the screenshots (ICS_DBConnection_NoAgentsFound.JPG). I have also attached the Agent Installation Log in case it might help. (LOG-cloud-connectivity-agent-installation.txt).

     

    Any idea what could have caused this issue to arise? or anything I missed to setup?

     

    Thanks,

    Moon

    Document:
  • Ritu
    OIC Connectivity AgentAnswered85.0
    Topic posted June 7, 2018 by RituBronze Medal: 1,250+ Points, tagged Agent, Connection, Integration in Integration > Integration public
    Title:
    OIC Connectivity Agent
    Summary:
    Coomunication and High Availability Details
    Content:

    Hi,

    Could anybody throw some light what exactly happens in the background when an OIC agent is installed ,how exactly it communicates with OIC instance and how does the agent ensures high availability.

     

    Thanks

  • Ritu
    OIC Integration Cloud:Connectivity Agent InstallationAnswered45.0
    Topic posted June 5, 2018 by RituBronze Medal: 1,250+ Points, tagged Agent, Integration in Integration > Integration public
    Title:
    OIC Integration Cloud:Connectivity Agent Installation
    Summary:
    OIC Connectivity Agent weblogic details
    Content:

    Hi,

    I had installed an OIC connectivity agent on another DBCS instance to do a quick connection testing with my IC home instance. The agent got successfully installed and reflected on the IC home.

    But after some time, the monitoring tab displayed the agent connection in red.When I tried to search the startAgent.sh file to restart the agent on DBCS instance, there was no such file.

    Can i not install OIC agent on DBCS?If yes, then how do i start and stop the agent if there is no domain created.

    Thanks

     

     

     

  • Russell Cormier
    When I try to create a connection in ICS, it is necessary to...1
    Topic posted May 17, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Agent in Integration > Integration public
    Title:
    When I try to create a connection in ICS, it is necessary to install agent for which Admin privileges are required. How do obtain admin access?
    Summary:
    When I try to create a connection in ICS, it is necessary to install agent for which Admin privileges are required. How do obtain admin access?
    Content:

    How is admin privilege achieved to install an agent in ICS?  thx

  • Christopher Maggiulli
    MySQL adapter cannot connect (needs JDBC jar?) Using...Answered25.0
    Topic posted March 19, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Agent, Connection, Database in Integration > Integration public
    Title:
    MySQL adapter cannot connect (needs JDBC jar?) Using On-Prem agent
    Summary:
    MySQL adapter cannot connect (needs JDBC jar?) Using On-Prem agent
    Content:

    I have an OIC instance with an On-Prem adapter installed within my firewall.  The On-Prem adapter works when I use the various REST and SOAP connections.  However when I set up a connection using the MySQL adapter it fails to connect, saying that I should check the com.jdbc.myswl.driver.  Following that advice I SHH'd into the box and found where location of the driver's for the weblogic server. I see the MySQL connector/j driver is already present (additionally, it already says pre installed on the GUI (underneath the adapter)). I verified that I can access the MySQL box from the box the on prem agent is installed on. The log files do not say anything interesting beyond "cannot connect" and to check if the jar driver is installed.  Does anyone have any thoughts?

  • Chetan D
    EBS Download Agent for trial cloud account not...25.0
    Topic posted March 19, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Agent, E-Business Suite in Integration > Integration public
    Title:
    EBS Download Agent for trial cloud account not enabled(Currently, downloading Connectivity Agent is not supported. Please contact oracle support to download agent. )
    Summary:
    EBS Download Agent for trial cloud account not enabled(Currently, downloading Connectivity Agent is not supported. Please contact oracle support to download agent. )
    Content:

    Hello Experts,

     

    We have bought a trial cloud service account in which we are trying to use OIC to integrate with EBS on-prem.

    But currently the download Agent is not allowing to download and raised the SR also but as per the oracle support they dont support the trial account for both subscription and technical issue and informed to contact the Forums.

    So not sure if anybody has faced the same issue and what is the process of getting the download agent.

    We get the below message when clicked on download agent

    "Currently, downloading Connectivity Agent is not supported. Please contact oracle support to download agent. "

     

    Thanks

    Chetan