A Definitive Guide to Agent Installation and MYSQL Connection
Scroll to top

A Definitive Guide to Agent Installation and MYSQL Connection


Dhruvil Pandya - July 15, 2022 - 0 comments

Reading Time: 4 minutes

In this blog, we will define clear steps for agent installation and MYSQL connection. It is important to follow the step-by-step process.

Step 1:  Access the oic instance via the URL : Oracle Integration | Home (oraclecloud.com) and navigate to the Integration tab and click on Agents. 

Oracle Integration Home

Oracle Integration Home

Step 2: Once in the Agent tab , click on Create Agent group and create the agent group.

create new agent group

create new agent group

Step 3: Navigate to the Download in the upper right corner and click on connectivity agent and download the installer.

connectivity agent

Step 4: Navigate to the Download folder in the PC and unzip the folder and rename as OIC2.

OIC Home

OIC Home

Step 5: Install the mysql jar installer > unzip it > select mysql jar file > Copy (Ctrl+C) and hence navigate to OIC2foler> oic_conn_agent_installer (3)>agenthome>thirdparty>lib and paste the mysql jar file in lib.

MYSQL Installer

MYSQL Installer

Step 6: Edit the installer profile.cfg file and then enter the required parameters and save the file.

Edit MYSQL Installer

Step 7: Now login to the prod instance via ip address :230.238.32 and login as opc and install java 11 via the command : sudo yum install java or sudo yum install java-11-openjdk(if previous version installed) to install the packages and dependencies.

java 11

Step 8: Set the java version 11 as default using the command : sudo alternatives –config java and enter the required number for java version and verify the java (if multiple java installed).

java version 11

java version 11

Step 9: Now login to FileZilla and connect to this instance and create a new directory : OIC Agent in /home/opc and transfer the OIC2 folder files from the machine into OICAgent and refresh and check if all the files are reflecting.

Filezilla

Filezilla

Filezilla

Step 10: Now login to putty and run the command : sudo update-alternatives –config java to find the path where java is installed and configure Java home by running the command : export JAVA_HOME=$(readlink -f /usr/bin/java | sed “s:/bin/java::”)

putty

Step 11: Now run the command : java –jar connectivityagent.jar to install and start the agent.

connectivity agent

Step 12: Now run the command : nohup java –jar connectivityagent.jar & and check the no hup file log in filezilla.

filezilla

Step 13: Now navigate to cloud.google.com and access the console and select SQL and create a new SQL instance.

SQL Instance

Step 14: Now we need to install the SSL certificate on the agent host hence click on the SSL certificate URL and then export the certificate using the export wizard and upload it on the server in filezilla to agenthome/agent/cert

SSL certificate

SSL certificate

SSL certificate

Step 15: Now finally install the certificate on the agent host by running the command : keytool -importcert -keystore keystore.jks -storepass changeit -alias alias_name -noprompt -file gcp_certificate.cer

Install SSL certificate

Step 16: Now navigate to the oic instance click on Integration>Connections>mysql> Test

Oracle Integration

We hope these detailed steps will help you with the agent installation and MYSQL connection.

If you would like us to get in touch with us about the above blog, please share your thoughts with us on business@conneqtiongroup.com

Author avatar

Dhruvil Pandya

Dhruvil is a Marketing and Strategy Manager at Conneqtion Group, a Oracle iPaaS and Process Automation company. He comes with a vast experience of working in the Marketing, Branding and Content Marketing in various industries including IT service, SaaS, Natural Gases & Equipments, Food and United Nations. He has completed his MBA in Marketing from Western Sydney University and has worked for more than 7 years with Indian and Australian startups. He has a good acumen of business and marketing in the Indian startup ecosystem and has worked with BOC Gases, a leading Gas company handling their APAC Marketing.

Related posts

Post a Comment

Your email address will not be published.