OCI | RishOraDev's Oracle Blogs

Tag Archives: OCI

Create a Confidential Application to Connect to OIC using Client Credential Grant Type

Posted on Apr 19, 2026 by RishOraDev One comment

In modern enterprise ecosystems, seamless integration between applications is critical. When working with Oracle Integration Cloud (OIC), secure communication becomes a top priority. This is where OAuth 2.0-based authentication and confidential applications come into play. A confidential application is a secure client that can safely store credentials such as a client ID and client secret. It enables Intelligent Advisor to

Home

Create Your First Oracle Generative AI RAG Agent

Posted on May 22, 2025 by RishOraDev 2 comments

In my previous blog, we learnt about the pre-requisite steps for provisioning an Oracle Generative AI RAG Agent in Oracle Cloud Infrastructure (OCI). In the subsequent blog, Creating a Knowledge Base for creating Oracle Generative AI RAG Agent, we learnt how to create a storage bucket and then created a knowledge base which derives the data from the text files

Home
OCI

Creating a Knowledge Base for creating Oracle Generative AI RAG Agent

Posted on May 22, 2025 by RishOraDev 2 comments

This is the second blog of the series Create an Oracle Generative AI RAG Agent. For simplicity, I have broken the post down into 3 parts: In my previous blog, we discussed the steps that you need to perform if your tenancy is not subscribed to any of the regions where OCI Generative AI Services are available. In this blog,

Home
OCI

Enabling Oracle Generative AI Agent for OCI Regions

Posted on May 12, 2025 by RishOraDev 2 comments

What are Generative AI RAG Agents? Generative AI Agent is a fully managed service that combines the power of Large Language Models (LLMs) with AI technologies, to create intelligent virtual agents, that can provide accurate, personalized and contextually-relevant responses to end-user queries, and creates a highly engaging customer experiences. The method of augmenting the user requests with private organizational data

Home
OCI

Creating a basic OIC Integration with REST

Posted on Apr 29, 2025 by RishOraDev Leave a comment

This post would be particularly useful for those who are just starting their learning journey with Oracle Integration Cloud. We will create a basic and fundamental integration to call and invoke a simple REST web service in an orchestrated integration. We will learn how to: So let us begin. Create Project It is always recommended that you create an integration

Home
OIC

Manage File Server Settings in Oracle Integration 3

Posted on Apr 27, 2025 by RishOraDev Leave a comment

In one of the previous posts we learnt how to create a Oracle Integration 3 instance. In the next one, we saw how to enable the File Server. In this particular post, we will explore some of the basic configuration for the File Server from the Oracle Integration instance. More specifically, we will look into the following topics: So lets

Managing Users and User Groups in OCI

Posted on Apr 27, 2025 by RishOraDev One comment

You can create an user or user groups if you are granted identity domain administrator or user administrator role in the Administrators page Identity Cloud Services console(IDCS). In this blog we’ll learn how to create users and user groups from the IDCS page within the OCI console. Create User To create an user, login to OCI console using an user

Enabling File Server in Oracle Integration 3

Posted on Apr 21, 2025 by RishOraDev One comment

If you are looking to design a file-based integration, then you need to use a File Server. Oracle Integration comes bundled with an SFTP server which you can use to store, share, and receive files, including files for SaaS integrations and third-party transfers. Oracle provides you with 500 GB of free storage. When you provision an Oracle Integration Cloud instance,

Creating an Oracle Integration 3 Instance

Posted on Apr 20, 2025 by RishOraDev 2 comments

Oracle Integration Cloud instances help you to design integration between the cloud applications and on-premise applications. It is a fully managed, pre-configured environment loaded with hundreds of pre-built adapters to connect with Oracle and other third-party applications. You can automate business processes, develop visual applications, use an SFTP-compliant file server to store and retrieve files, and exchange business documents with

Generating an API Signing Key through OCI Console

Posted on Apr 8, 2025 by RishOraDev Leave a comment

In this post, we will look into the step-by-step process of how you can generate a private key/public key pair from the OCI Console. When the OCI console is used to generate the API signing key pair, a configuration file preview snippet is generated with the following keys and OCIDs. Parameters Description user OCID of the user for whom the

Home
OCI

Step-by-Step Guide to Oracle Database API for MongoDB

Posted on Mar 26, 2025 by RishOraDev Leave a comment

Using Oracle Database API for MongoDB, you can manipulate collection of JSON documents stored in an Oracle Database. If you are using ORDS version 22.3 or later, then you can use Oracle Database MongoDB API with any Oracle Database Release 21c or later, or Oracle Autonomous Database 19c or later(serverless, dedicated, and cloud@customer). You can modify the configuration of an

Home
OCI

Configuring Oracle Cloud Infrastructure (OCI) Bastion Service

Posted on May 30, 2024 by RishOraDev Leave a comment

Oracle Cloud Infrastructure Bastion provides restricted and time-limited access to target resources that don’t have public endpoints. Bastions let authorized users connect from specific IP addresses to target resources using Secure Shell (SSH) sessions. The target instance can be a compute instance or a DB system, an Autonomous Database for Transaction Processing or a Mixed Workload Database. In this session, we will

Home
OCI

Uploading File from OCI Object Storage to Oracle Autonomous Database

Posted on May 26, 2024 by RishOraDev Leave a comment

I have shown in my previous post, how you can create an Oracle ATP Database 23ai on Oracle Cloud free Tier. In this post let us understand, how we can create Upload a File containing data from OCI Object Storage to a table in the database, using the DBMS_CLOUD Package. We have created a table EMP and we will load

Home
OCI

User Creation in ORACLE Cloud Autonomous Database 23ai

Posted on May 25, 2024 by RishOraDev Leave a comment

In my previous post, we saw how we can create an Autonomous Database 23ai on Oracle Cloud. In this post we will see, how we can create an user and connect to the user. User Creation To create an user, login to your OCI console. From the Navigation Menu, click on Oracle Database and then on Autonomous Database. You should

Oracle Autonomous Database 23ai on Oracle Cloud

Posted on May 25, 2024 by RishOraDev 2 comments

In my previous posts, I had demonstrated how you can configure Oracle Database 23ai Free on Oracle VM or on docker. In this post, we will see how we can configure Oracle Autonomous Database 23ai on Oracle Cloud free Tier. It is fairly simple to setup. So let’s jump into it together!!! Once you have logged into you Oracle Cloud