Oracle 23ai and The Difference between Oracle Database 23c & 23ai

 Dear All,

In this post i am sharing oracle 23ai database related information .

Oracle 23ai Database Introduction:

====== ============  ======== =========== ==============

Oracle 23ai is available cloud-first, i.e. in

Ø  Oracle Exadata Cloud@Customer,

Ø  OCI Exadata Database Service and OCI Base Database Service and in Oracle Database@Azure.

For More updated information follow this metalink id (Doc ID 742060.1)

Ø  Autonomous Database Always Free available in Oracle Cloud Infrastructure (OCI)

Ø  Autonomous Database Container Image available as a downloadable image

Ø  Oracle Database 23ai Free packaged for ease-of-use and available via download as a Container Image, VirtualBox VM, or Linux RPM installation file. Use the following Get-Started link to download your preferred packaged database software: Oracle Database Free Get Started

Ø  Security , performance , Availability and scalability

 

Oracle 23ai  DB >> the Autonomous Intelligent concept by automating many traditional database management tasks using AI (Artificial intelligence) and ML (Machine Learning)

Ø  Oracle Autonomous Database, which embodies the vision of a self-driving, self-securing, and self-repairing database.

Ø  Oracle Database 23c ( Renamed to 23ai) brings cutting-edge features to make the database more intelligent and capable of autonomous operation when paired with Oracle's cloud infrastructure.

Ø  The autonomous database uses machine learning to automatically upgrade, patch and tune itself while running.

Ø  Security updates are automated with no downtime required.

Ø  Machine learning is used to make sure the database consumes less compute and storage thanks to automatic compression of data.

Ø  The result is a faster, more reliable and cheaper database than the traditional database

AI is much better at eliminating complexity, human error and ensuring security than we humans .

The Difference between Oracle Database 23c announced last year and Oracle Database 23ai?

 

Ø  Given the importance of the breakthrough AI technology in this release, Oracle renamed Database 23c as Database 23ai. Oracle Database 23ai is the version 23.4.0.0.0 and will be referred to as such moving forward

 

Ø  Oracle provides upgrade paths from either Oracle Database 19c or Oracle Database 21c to 23ai. All other versions of the database need to upgrade to one of the versions listed prior, and then to 23ai. 

 

What is Automation database ?

Oracle database below functionality’s are Automated

Ø  Automated provisioning, scaling, and patching.

Ø  Automatic backup and recovery operations.

Ø  Automated index creation and performance tuning In Oracle.

 

What is Intelligence In Oracle database 23ai ?

 

Ø  AI-powered query optimization.

Ø  Self-repairing capabilities to minimize downtime.

Ø  Proactive detection of anomalies using built-in AI models.

Oracle 23ai Autonomous Features:

 

Ø  Autonomous Data Warehouse (ADW): Optimized for analytics.

Ø  Autonomous Transaction Processing (ATP): Tailored for OLTP workloads.

Ø  Autonomous JSON Database: Designed for NoSQL-style JSON document storage and processing.

 

 

 

Oracle Database 23ai Intelligent Features:

 

Oracle Database 23ai enhances its intelligent features with:

 

Ø  AI/ML Integration: Built-in AutoML, SQL-based machine learning, and direct support for developing and deploying ML models.

Ø  Adaptive Query Plans: Queries are adjusted in real-time based on changing data patterns or resource availability.

Ø  Proactive Monitoring: Intelligent diagnostics and performance tuning using Oracle AI capabilities.

Ø  AI-Driven Insights: Integration with OCI AI services for predictive analytics and NLP.

 

 

Oracle 23ai DB Key Features:

================= =========== ==============

Oracle Database 23ai brings more than 300 new features compared to the previous generation , such as

Ø  Oracle AI Vector Search,

Ø  True Cache,

Ø  Property Graph,

Ø  JSON relational duality,

Ø  Priority Transactions,

Ø  Data Use Case Domains,

Ø  increased limits, new data types and many more features with a focus on simplifying the use of AI with data, accelerating app development, and running mission-critical workloads.

 

Ø  AI Vector Search: Combines relational database processing with similarity search and retrieval augmented generation , AI Vector Search is a collection of features that includes a new vector data type, vector indexes, and vector search SQL operators that enable Oracle Database to store the semantic content of documents, images, and other unstructured data as vectors and use these to run fast similarity queries.

