please create complete document installation and configuration DuckDB in Oracle Linux OS
1 Answer
1Hi @yusairi70! Welcome to the forum!
Here is a quick, complete guide to installing and configuring the DuckDB CLI on Oracle Linux (works for Oracle Linux 8 and 9).
Step 1: Install Required Tools
Open your terminal and ensure you have wget and unzip installed:
sudo dnf install -y wget unzip
Step 2: Download the DuckDB Binary
Download the latest 64-bit Linux CLI release directly from GitHub:
wget https://github.com/duckdb/duckdb/releases/latest/download/duckdb_cli-linux-amd64.zip
(If you are running on ARM/aarch64, replace amd64 with aarch64.)
Step 3: Extract and Install
Unzip the file and move the binary to your system path:
unzip duckdb_cli-linux-amd64.zip
sudo mv duckdb /usr/local/bin/
sudo chmod +x /usr/local/bin/duckdb
rm duckdb_cli-linux-amd64.zip
Step 4: Verify Installation
Check that DuckDB is working properly:
duckdb --version
To start an interactive session or create a database file:
# In-memory database
duckdb
# Persistent database
duckdb my_database.db
Step 5: Optional Configuration (~/.duckdbrc)
DuckDB loads default settings on startup from a .duckdbrc file in your home directory. You can create one to customize your experience:
cat << 'EOF' > ~/.duckdbrc
.prompt '🦆 > '
SET threads TO 4;
SET preserve_insertion_order = false;
EOF
(Optional) Python Integration
If you plan to use DuckDB with Python on Oracle Linux:
pip install duckdb
Would you like a sample query script to import CSV or Parquet files into your new DuckDB database? Just hit Reply! ![]()