Oracle

Oracle is supported as a source database — the database LakeXpress extracts data from. It cannot be used as the LakeXpress DB.

Connection Parameters

Parameter	Required	Description
ds_type	Yes	Must be "oracle"
auth_mode	Yes	Must be "classic"
username	Yes	Oracle username
password	Yes	Oracle password
server	Yes	Hostname or IP
port	Yes	Port (default: 1521)
database	Yes	Service name or SID
lib_dir	No	Client library directory (thick mode)

Thin vs Thick Mode

Thin Mode (Recommended):

• No client libraries required
• Oracle 12.1+
• Omit lib_dir

Thick Mode:

• Required for Oracle 11.2 and earlier
• Requires Oracle Instant Client
• Set lib_dir to the Instant Client directory

Required Permissions

LakeXpress uses RowID-based parallel exports to read Oracle tables efficiently. The database user needs catalog access for metadata discovery (table structure, RowID ranges, and export method selection):

-- As Oracle DBA (e.g., sys as sysdba)
GRANT SELECT_CATALOG_ROLE TO your_username;

Example: Thin Mode

{
  "oracle_prod": {
    "ds_type": "oracle",
    "auth_mode": "classic",
    "info": {
      "username": "$env{LX_ORACLE_USER}",
      "password": "$env{LX_ORACLE_PASSWORD}",
      "server": "oracle-prod.company.com",
      "port": 1521,
      "database": "PRODPDB"
    }
  }
}

Example: Thick Mode

{
  "oracle_legacy": {
    "ds_type": "oracle",
    "auth_mode": "classic",
    "info": {
      "username": "$env{LX_ORACLE_USER}",
      "password": "$env{LX_ORACLE_PASSWORD}",
      "server": "oracle-11g.company.com",
      "port": 1521,
      "database": "LEGACY",
      "lib_dir": "/opt/oracle/instantclient_19_8"
    }
  }
}

Troubleshooting

ORA-12154: TNS could not resolve connect identifier: Verify service name, check tnsnames.ora, try IP instead of hostname, confirm listener is running.

ORA-28000: account is locked:

ALTER USER your_username ACCOUNT UNLOCK;

Thick mode library not found: Verify lib_dir path, confirm Instant Client is installed, check file permissions, set LD_LIBRARY_PATH on Linux.

See Also

• Database Connections Overview - Auth file format, security best practices