Saturday, 31 October 2026

Create Your First Oracle Generative AI RAG Agent-2026

 Dear All,

In this blog, we will learn how to create a Generative AI Agent within OCI. We will be creating a Retrieval-Augmented Generative (RAG) Agent. 

We will be using Llama 3, as the preferred Large Language Model (LLM). 

The AI Agent will interact with the LLM and produce a more accurate and contextually-relevant response using the data defined in the knowledge base. 

As part of the agent creation process, we will be creating an Endpoint, which will be used to communicate with the Agent.

Create Generative AI Agent

From the navigation menu, click on Analytics & AI > Generative AI Agents.


Click on the Agents tab. Make sure you select the compartment where you want to create the agent. In this case, I’m creating the agent in the root compartment.

In the Agents list page, click on Create agent.



In the Basic information page, provide a meaningful Name for the agent. Chose the correct compartment from the compartment list. Enter a Description for the agent.


Type in a Welcome message. When users start the chat with the agent, they would be greeted by this message. 

This is optional. If you don’t enter a custom Welcome message, a default Welcome message is displayed.


Note: You can add/create multiple Tools as part of the next step, you can add Routing instructions, which will affect the behavior of the agent. 


For example, you can say “Always invoke the RAG Tool first”. For this example, since we will create just the RAG Tool for the agent, we will leave this field blank.

Click Next.


Next step is to create the tool(s). Note that the tools are created after you create the agent. Click on Create tool.


You can select from the pre-built tools – RAG, SQL, Custom tool. For this blog, since we are creating a RAG Agent, we will select RAG.


In the RAG Configuration section, provide a meaningful Name to the RAG tool. Enter a Description. In the Custom instructions field, you can enter an instruction in natural language for the agent’s responses. For the purpose of this blog, we will leave it blank.

In the Add knowledge bases section, select the Compartment from the compartment list. Then, select the knowledge base that we had created in the previous post. If you have not gone through that post, please visit “Creating a Knowledge Base for creating Oracle GenAI RAG Agent”.

Now click Create tool.





Next step is to Setup the endpoint. In the Setup agent endpoint page, select the checkbox Automatically create an endpoint for this agent. This will create an endpoint when the agent is created.

In the Guardrails section, I keep the Enable human in the loop option disabled.

In the Content moderation section, for both for input (user prompt) and output (generated response), I chose to Block any toxic and violent contents. These are Oracle recommended options.


I chose Block for Prompt injection (PI) protection, to identify and protect the response to be manipulated by malicious inputs.

I chose the recommended options to Block Personally identifiable information (PII) protection for input (user prompt) and output (generated response).

Click Next.


Review the setup. I all looks good, click on Create agent.



Once you click on submit button, the agent will be created. You can check the status below.



Thanks,

Srini

Friday, 30 October 2026

Oracle 19C OCT-2026 Latest RU Patch - 19.33 step by step lab

 

Hi All,


In this post i am going to show you how to download and apply latest Oracle 19C Oct-2026 RU patch on Oracle linux X86-64 bit system .


step 1 : connect to Sign in options support.oracle.com 

click on patches >> enter the patch number and select OS click on apply ... 






Click on the patch number 



here i am going to show you RDBMS patch not Grid one ..

click on the download option 




select the patch and that will downloaded .. 




post download the patch copy to the server and unzip the patch , 

pre-requisites >>> take the backup of oracle home and important files , take invalid count etc .. 

start apply the patch from here >>>> 


Note : patch readme url 

updates.oracle.com/Orion/Services/download?type=readme&aru=29514650


stop the database listener and database services .


we need to check the opatch version and update as per the readme suggestion .

opatch version : 





then start apply the RU patch ..

QL> select count(*) from dba_objects where status='INVALID';


  COUNT(*)

----------

0




SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.





set the path and apply the patch ::









post apply the RU patch >>>  start the services  and take invalid count .


make sure PDB is read write mode and then run datapatch -verbose ..




SQL> select count(*) from dba_objects where status='INVALID';


  COUNT(*)

----------

0






[oracle@dbnode1 39915792]$ datapatch -verbose

SQL Patching tool version 19.33.0.0.0 Production on Sat Oct 31 02:02:44 2026

Copyright (c) 2012, 2026, Oracle.  All rights reserved.


Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_20996_2026_10_31_02_02_44/sqlpatch_invocation.log


Connecting to database...OK

Gathering database info...done


