Welcome to Salem Houali ‘s Oracle Developer Notes

Oracle AI Database 26ai

Oracle SQL Firewall in Oracle database 26 ai

About Oracle AI Database 26ai. Oracle AI Database 26ai is the next long-term support release of Oracle AI Database. It includes over 300 new features with a focus on artificial intelligence (AI) and developer productivity. Ref. oracle documentation  About Oracle SQL Firewall With Oracle SQL Firewall, you are protected in real-time against common database attacks. […]

Basic tests with true cache on oracle database 26 ai

In this article, I’ll continue with some basic tests following my previous post orale-true-cache-installation-on-database-26ai Thanks to Ulrike Schwinn To complete the demo, we need to go through the following steps: Step 1.  we need to download the following packages: db-sample-schemas-23.3.zip sqldeveloper-24.3.1-347.1826.noarch.rpm jdk-17.0.17_linux-x64_bin.rpm Download jdk-17.0.17_linux-x64_bin.rpm Step 2.  install jdk-17.0.17_linux-x64_bin.rpm & qldeveloper-24.3.1-347.1826.noarch.rpm install jdk-17.0.17_linux-x64_bin.rpm Step 3. add /opt/sqldeveloper […]

Oracle True Cache installation on database 26ai

Configure true Cache on Oracle AI Database Free Ref. Oracle documentation About Oracle True Cache True Cache is an in-memory, read-only cache in front of an Oracle AI Database. Like Oracle Active Data Guard, True Cache is a fully functional, read-only replica of the primary database, except that it’s mostly diskless. Unlike conventional caches, True Cache […]

Graph Server, User Authentication and Authorization for Database Authentication

In this demo, we will first  install and configure the graph server for reverences, refer to oracle documentation    You can run Oracle Graph Server  in standalone mode or using a webserver like Oracle WebLogic Server or Apache Tomcat. The installation steps for installing Oracle Graph Server in standalone mode are as shown:As a root […]

Graph database : Oracle Graph Server and Client Installation

Introduction: Graph databases, part of Oracle’s converged database offering, eliminate the need to set up a separate database and move data.  Graphs enable you to find connections and explore relationships in your data. Analysts and developers can perform fraud detection in banking, find connections and link to data, and improve traceability in smart manufacturing, all […]

install and Configure Apache on Linux

Introduction Apache HTTP Server, commonly known as Apache, is one of the most popular web server software in the world due to its powerful features, extensive documentation, and active community support. In this comprehensive guide, we will walk through the steps of installing and configuring Apache on a Linux system. There are several ways to […]

Oracle Database 23ai installation notes on linux64-bits

Oracle Database 23ai installation notes Introduction Oracle Database 23ai represents a transformative leap in enterprise database technology, fundamentally changing how organizations approach data management, artificial intelligence integration, and application development. s the latest long-term support release of Oracle’s flagship database platform, this revolutionary system introduces over 300 groundbreaking features specifically designed to bring artificial intelligence […]