Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

sqlplus can be used even if there is no listener in the system, or if it isn't running.

How does SQL*Plus connect to Oracle without a listener?

I can connect any user using SQL*plus even with no listener running.

share|improve this question

1 Answer 1

up vote -1 down vote accepted

You only bypass the listener when you connect as sysdba*. Ordinary connections through SQLPlus still use the listener. As for how it does it, there is a special mechanism for this kind of connection, which allows a database to be administered without a working listener. I do not believe that the workings of this mechanism are published by Oracle. They want you to use the listener.

Or as sysoper*. **And only if you don't specify a database in your connect string.

share|improve this answer
Sorry, but this is wrong. Any user can connect locally without a listener, through the BEQ (Bequeath) protocol. docs.oracle.com/cd/E11882_01/install.112/e27508/… –  Balazs Papp Apr 7 '14 at 17:12
Thanks. I learned something today. –  Andrew Brennan Apr 8 '14 at 9:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.