>>> AI Vector Search uses vectors to enable fast and simple queries on business data in conjunction with LLMs.

>>> A vector is a numerical representation of text, images, audio, or video that encodes the meaning of the data, not the underlying words or pixels. For more information about AI vector search go through this link https://www.oracle.com/database/ai-vector-search/

 

Ø  Automatic Transaction Rollback: Prevents transactions from blocking other high-priority transactions

Ø  Logical replication: Supported via Oracle GoldenGate

Ø  Rolling upgrades: Supported using Active Data Guard

Ø  Distributed transactions: Supports transactions that involve blockchain tables

Ø  Partition-based bulk dropping: Efficiently drops expired rows

Ø  Oracle Globally Distributed Database: Distributes data geographically and at scale

Ø  Raft protocol: Automatically failsover within seconds

Ø  Oracle True Cache: Improves app response times while reducing the load on database servers

 

 

Other features of Oracle Database 23ai:

================         ================                      ===============

 

Ø  Dev for data, Secure data encoding, Natural language processing, Simplifies application development, Speeds up development cycles, Makes SQL execution safer

 

 

 

What all other products announced with Oracle Database 23ai?

This announcement focuses on cloud first, developer first.

OCI:

·        Oracle Database 23ai on Exadata Cloud@Customer with Exadata Systems Software 24ai

·        Oracle Database 23ai on Exadata Database Service with Exadata Systems Software 24ai

·        Oracle Database 23ai on Base Database Service

·        OCI GoldenGate 23ai

Azure:

·        Oracle Database 23ai on Exadata Database Service with Exadata Systems Software 24ai

Developers:

·        Always Free Autonomous Database23ai

·        Autonomous Database 23ai Free Container Image

·        Oracle Database 23ai Free

·        GoldenGate 23ai Free

 

 

Why should we upgrade from Oracle Database 19c to 23ai?

Ø  Oracle Database 23ai is the next long-term support release of Oracle Database, superseding 19c.

Ø  A long-term release of Oracle Database offers five years of premium support and three years of extended support.

Ø   Oracle Database 19c Premier Support ends on April 30, 2026, and while Oracle waived the additional fees for Extended Support from May 1, 2024 to April 30, 2026, Extended Support will end on April 30, 2027, giving you a longer support overlap with Oracle Database 23ai. 2032

Free trial available for Oracle Database 23ai?

Ø  Oracle offers free trials for Oracle Database 23ai through Oracle Cloud Infrastructure (OCI) with Autonomous Database Free Tier.

Ø  Users can sign up for a free trial account and explore the features and capabilities of Oracle Database 23ai on OCI.

Alternatively, Oracle Database 23ai Free is available for download as a Linux RPM file, an Oracle Linux-based Docker image, Oracle Virtual Box VM, or packed with Vagrant

Thanks,

Srini

Oracle 19C DBA Online Training - Jan 2025

 

 Dear All,

RacsInfoTech stating new Oracle 19C DBA online Training from

 3rd Jan 2025 .

Oracle 19C DBA Course: Duration 50 hours

3rd Jan 2025 - 7:30PM to 9:00 PM IST ... (Only on Weekdays)

Contact us:   

racsinfotech@gmail.com   / +91 9392634440 (direct call / WhatsApp calls available)

Course Index:

 

Oracle 19C DBA Training with Live Labs.

1. 12c and 19c Architecture.

2. DBA Roles and Responsibilities 

3. Required tools and Prerequisites for DBA Training.

4. VirtualBox , Linux OS and Database Installation .

5. How to connect to database and Network setup .

6. User Management ( user , role , profile creation etc .. )

7. Tablespace / Storage management

8. Backup and Recovery.

9. Database Patching.

10. Database Clone.

11. Performance Tuning Basics( AWR/ADDM/ASH reports ).

12. ASM and DG Installation / Configuration .

13. Database Upgrade steps (  12c to 19c and 19C to 21C  ) .

14. Frequently asked Interview questions and answers Discussions.

15. CV Preparation suggestions and support.

16. Real time Scenarios and excises.

