Basic tests with true cache on oracle database 26 ai

December 29, 2025 [email protected] Oracle AI Database 26ai, 0

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 to the PATH variable

export PATH=/home/oracle/.local/bin:/home/oracle/bin:/usr/share/Modules/bin: /usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/oracle/product/26ai/dbhomeFree/bin: /opt/sqldeveloper

Step 4. Run the demo schema scripts
After launching the sh_install.sql, only the tables for which the data is not in csv format are populated.

As  we can see, all the data provided in csv format, sales.csv, promotions.csv, customers.csv and costs.csv is not loaded

Step5.  Load the data using sqldeveloper

Step 6. Let’s proceed with the tests:

Oracle True Cache installation on database 26ai Oracle SQL Firewall in Oracle database 26 ai