Oracle 23c free FAQ

Docker/Podman

通过docker pull container-registry.oracle.com/database/free:latest，直接从Oracle Container Registry拉取容器映像。

Oracle Linux 8

运行 dnf install -y oracle-database-free*

运行 /etc/init.d/oracle-free-23c configure

RedHat 兼容的 Oracle Linux 8 发行版

运行 dnf install -y oracle-database-preinstall*
运行 dnf install -y oracle-database-free*

运行 /etc/init.d/oracle-free-23c configure

连接到 Oracle Database Free

SQL
    连接字符串格式：[username]@[hostname]:[port]/[DB service name] [AS SYSDBA]
    要连接到每一个 Pluggable Database (PDB)，请使用：
    sqlplus sys@localhost:1521/FREEPDB1 as sysdba
    要连接到 Container Database (CDB)，请使用：
    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)
      }
}

相关产品

Oracle APEX 在哪里？

发行版中不再包含 Oracle APEX。您可以在此处下载最新版本，按照 Oracle APEX 文档中的说明安装最新版本的 Oracle APEX。

SQL Developer 和 SQLcl 在哪里？

SQL Developer 和 SQLcl 不属于 Oracle Database Free 的一部分。您可以另外下载最新版本的 SQL Developer 或 SQLcl 。

发行版中是否包括 Oracle REST Data Services (ORDS)？

不包括，请点击此处了解如何使用 ORDS 和 Oracle Database Free 进行 RESTful 应用开发并支持 Oracle APEX。

Reference

https://www.oracle.com/cn/database/free/faq/

https://blogs.oracle.com/database/post/oracle-database-23c-free

https://download.oracle.com/otn_software/virtualbox/dd/Oracle_Database_23c_Free_Developer_Appliance.ova

https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm