Oracle setup

Install the Oracle Instant Client

Tablething connects to Oracle through Oracle's Instant Client libraries. Install them separately, then restart Tablething.

macOS

Homebrew is the easiest way to install the client, though the default instantclient-basiclite formula ships the Intel build, which an Apple Silicon app can't load. If you're on Apple Silicon, reach for the -arm64- formula instead. You can tell which Mac you have by running uname -m, where arm64 means Apple Silicon and x86_64 means Intel.

1. Install via the InstantClientTap

brew tap InstantClientTap/instantclient

# Homebrew 6+ requires trusting third-party taps first
brew trust instantclienttap/instantclient

# Apple Silicon (M1/M2/M3/M4):
brew install instantclient-arm64-basiclite

# Intel:
brew install instantclient-basiclite

2. Link the libraries into ~/lib

macOS searches ~/lib by default, so linking the libraries there works whether you launch Tablething from the terminal or from Finder. It's worth avoiding DYLD_LIBRARY_PATH, since macOS strips it from apps opened through Finder.

mkdir -p ~/lib

# Match the formula you installed (drop -arm64 on Intel)
PREFIX=$(brew --prefix instantclient-arm64-basiclite)

ln -sf "$PREFIX"/lib/libclntsh*.dylib* ~/lib/
ln -sf "$PREFIX"/lib/libclntshcore*.dylib* ~/lib/
ln -sf "$PREFIX"/lib/libnnz*.dylib ~/lib/
ln -sf "$PREFIX"/lib/libociei.dylib ~/lib/

Once that's done, quit and reopen Tablething.

Manual download (no Homebrew)

Download Basic Light for Apple Silicon or Intel, unzip it somewhere permanent, then link the libraries into ~/lib:

mkdir -p ~/lib
IC=/opt/oracle/instantclient_23_3   # where you unzipped

ln -sf "$IC"/libclntsh*.dylib* ~/lib/
ln -sf "$IC"/libclntshcore*.dylib* ~/lib/
ln -sf "$IC"/libnnz*.dylib ~/lib/
ln -sf "$IC"/libociei.dylib ~/lib/

Linux

Download the Basic Light ZIP for x86-64, install libaio, then register the path.

sudo apt-get install -y libaio1   # or: sudo dnf install libaio

sudo mkdir -p /opt/oracle
sudo unzip instantclient-basiclite-linux.x64-*.zip -d /opt/oracle

echo /opt/oracle/instantclient_23_3 | sudo tee /etc/ld.so.conf.d/oracle-instantclient.conf
sudo ldconfig

Windows

Download the Basic Light ZIP for x64 and unzip it somewhere permanent, such as C:\oracle\instantclient_23_3.

Add that folder to your system PATH (Settings → Environment Variables), then restart Tablething.

If Tablething still can't load the client, install the Visual C++ Redistributable.

Troubleshooting

A DPI-1047 error, or "Instant Client libraries were not found," means the loader can't find the libraries. If tests keep failing:

On macOS, match the architecture to your CPU: file ~/lib/libclntsh.dylib should report arm64 on Apple Silicon. If it says x86_64, reinstall the -arm64- formula.
Confirm the install path matches what you linked or registered.
Quit and restart Tablething so the loader picks up the libraries.

Oracle distributes the Instant Client under its own license. See the downloads page for packages and licensing.