patternMinor
How does SQL*Plus connect to Oracle without a listener?
Viewed 0 times
withoutconnectsqllistenerplusdoeshoworacle
Problem
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.
Solution
As @BalazsPapp mentioned, the oracle db can be connected locally even without a listener. In this case, the BEQ (Bequeath) protocol is used, instead of the tcp-based normal oracle communication.
Although on Balazs's link there is nothing about the details of the BEQ. On unix, it probably uses unix domain sockets. On windows, it uses probably some local rpc.
Although on Balazs's link there is nothing about the details of the BEQ. On unix, it probably uses unix domain sockets. On windows, it uses probably some local rpc.
Context
StackExchange Database Administrators Q#62666, answer score: 2
Revisions (0)
No revisions yet.