Note : we will provide the Lab setup* on your PC/ Laptops ,

 This training designed completely with Realtime scenarios .

 

Oracle DBA Course Content : See the above course content.

Join Our Below social media Groups:

==========================

WhatsApp Group:

https://chat.whatsapp.com/BctnmdzEH3pJh8yUhjtQDA

  

Follow My Oracle DBA and Apps DBA Blog :

https://anjaniappsdba.blogspot.com/

 

YouTube Channel:

www.youtube.com/@RACSINFOTECH 

Telegram Group :

https://t.me/+R2pg2-9Nsb1lNjFl

Udemy oracle dba 19c Course :: 

Thanks,

Srini

Oracle EBS R12.2 certification with Oracle Database 23ai on Database Cloud Services for Commercial Cloud

 Dear All,

In this post i am going to share the below information.

Oracle E-Business Suite Release 12.2 (EBS 12.2) certification with Oracle Database 23ai 

on Database Cloud Services for Commercial Cloud.

>>>   Oracle E-Business Suite (EBS) Release 12.2 is now certified with Oracle Database 23ai for on-premises Exadata Database Machine , Oracle Exadata Software version 24.1 (ExaOL8X) or later.

Ø  As an EBS 12.2 on-premises Exadata customer, once your system meets all of the necessary prerequisites you may upgrade to Oracle Database 23ai, specifically Release Update 23.5.

Oracle recently Announced that Oracle E-Business Suite (EBS) Release 12.2 is now certified for Commercial Cloud with Oracle Database 23ai (DB 23ai) on the following database cloud services:

     Ø  Oracle Base Database Service

     Ø  Oracle Exadata Database Service on Dedicated Infrastructure 

     Ø    Oracle Exadata Database Service on Cloud@Customer

As an EBS 12.2 customer running on one of these database cloud services in a commercial cloud region, once your system meets all of the necessary prerequisites you may upgrade to Oracle Database 23ai, specifically Release Update 23.5.

EBS 12.2.14 Certifications :

Note : check the certification information from the below link.  https://support.oracle.com/epmos/faces/CertifyHome

                                  

Ø  The latest long term release of Oracle Database is currently DB 23ai. The previous long term release of Oracle Database was Oracle Database 19c.

What's the Latest Information Regarding Support for EBS Databases?

     Most EBS customers have by now completed upgrades to Oracle Database 19c (DB 19c). If you are still running an older Oracle Database release, you should make plans to upgrade to DB 19c as soon as possible.

ØThose who are using older than 19C you have to upgrade your databases to 19C.

or perform an export/import from 12cR1/11gR2.

Ø DB 19c is the only database release with a direct upgrade path to DB 23ai and Oracle provides you Error Correction Support.

Notes : Oracle E-Business Suite Release 12.2 End of Error Correction Support for Oracle Database 12c Release 12.1.0.2 and 11g Release 11.2.0.4 (MOS Note 3051860.1), 

Release Schedule of Current Database Releases (MOS Note 742060.1)

What Can You Do Now to Get Your EBS Environment Ready for Oracle Database 23ai? 

Ø Upgrade to Oracle Database 19C : 

 Prior to upgrading to oracle 23ai your database should be 19C. bcz there no direct upgrades for lower than 19C. ( export and imports will support for 12cr1/11gr2***) 

Ø Be on the EBS Error Correction baseline or later : 

 The Error correction support baseline is EBS 12.2.7 for DB 23ai, all EBS Products you are running must be at the 12.2.7 or higher. (MOS Note 1195034.1)

Ø Perform the EBS System Schema Migration :  

      The EBS System Migration delivers enhancements that remove dependencies on database features that are desupported with oracle database 23ai.

     Performing the EBS System Schema Migration which includes applying the EBS System Schema Migration Completion Patch is a prerequisite for upgrading your EBS database to DB 23ai. 

MOS Note 2755875.1 , MOS Note 2758999.1

Ø Prepare your EBS Database: 

         In order to upgrade to DB 23ai, all EBS products you are running must be at the 12.2.7 release level or later. One step you can take now to get your EBS 12.2 environment ready for the upcoming certification with DB 23ai is to be on the EBS Error Correction Baseline or later. Our recommendation is that you update to the latest EBS 12.2 RUP which is currently 12.2.14.

