Creating Oracle database connectivity in OIC
Part 1 - Creating a DBCS instance
In OIC many time integration demand database connectivity from an Oracle database, which can either be on-premise or a database service configured in an oracle cloud database(DBCS). This 3 part post, and an step by step guide to create connectivity between the OIC and databsae in oracle cloud or from an on premise database.
Architecture
OIC use connectivity agent to connect to an on-premise database or an database service in cloud. You have to install connectivity agent manually on the on-premise machine or dbcs instance. This agent is responsible for the communication between the database and OIC.
In this post first we will talk about creating and oracle database service, if you want to connect to an onpremise database then you can start from the agent installation.
Creating and Oracle Database Service:
1) This step require access to oracle cloud instance, please login to cloud instance, if you already have acces to oracle cloud. Once login click on icon below and choose databsae.
2) Once database home page loaded, click on the create instance button, by this you are asking oracle to provison an oracle database instance, which will be used for the connectivity
3) Click on the next page, and fill all the parameter, I have opt for not adding the backup as this is kind of demo instance been created in this blog, but you can choose based on your requirement for creating a backup.
4) Add the SSH keys by creating new keys, if you already have keys you can use them instead of creating new, you should download keys safely as these keys will be required to login to this machine.
5) Once all the parameter is filled, click next to go to confirmation page and then click on create, Oracle cloud will take some time and your instance will be provisoned. Once provisioned please click on the instance name to get information about the instance.
6) Instace overview page provide information like connect string, public ip and also memory been used by this database instance.
7) Lests try to connect to this database using the sql developer. you need following parameter
1. IP - given on the page above.
2. Port - given on the page above
3. User - Sys or system
4. Password - used while provisioning this service.
Open the sql developer and create a new connection once filled all the information from above use test button to test and save to save. Once connected its open as a normal database you can create a new schema or add table to existing schemas.
8) Once this is done mean our database instance is ready for the agent installation lets go to next page to install the agent.
Click here to move to agent installation.
No comments:
Post a Comment