Note:  Datapatch will only apply or rollback SQL fixes for PDBs

       that are in an open state, no patches will be applied to closed PDBs.

       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation

       (Doc ID 1585822.1)


Bootstrapping registry and package to current versions...done

Determining current state...done


Current state of interim SQL patches:

  No interim patches found


Current state of release update SQL patches:

  Binary registry:

    19.33.0.0.0 Release_Update 261009085306: Installed

  PDB CDB$ROOT:

    Applied 19.32.0.0.0 Release_Update 260705220710 successfully on 18-OCT-26 07.29.39.174831 PM

  PDB PDB:

    Applied 19.32.0.0.0 Release_Update 260705220710 successfully on 18-OCT-26 07.42.46.949144 PM

  PDB PDB$SEED:

    Applied 19.32.0.0.0 Release_Update 260705220710 successfully on 18-OCT-26 07.42.46.955549 PM


Adding patches to installation queue and performing prereq checks...done

Installation queue:

  For the following PDBs: CDB$ROOT PDB$SEED PDB

    No interim patches need to be rolled back

    Patch 39915792 (Database Release Update : 19.33.0.0.261020 (39915792)):

      Apply from 19.32.0.0.0 Release_Update 260705220710 to 19.33.0.0.0 Release_Update 261009085306

    No interim patches need to be applied


Installing patches...

Patch installation complete.  Total patches installed: 3


Validating logfiles...done

Patch 39915792 apply (pdb CDB$ROOT): SUCCESS

  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/39915792/29514650/39915792_apply_PROD_CDBROOT_2026Oct31_02_04_04.log (no errors)

Patch 39915792 apply (pdb PDB$SEED): SUCCESS

  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/39915792/29514650/39915792_apply_PROD_PDBSEED_2026Oct31_02_07_00.log (no errors)

Patch 39915792 apply (pdb PDB): SUCCESS

  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/39915792/29514650/39915792_apply_PROD_PDB_2026Oct31_02_07_00.log (no errors)

SQL Patching tool complete on Sat Oct 31 02:15:08 2026

[oracle@dbnode1 39915792]$ 


release the instance ...

Following errors we can ignore :



Errors in the lab :: if we dont have space we will get below error 


[oracle@dbnode1 39915792]$ export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@dbnode1 39915792]$ which opatch

/u01/app/oracle/product/19.0.0/db_home/OPatch/opatch

[oracle@dbnode1 39915792]$ opatch apply

Oracle Interim Patch Installer version 12.2.0.1.53

Copyright (c) 2026, Oracle Corporation.  All rights reserved.



Oracle Home       : /u01/app/oracle/product/19.0.0/db_home

Central Inventory : /u02/app/oraInventory

   from           : /u01/app/oracle/product/19.0.0/db_home/oraInst.loc

OPatch version    : 12.2.0.1.53

OUI version       : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/db_home/cfgtoollogs/opatch/opatch2026-10-31_01-42-07AM_1.log


Verifying environment and performing prerequisite checks...

Pre-patch library snapshots saved for post-patch processing.

Prerequisite check "CheckSystemSpace" failed.

The details are:

Required amount of space(10585.129MB) is not available.

UtilSession failed: 

Prerequisite check "CheckSystemSpace" failed.

Log file location: /u01/app/oracle/product/19.0.0/db_home/cfgtoollogs/opatch/opatch2026-10-31_01-42-07AM_1.log


OPatch failed with error code 73




Thanks ,

Srini




Sunday, 18 October 2026

How to Apply Oracle 19C Latest RU patch on OEL 7 - 19.32 step by step

 Dear All,


In this post i am going to share step by step lab how to apply Latest RU patch on Oracle 19C Database .

Lab Environment :   Database Version > 19.3.0.0 

OS : OEL 7


Download latest RU patches from Support. 

https://support.oracle.com/support/?page=sptemplate&sptemplate=cp-patches-updates-view-more&cp-patches-updates-view-more=cp-patches-details


enter the patch number and platform details click on Apply 




Click on the patch number and download 







download the pre-requisite for this 19.32 patch was 6880880 latest 12.****.1.53



Copy the patch to server and unzip it .

https://updates.oracle.com/Orion/Services/download?type=readme&aru=28919163



stop the database services and set the path ..  


Note : take backup of all important files and home .

Before patch versions :




 

check the database status and stop the database




SQL> select count(*) from dba_objects where status='INVALID';


  COUNT(*)

