Category Database Administration

Connecting SQL Developer to Oracle 21c XE in Docker on Debian comes down to three fixes: use 127.0.0.1 instead of localhost (Debian's IPv6 causes TNS timeouts), connect with Service name XEPDB1 instead of SID xe (users live in the PDB, not the CDB root), and run ALTER SESSION SET CONTAINER = XEPDB1; before granting privileges. Clear SQL Developer's cached password after any DB-side reset, and the connection works end to end.

Struggling to install Oracle Database on Debian? Skip the complex manual installation and use Docker! This step-by-step guide walks you through installing Oracle Database 21c XE on Debian in under 5 minutes. Perfect for developers who need a local Oracle environment for testing, learning, or development. Includes troubleshooting tips, SQL*Plus commands, and a complete cheat sheet for daily use.