Connect to an Oracle database without using a TNS receiver

Question

Just out of curiosity, a few days ago we discussed whether there is a way to connect to the database without using the TNS Listener, the connection should be performed by any SQLPlus program. Net, ODBC, etc.

Answer 1

Basically, only local connections can avoid the listener (i.e. you should already be registered on the computer on which the database instance is running).

Instead of relying on the listener to deploy the process to act on behalf of the connection, this is done by the local process. Typically, this means that the local user should be run as an "oracle." An example of equivalent console logic.

Answer 2

There doesn't seem to be a single magic bullet, but there are several ways.

For ODBC, see this SO question.

There's a lot of good stuff at Connectionstrings.com/oracle .

Answer 3

You connect to Oracle through a client, such as sqplplus, or a java program (or tool) that uses a protocol, such as SQL * NET or JDBC (as examples) through a listener. The listener, in turn, starts the process in the target database (or assigns a connection to the existing process if you use shared servers).