----------

0


[oracle@dbnode1 OPatch]$ srvctl stop database -d prod

[oracle@dbnode1 OPatch]$ srvctl status database -d prod

Instance prod1 is not running on node dbnode1

Instance prod2 is not running on node dbnode2



unzip the opatch under oracle home , post that OPatch version would be latest 

[oracle@dbnode1 db_home]$ cd OPatch
[oracle@dbnode1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.53

OPatch succeeded.

apply the RU PATCH 




Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   39472050  


Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.


Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/19.0.0/db_home')



Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '39472050' to OH '/u01/app/oracle/product/19.0.0/db_home'

ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.datamining, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.rdbms.util, 19.0.0.0.0...


Patching component oracle.rdbms.rsf, 19.0.0.0.0...


Patching component oracle.rdbms, 19.0.0.0.0...


Patching component oracle.assistants.acf, 19.0.0.0.0...


Patching component oracle.assistants.deconfig, 19.0.0.0.0...


Patching component oracle.assistants.server, 19.0.0.0.0...


Patching component oracle.blaslapack, 19.0.0.0.0...


Patching component oracle.buildtools.rsf, 19.0.0.0.0...


Patching component oracle.wwg.plsql, 19.0.0.0.0...

Once the patch applied successfully start the database services :





post patch invalid object count 


SQL> alter session set container=PDB;


Session altered.


SQL> select count(*) from dba_objects where status='INVALID';


  COUNT(*)

----------

0

Opatch completed : 



run the datapatch verbose 



datapatch -verbose log :
================

[oracle@dbnode1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.32.0.0.0 Production on Sun Oct 18 17:13:01 2026
Copyright (c) 2012, 2026, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_17850_2026_10_18_17_13_01/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.32.0.0.0 Release_Update 260705220710: Installed
  PDB CDB$ROOT:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 03-MAR-25 09.36.38.015829 PM
  PDB PDB:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 03-MAR-25 09.47.18.230520 PM
  PDB PDB$SEED:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 03-MAR-25 09.47.18.230520 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED PDB
    No interim patches need to be rolled back
    Patch 39472050 (Database Release Update : 19.32.0.0.260721 (39472050)):
      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.32.0.0.0 Release_Update 260705220710
    No interim patches need to be applied

Installing patches...




Thanks,
Srini


Sunday, 24 May 2026

Oracle E-Business Suite 12.2.15 Fresh Install Image In Oracle Cloud - OCI

 Hi All,


In this post i am going to share you how to install Oracle EBS R12.2.15 on OCI .

you will use an image hosted in Oracle Cloud Infrastructure (OCI) to provision an Oracle E-Business Suite Release 12.2.15 with Oracle Database 19c environment on a single Compute instance (VM) on OCI.

 

You can provision using the demo install image, and conduct demonstrations and explore new features with the resulting environment, or you can provision using the fresh install image, and tailor the resulting environment to your specific needs.


Oracle E-Business Suite 12.2.15 Demo Install Image - The instance contains demonstration data and is suitable for conducting demonstrations and exploring new features.

Oracle E-Business Suite 12.2.15 Fresh Install Image - The instance can be configured with your own data and specific, functional setups so that you can test business processes tailored to your needs.


OS :: 
Oracle Linux 88.10 64-bit

Database version : 19C 

Application version : 12.2.15 

Node : Single node configuration 

login to oracle cloud account and click on left side menu >> scroll down to select market place >





Click on all applications 




search for  Oracle E-Business Suite 12.2.15 Fresh Install Image 




Click on Image and select launch instance 


check the accept and click on launch 


give the instance name if you want custom else leave it default 


updated the shape from 1 core ocpu to 6 core ocpus..




default security and click on next 


if you want to create VNC do it in this step else create vcn before launch the instance , i am using existing vcn and subnet 



warning related ti IPV 6 we can ignore 


update the public key and save the private key with you dont share the private key ...





click next 

storage keep default and click next 



review details and click on create .



estimate cost to maintain the EBS R12.2.15 fresh instance 


hit the create option > we can see its provisioning 



after few seconds instance is running status 



we can access all the instances from OCI Console from the below navigation 





select the instance we can see all the details and we can connect the cloud instance from local machine using private key .




use public ip with opc user ... we can able to connect to cloud server from the local machine.





this concludes provision EBS R12.2.15 with 19C database on OCI completed .

Thanks,

Srini