i) Enabled Unified Auditing : Traditional auditing is desupported with Database 23ai, unified Auditing is enabled by default, for more details see MOS Note – 2777404.1

ii) Converts Case insensitive PDB Name : Case sensitive PDB names are desupported with EBS and Database 23ai for more details See MOS Note – 2782130.1

Additional Prerequisites for EBS R12.2 Database 23ai :

Ø Update to a future database upgrade code level for AD and TXK : AD and TXK are being enhanced with new features and for compatibility with Oracle Database 23ai.

Ø Apply the Interoperability Patche for EBS Product Compatibility with Oracle Database 23ai.

What's New for EBS with Oracle Database 23ai?

Ø Upgrading from DB 19c to DB 23ai is achieved using the Oracle Database AutoUpgrade utility.

Ø With the certification of Oracle Database 23ai, a new utility called Oracle E-Business Suite Database Parameter Checker (EDBPC) is now available. EDPBC can be run to confirm that you have correctly set your EBS DB 23ai or 19c database initialization parameters according to recommendations in Database Initialization Parameters for Oracle E-Business Suite Release 12 (MOS Note 396009.1). etc 

Note: The Database Upgrade Assistant (DBUA) used to upgrade EBS databases to Database 11gR2, 12cR1, and 19c is now desupported.

 Certified Platforms - On-Premises Exadata Database Machine (Exadata)

        This announcement applies to the certification of EBS 12.2 with DB 23ai for the on-premises Exadata Database Machine (Exadata) running Exadata Software version 24.1 (ExaOL8X) or later. All other on-premises platforms are pending certification.

Certified Database Features and Options::

This list includes items that have been explicitly certified by EBS development.

Ø Active Data Guard , Data Guard Using Logical Host Names

Ø Data Guard Using Physical Server Names 

Ø Data Masking using the EM 13cR5 Data Masking and Subsetting Pack and the EBS 12.2 Data Masking Template

Ø Database Network Access Control Lists 

Ø Database Vault using EBS_SYSTEM

Ø In Place Standby Upgrade

Ø Multitenant architecture (CDB architecture) with a single Pluggable Database (PDB) (single tenant)

Ø Oracle Real Application Clusters (Oracle RAC)

Ø Transparent Data Encryption (TDE) with Online Tablespace Encryption Conversion

Ø Unified Auditing

Supported Database Features and Options :::

     The Supported Database Features and Options list includes items that are supported but not explicitly certified by EBS. Our general policy is that the Oracle Database generic documentation applies to these features and options, even if we haven't certified them specifically.

Ø Advanced Compression

Ø Database In-Memory , Database Partitioning

Ø Native PL/SQL Compilation , Oracle Label Security (OLS)

Ø SecureFile , Virtual Private Database (VPD)*

Note: There are special considerations for EBS 12.2 and the required edition-based redefinition database feature. For VPD, refer to Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (MOS Note 1577661.1).

Pending Certifications - Database Features and Options::

       The Pending Certifications - Database Features and Options list includes items that require explicit certification and that we currently plan to certify in the future.

Ø Database Vault using EBS_SYSTEM

Ø Transportable Database for data migration processes

Ø Transportable Tablespaces for data migration processes

Certified Integrations ::

      The Certified Integrations list includes items that have been explicitly certified by EBS Development. 

Ø Oracle APEX

Ø Oracle Application Management Pack Release 13.5.1.0.0

Ø Oracle E-Business Suite Integrated SOA Gateway (ISG)

Ø Oracle E-Business Suite 12.2 with Database 23ai integrated with Oracle Access Manager 12c for single sign-on

Pending Certifications – Integrations:

       This list includes items that require explicit certification and that we currently plan to certify in the future.

Ø Oracle E-Business Suite Release 12.2 with Database 23ai integrated with GoldenGate 23ai on-premises for reporting

Note: If you are using GoldenGate to replicate your EBS database, you must upgrade to GoldenGate 23ai using the microservices architecture as part of your upgrade to DB 23ai.

Upgrading from Oracle Database 19c to 23ai on a Database Service - Reference methods 

     How you upgrade will depend on the cloud service you use to run your database as well as whether you have implemented Oracle Data Guard.

     To upgrade your EBS database on Oracle Base Database Service, follow the instructions in the appropriate My Oracle Support (MOS) document:

 Environments Without Data Guard ::

