Avatar photo

ny2honolulu

Oracle 21c XE + SQL Developer: Full Setup Summary

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.

 Complete Guide: Installing Oracle Database 21c XE on Debian with Docker

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.