Oracle AI Database Free – Quick Start

Experience the next generation of database innovation with Oracle AI Database 26ai. Designed to simplify development for AI, microservices, graph, document, spatial, and relational applications, this converged database platform offers everything you need in one powerful solution. Even better, you can jump right in at no cost—Oracle AI Database 26ai Free is available for anyone who wants to get started building modern, data-driven applications. Whether you choose our commercial product in the cloud or on-premises (see availability list) or opt for the free edition, you’ll have all the tools you need to create the future of data management.

Oracle AI Database 26ai Free Platforms

DownloadDetails

Pull container images from Oracle’s Container Registry:

docker pull container-registry.oracle.com/database/free:latest

oracle-ai-database-free-26ai-23.26.4-1.el8.x86_64.rpm

1,528,894,184 bytes

SHA256 2d8e6e9e1a8b65b1f7f77295db4856a81262f9e77efe235ee3edd3f714e1bae1

Oracle Linux 8 (OL8) and Red Hat Enterprise Linux (RHEL8) use the same main RPM.

RHEL8 requires an additional preinstall download and installation:

dnf install -y oracle-ai-database-preinstall*

oracle-ai-database-free-26ai-23.26.4-1.el9.x86_64.rpm

1,528,894,184 bytes

SHA256 6da5c76237f8034849da36cd8e8d5f51d750b7ae7ee89248979f29a0ed504b8b

Oracle Linux 9 (OL9) and Red Hat Enterprise Linux (RHEL9) use the same main RPM.

RHEL9 requires an additional preinstall download and installation:

dnf install -y oracle-ai-database-preinstall*

oracle-ai-database-free-26ai-23.26.4-1.el10.x86_64.rpm

1,528,894,184 bytes

SHA256 d8981e388a00e16daed4fdadf9418af4fa6605908df4c71746a7c2d2bd07fce4

Oracle Linux 10 (OL10) and Red Hat Enterprise Linux (RHEL10) use the same main RPM.

RHEL10 requires an additional preinstall download and installation:

dnf install -y oracle-ai-database-preinstall*

oracle-ai-database-free-26ai-23.26.4-1.el9.aarch64.rpm

1,342,794,812 bytes

SHA256 a4701f00bbe9a6f9813961558f2d4b1409209f06c770cd04d9535d689b826bf6

OL9 for Arm requires an additional preinstall download and installation:

dnf install -y oracle-ai-database-preinstall*

oracle-ai-database-free-26ai-23.26.4-1.el8.aarch64.rpm

1,342,794,812 bytes

SHA256 6dd4fee54fb37e998877a55b92955ac20a568fda9d6e5e58cf2b01450e03675b

OL8 for Arm requires an additional preinstall download and installation:

dnf install -y oracle-ai-database-preinstall*

oracle-ai-database-free-26ai-23.26.4.windows.x64.zip

1,401,811,861 bytes

SHA256 7088ad2ef6c34c85c697f20babefea8a5f5cc3369b5b83b5165b981335ce29a7

Connecting to Oracle AI Database Free

SQLcl

Connect string format: [username]@[hostname]:[port]/[DB service name] [AS SYSDBA]

To connect to the first Pluggable Database (PDB) use:

sql sys@localhost:1521/FREEPDB1 as sysdba

To connect to the Container Database (CDB) use:

sql sys@localhost:1521/FREE as sysdba

SQL*Plus

Connect string format: [username]@[hostname]:[port]/[DB service name] [AS SYSDBA]

To connect to the first Pluggable Database (PDB) use:

sqlplus sys@localhost:1521/FREEPDB1 as sysdba

To connect to the Container Database (CDB) use:

sqlplus sys@localhost:1521/FREE as sysdba

Java

OracleDataSource ods = new OracleDataSource(); ods.setURL("jdbc:oracle:thin:@localhost:1521/FREEPDB1"); // jdbc:oracle:thin@[hostname]:[port]/[DB service name] ods.setUser("[Username]"); ods.setPassword("[Password]"); Connection conn = ods.getConnection(); PreparedStatement stmt = conn.prepareStatement("SELECT 'Hello World!' FROM dual"); ResultSet rslt = stmt.executeQuery(); while (rslt.next()) { System.out.println(rslt.getString(1)); }

Python

import oracledb


conn = oracledb.connect(user="[Username]", password="[Password]", dsn="localhost:1521/FREEPDB1")
with conn.cursor() as cur:
   cur.execute("SELECT 'Hello World!' FROM dual")
   res = cur.fetchall()
   print(res)

Node.js

const oracledb = require('oracledb');async function run() { let connection = await oracledb.getConnection({ user : "[Username]", password : "[Password]", connectString : "localhost:1521/FREEPDB1" // [hostname]:[port]/[DB service name] }); let result = await connection.execute( "SELECT 'Hello World!' FROM dual"); console.log(result.rows[0]); } run();

C#/.NET

// Connection string format: User Id=[username];Password=[password];Data Source=[hostname]:[port]/[DB service name]; OracleConnection con = new OracleConnection("User Id=[Username];Password=[Password];Data Source=localhost:1521/FREEPDB1;"); con.Open(); OracleCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT \'Hello World!\' FROM dual"; OracleDataReader reader = cmd.ExecuteReader(); reader.Read(); Console.WriteLine(reader.GetString(0));

PHP

// [username], [password], [hostname]:[port]/[DB service name] $c = oci_pconnect("[Username]", "[Password]", "localhost:1521/FREEPDB1"); $s = oci_parse($c, "SELECT 'Hello World!' FROM dual"); oci_execute($s); oci_fetch_all($s, $res); echo "<pre>\n" var_dump($res); echo "</pre>\n";

Ruby

require 'oci8' con = OCI8.new("[Username]", "[Password]", "localhost:1521/FREEPDB1") statement = "SELECT 'Hello World!' FROM dual" cursor = con.parse(statement) cursor.exec cursor.fetch do |row| print row end

Go

package main

     
import (
      "fmt"
      "log"
      "database/sql"
      _ "github.com/godror/godror"
)
     
func main() {  
     
      // connectString format: [hostname]:[port]/[DB service name]
     
      dsn := `user="[Username]"
              password="[Password]"
              connectString="localhost:1521/FREEPDB1"`  
     
      db, err := sql.Open("godror", dsn)
      if err != nil {
        panic(err)
      }
      defer db.Close()
     
      rows, err := db.Query("SELECT 'Hello World!' FROM dual")
      if err != nil {
        panic(err)
      }
      defer rows.Close()
     
      var strVal string
      for rows.Next() {
        err := rows.Scan(&strVal)
        if err != nil {
          log.Fatal(err)
        }
        fmt.Println(strVal)
      }
      err = rows.Err()
      if err != nil {
        log.Fatal(err)
      }
     
}