Ø Upgrading Oracle E-Business Suite Release 12.2 with Oracle Database 19c to 23ai on Oracle Base Database Service DB Systems (MOS Note 2999993.1).

Environments With Data Guard ::

Ø Upgrading Oracle E-Business Suite Release 12.2 with Oracle Database 19c to 23ai Using Existing Physical Standby on Oracle Base Database Service DB Systems (MOS Note 3020011.1)

To upgrade your EBS database on Oracle Exadata Database Service on Dedicated Infrastructure or Cloud@Customer, 

Environments without Data Guard ::

Ø Upgrading Oracle Database 19c to 23ai for Oracle E-Business Suite Release 12.2 with Oracle Exadata Database Service on Dedicated Infrastructure and Cloud@Customer (MOS Note 2999994.1).

Environments with Data Guard ::

Ø Upgrading Oracle E-Business Suite Release 12.2 with Oracle Database 19c to 23ai Using Existing Physical Standby on Oracle Exadata Database Service on Dedicated Infrastructure or Cloud@Customer (MOS Note 3020010.1)

Thanks,

Srini

Oracle Linux Commands (users , groups , Directory creation and Permissions grant ) - part 4/4

 Dear All,

 In this post i am going to share few of the oracle Linux commands.

Complete Linux high level commands, I have posted in 4 parts, this is Part 4/4.

check the previous parts details below.

part 1 : https://anjaniappsdba.blogspot.com/2023/09/oracle-linux-commands-part-14.html

part 2 : https://anjaniappsdba.blogspot.com/2024/02/oracle-linux-commands-part-24.html 

Part 3 : https://anjaniappsdba.blogspot.com/2024/11/oracle-linux-commands-awksed.html

User and groups Creation commands

===========================

#useradd username ( create new users )

Id username >> ( it will display the user id with groups )

#passwd username>>to create /rest the password

#userdel username>>delete the user

#useradd –g primary group username>> add primary group ( new user )

#useradd –G secondary group to username>> to add second group

#usermod –a –G groupname username>> to add existing user into this group ( existing user )

#useradd -g racsinfo new_user

#usermod -g racsinfo existing user  

#groupadd racsinfo

 

cat /etc/group

 

group_name : password : group-id : list-of-members

 

groupadd -g 1001 racsinfo

groupadd -f racsinfo

groupadd -p newpassword racsinfo ( put the password )

 

 

 

 

Disk Fragmentation commands

=============================

Df >> to display disk fragmentation

Df -h >>to display disk fragmentation in gb

Df –m >> to display disk fragmentation in mb

Df –h . >> to display the disk fragmentation in current directory

 

 

 

Directory commands

========================

 

mkdir directory name >> to create the directory.

Mkdir -p directory name >> to create the directory’s with in

directories.

Mkdir – p directory/directory {1..10} >> to create the directory in

directories

Rm –rf directory name>> it removes the directory without

confirmation

Rmdir directoryname >> it remove the directory

 

Permission commands

==========================

Chmod 755 file >> to be give the change file permissions.

Chmod u+x file >> to be give the users execution permissions

chmod g+x file >> to give the groups execution permissions

Chmod o+x file >> to give the others execution permissions

chown username:username filename >> to change the ower

permissions

chgrp username:username filename >> to change the group

permissions

 

PS Command

=================

Ps >> to display the process for running

Ps –ef :to display the all process for running

Ps –ef|grep httpd >> to check the httpd process is running or not

ps –ef|grep httpd >>to see the apache running or not

ps –ef|grep httpd|grep –v grep >>to see the apache running or not ad

not display grep output

kill -9 <pid> (Or) kill –TERM <PID> >> it kill the running process

forcebully

kill -3 <pid>>> it create the thread dump

 

 

*Min|*H|*Day|*M|*W :

#*****

Min>> 0-59

H >> 0-23

Day >> 1-31

Month>> 1-12

Week>>> 0-6

 

RWX . read : 4 , Write : 2 , Execute : 1 , No Access :0

4+2+1=7

User >>  xxx

Group >> xxx

Others >>  xxx

Thanks,

Srini