Integration

Get Involved. Join the Conversation.

Topic

    Mohana Gopal Selvam
    DBCS - Connection
    Topic posted July 31, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged Adapters, Connection, Database 
    36 Views, 12 Comments
    Title:
    DBCS - Connection
    Content:

    Hi,

    We have tried to connect the Oracle Database Cloud Service using 'Oracle Database' adapter. But it is error out. How to create connection for DBCS.

    Thanks,

    Mohan

    Image:

    Comment

     

    • Hemanth Lakkaraju

      Configure connectivity agent to DBCS and attach it in connection.

    • Mohana Gopal Selvam

      Hi Hemanth,

      I have configured the Connectivity section where I mentioned, Host, Port & Service Name and I have provided the User Name & Password in the Security section. I can able to connect the SQL Developer using the same credentials. 

      What I have missed here?

      Thanks,

      Mohan

    • Sunny Chugh

      Hi Mohan

       

      it may be agent issue or its not configured

       

      please see below blog to configure agent

      https://www.techsupper.com/2017/07/database-adapter-in-oarcle.html

      regards

      Sunny

    • Mohana Gopal Selvam

      Hi Sunny,

      I have created the agent in ICS, but when I click configure Agent nothing is displayed. Since we have used Cloud DB we haven't installed anything in DBCS. Do we need to configure anything in DBCS?

      Thanks,

      Mohan

    • Sunny Chugh

      Hi Mohan

       

      this needs to be setup at DB layer, kindly check below detailed information which we had used

       

      https://redthunder.blog/2017/02/09/teaching-how-to-use-the-integration-cloud-service-connectivity-agent/

       

      Regards

      Sunny

    • Mohana Gopal Selvam

      Hi Sunny,

      Have you integrated with DBCS or on-premise DB?

      Thanks,

      Mohan

    • Sunny Chugh

      Hi Mohan

       

      we have tried with DBCS but if the connectivity is established between VCN and On Premise then its more or less the same concept

       

      regards

      Sunny

    • Arunkumar

      Hi Sunny,

      Try "Oracle DBaaS" Adopter to connect to DBCS. This works without an agent also. 

      While Testing the connection if it shows 75% only then you configure the Agent to Complete it.

      Thanks,

      Arun

       

       

       

    • Sunny Chugh

      thanks but we have tried and configuring agent is the option for on premise.

      if you have to connect to On premise DB then we have to have agent configuration.

       

      regards

      Sunny

    • Mohana Gopal Selvam

      Hi Arun,

      Do you have any document, how to configure agent for DBCS?

      Thanks,

      Mohan

      • Arunkumar
        • Arunkumar

          HI Mohan,

          Please ignore above Link.

          https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/agent-download-and-installation.html#GUID-932D53E0-69F1-42E2-8F9C-B2CB3B69A5B4

           

          Agent Download and Installation

          The agent must be downloaded and installed on your local host. If needed, you can also install a security certificate on your local host. If necessary, you can also run the agent installer as a background process.

          Download and Install the Agent

          Install the connectivity agent installer to install the agent in your local environment. During installation, you associate the connectivity agent with the agent group identifier you generated when creating an agent group in Oracle Integration.

          Note:

          • You must have the Java execute permission to install and restart the agent.
          • You must have the ServiceAdministrator or ServiceDeveloper role to download the agent.

            See Grant Access and Secure of Administering Oracle Integration.

          1. Create a directory for connectivity agent installation on your on-premises host.

            Note:

            • Do not install the agent in a directory path that includes /tmp.

              The agent must never be installed in /tmp. As per the Filesystem Hierarchy Standard version 3.0, /tmp is meant for temporary files. Even though the install and agent work, it is not a recommended location for agent installation because the directory in /tmp may be deleted after the reboot of the system or agent virtual machine.

            • Agent installation is not supported with use of an SSL proxy.
          2. In the left navigation pane, click Integrations, then click Agents.

          3. Click Download > Connectivity Agent.

          4. Download the connectivity agent installer to the directory on your on-premises host.

          5. Unzip oic_connectivity_agent.zip.

          6. If you need to add any third party JARs (for example, for the Siebel Adapter or MySQL Adapter), copy them under the agenthome/thirdparty/lib directory.

            Note:

            If you perform this step after installing the connectivity agent, you must restart the agent.

            See Restart the Agent.

          7. Modify InstallerProfile.cfg to include the following information:
            # Required Parameters
            # oic_URL format should be https://hostname:sslPort
            oic_URL=https://oic_host:ssl_port
            agent_GROUP_IDENTIFIER=
            
            #Optional Parameters
            oic_USER=
            oic_PASSWORD=
            
            #Proxy Parameters
            proxy_HOST=
            proxy_PORT=
            proxy_USER=
            proxy_PASSWORD=
            proxy_NON_PROXY_HOSTS=
            
            
            Where:
            • oic_URL: This parameter is required. This is the HTTPS URL for the Oracle Integration host. The port is 443.

            • agent_GROUP_IDENTIFIER: This parameter is required. This is the identifier for the connectivity agent group created in Oracle Integration. The identifier name is case sensitive.

              See Create an Agent Group.

            • oic_USER: This optional parameter provides the Oracle Integration username. When the agent runs for the first time, this field, if provided, is encrypted in the properties file. If this field is not provided, you are prompted to enter the username at agent startup and it is not persisted.
            • oic_PASSWORD: This optional parameter provides the Oracle Integration password. When the agent runs for the first time, this field, if provided, is encrypted in the properties file. If this field is not provided, you are prompted to enter the password at agent startup and it is not persisted.
            • Proxy Parameters: These parameters are only required if the connectivity agent is used with a proxy in the on-premises environment.

          8. Set the JAVA_HOME property to the location of the JDK installation.

          9. Set the PATH property. For example, if csh is your shell:
            setenv PATH = $JAVA_HOME/bin:$PATH
            
          10. Run the connectivity agent installer from the command prompt:

            java –jar connectivityagent.jar
            
          11. Provide the Oracle Integration credentials when prompted.
            Proceeding to install a new agent ...
            Enter your OIC username : 
            Enter password for username : 
            
          12. Wait for a successful installation message to appear.
            Done with Agent installation & configuration... Starting agent for message processing.
            Agent started successfully... listening for new messages... 
            

            If errors occur, review the agent diagnostic logs.

            See Monitor Agents.

          13. Depending on your agent environment, you may also need to install a certificate.

            See Install a Certificate on the Agent Host.