Oracle E-Business Suite R12.2.9 step by step install on OEL7.9 - Part 1/4

 Dear All,

In this post i am going share about Oracle E-Business Suite R12.2.9 step by step install on OEL7.9 this post showned donwload requried software - Part 1/4 .

High level step in this post :

Download EBS Software 

download RDBMS software 

Download OS - Oracle Enterprise Linux 7.9 

NOTE : 12.2.9 software was not showned in the edelivery at this time so i am showing software download process ... so i showned 12.2.15 , you can try 12.2.15 install in your POC system .

we have to download the software from oracle edelivery .

Search Software >>>   https://edelivery.oracle.com/osdc/faces/SoftwareDelivery

Login to edelivery and search for EBS Software ... select the marked one 

click on 12.2.15 and click on continue 

next select Platform and then requried software 

In this lab i am using Oracle linux X86-64 bit platform

select the marked one only if you need other software you can select and download , i am using what ever i select in below image 

after selecting the requried options then click on continue on below right side bottom 

read and accept the license agreement then only we will be able to continue ... click on continue 

For 12.2.0 download requried patches only 

For 12.2.15 below supplemental media 7 patches no need for this lab .. i can download remain 13 patches 

ECC if you need you can download in this lab we are not using so i am skkiping 

reamin database , webtier and weblogic patches we can donwload 

after selecting all click on download 

it will download Oracle SSN click on this and select the location where patches need to download .. all patches will be downloaded .

select the location and click next 

patches will be downloaded.

Download OS OEL 7 also 

login to edelivery and search for oracle linux and select OEL 7.9 ... i am usgin this for current lab , if you want you can download latest software as well.. which are certfied with EBS .

post download the software we can prepare the VM ... to install EBS R12.2.9

instructions to install Oracle E-Business Suite 12.2.9 on Oracle Linux 7.

Below are the high-level steps of the installation:

• Download Software and Patches

• Prepare OS (Oracle Linux 7) for Installation

• Build Stage

• Install Oracle E-Business Suite 12.2.0

• Apply Database Patch

• Apply Application Patches (CUP, AD, TXK)

• Install Oracle E-Business Suite 12.2.10 Release Update

see you in next session 

Thanks,

Srini

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

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