From “No Listener” to “Connected to an Idle Instance”: My Oracle Lab on Debian

What began as a simple Oracle version check became a hands-on Debian troubleshooting lesson. I traced a false port conflict, hostname trouble, permission errors, and missing directories until SQL*Plus finally connected to an idle instance—with database creation still ahead.

