Creating Oracle database connectivity in OIC - Part 2 (Agent Installation)
This blog is continuation of the first blog.
Oracle agents are programs that create connectivity between on premise database or database as a service to OIC, These agents can be consider tiny programs runs on the same port as the SSL is and allow direct connectivity between OIC and database.
OIC does not connect to database directly but always use this agent to connect for two way communication. Agents are not pre-installed on DBCS or on-premise database. Hence we need to install Agents on these machines. In this post we will see how to install agent on a DBCS, steps are very much similar post login to machine where database is hosted. Also firewall should be open for default port between internet and your on-premise machine. In DBCS you need not to care about firewall, oracle itself provide a public IP to connect.
Tools required - winscp, putty, puttygen, OIC console
1.) Keys - Oracle DBCS is well guarded by SSH keys hence we need Keys created in last post. Now go to this location and unzip this zip file. We can see two files, one is private key and other is public key file.
2) Now we need to open the puttygen tool, if you don't have you can download and install putty software which will install puttygen too. Once tool is open and let's click on load button and select the private key file been extracted in step 1.
3) Once key is loaded, we can add a pass phrase (password to this key) and save it on your machine. This pass phrase will protect this file, everything we login putty will ask to provide the passphrase we entered now.
4) Now open the putty and we are required to provide following information
1. ip address - This you have from post 1.
2. connection --> Data --> Enter opc
3. Connection --> ssh --> Auth --> browse the key been saved in step 3.
4. go to session --> save session use same IP and click on save for future use.
5. Once all the information entered, we can click on open a new session and once screen request, we can provide the pass phrase been used in step 3, once its been done we are now login to system where our dbcs is hosted. This also mean your keys are working fine, hurrey !!!!!!
6) Now we need to download the installer from ICS instance, we need to login to ICS again. Let go to ICS console and click on agent link, it will take us to screen where agents are listed and also have a download button to download connectivity agent. Lets download and save it to local machine.
7. Now lets create a new connectivity agent in ICS, Click on create a new agent group. In the popup provide all the information, just note down the name of the identifier and also url of the ICS service, we will need it in future steps. Click on create and leave this page.
8. Now we are again back on agent creation, we need to login to winscp using the same credentials, use advance setting of the winscp to provide the key generated and used earlier.
9) Now login, it will again ask us pass phrase lets provide and login. Once login we can copy the downloaded file oic_connectivity_agent.zip(which we have downloaded from OIC) to home folder of your opc user. It will take sometime based on the network bandwidth we have. Once finish close Winscp.
10) Now lets login back to putty, and go to home location and unzip the file, just uploaded. Once file is extracted, we will be able to see multiple files here.
11) Now from the files, lets open the file InstallerProfile.cfg and provide the following information, we should not worry about providing username and password, as it will be encrypted post first run.
oic_URL=<your OIC URL>:443
agent_GROUP_IDENTIFIER=Identifier created in Step1
#Optional Parameters
oic_USER=OIC User Name
oic_PASSWORD=OIC Password.
12) Now we need to run the following command, it will start connectivity agent in background and will keep it running, even if we close the putty.
>> java -jar connectivityagent.jar &
we can utilize, below command to verify if agent is running.
13) Lets login back to OIC console and go to designer -> Agent. If we see now number of agents, it should be increase by 1.
Basic infrastructure is now ready, our connection has now been establish and its good to go with creating a database adapter based OIC integration.
We will see in our next blog about creation of the integration, which can interact with database. Mean while we can create another dbcs instance, and add connectivity to ICS.
This blog is continuation of the first blog.
Oracle agents are programs that create connectivity between on premise database or database as a service to OIC, These agents can be consider tiny programs runs on the same port as the SSL is and allow direct connectivity between OIC and database.
OIC does not connect to database directly but always use this agent to connect for two way communication. Agents are not pre-installed on DBCS or on-premise database. Hence we need to install Agents on these machines. In this post we will see how to install agent on a DBCS, steps are very much similar post login to machine where database is hosted. Also firewall should be open for default port between internet and your on-premise machine. In DBCS you need not to care about firewall, oracle itself provide a public IP to connect.
Tools required - winscp, putty, puttygen, OIC console
1.) Keys - Oracle DBCS is well guarded by SSH keys hence we need Keys created in last post. Now go to this location and unzip this zip file. We can see two files, one is private key and other is public key file.
2) Now we need to open the puttygen tool, if you don't have you can download and install putty software which will install puttygen too. Once tool is open and let's click on load button and select the private key file been extracted in step 1.
3) Once key is loaded, we can add a pass phrase (password to this key) and save it on your machine. This pass phrase will protect this file, everything we login putty will ask to provide the passphrase we entered now.
4) Now open the putty and we are required to provide following information
1. ip address - This you have from post 1.
2. connection --> Data --> Enter opc
3. Connection --> ssh --> Auth --> browse the key been saved in step 3.
4. go to session --> save session use same IP and click on save for future use.
5. Once all the information entered, we can click on open a new session and once screen request, we can provide the pass phrase been used in step 3, once its been done we are now login to system where our dbcs is hosted. This also mean your keys are working fine, hurrey !!!!!!
6) Now we need to download the installer from ICS instance, we need to login to ICS again. Let go to ICS console and click on agent link, it will take us to screen where agents are listed and also have a download button to download connectivity agent. Lets download and save it to local machine.
7. Now lets create a new connectivity agent in ICS, Click on create a new agent group. In the popup provide all the information, just note down the name of the identifier and also url of the ICS service, we will need it in future steps. Click on create and leave this page.
8. Now we are again back on agent creation, we need to login to winscp using the same credentials, use advance setting of the winscp to provide the key generated and used earlier.
9) Now login, it will again ask us pass phrase lets provide and login. Once login we can copy the downloaded file oic_connectivity_agent.zip(which we have downloaded from OIC) to home folder of your opc user. It will take sometime based on the network bandwidth we have. Once finish close Winscp.
10) Now lets login back to putty, and go to home location and unzip the file, just uploaded. Once file is extracted, we will be able to see multiple files here.
11) Now from the files, lets open the file InstallerProfile.cfg and provide the following information, we should not worry about providing username and password, as it will be encrypted post first run.
oic_URL=<your OIC URL>:443
agent_GROUP_IDENTIFIER=Identifier created in Step1
#Optional Parameters
oic_USER=OIC User Name
oic_PASSWORD=OIC Password.
12) Now we need to run the following command, it will start connectivity agent in background and will keep it running, even if we close the putty.
>> java -jar connectivityagent.jar &
we can utilize, below command to verify if agent is running.
>> ps -ux |grep agent
13) Lets login back to OIC console and go to designer -> Agent. If we see now number of agents, it should be increase by 1.
Basic infrastructure is now ready, our connection has now been establish and its good to go with creating a database adapter based OIC integration.
We will see in our next blog about creation of the integration, which can interact with database. Mean while we can create another dbcs instance, and add connectivity to ICS.
No comments:
Post a Comment