Connect to Oracle database without using TNS Listener

oracle listener tns
Ricardo Cardona Ramirez picture Ricardo Cardona Ramirez · Dec 5, 2010 · Viewed 11.4k times · Source

Just out of curiosity, a few days ago we had a discussion about whether there is a way to connect to the DB without using TNS Listener, the connection must be made by any program SQLPlus. Net, ODBC, and so on.

Answer

Gary Myers picture Gary Myers · Dec 5, 2010

Basically only local connections can avoid the listener (ie you have to be already logged on to the machine that the database instance is running on).

Rather than relying on a listener to fork out a process to act on behalf of the connection, this is done by the local process. Generally it means that the local user needs to be run as 'oracle' as well. Sort of equivalent to a console logic.

Related questions

ORA-12505 :TNS listener does not currently know of SID given in connect descriptor

I am using Oracle database. I've written a small JDBC connection program in Java but I am facing an issue with the listener. import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import …

Read More
Connection Error:Oracle.DataAccess.Client.OracleException ORA-12170

This has taken many hours of mine. I have to get this .Net app to run on an XP system. Someone seems to have messed up some files so conn.Open() in the C# is causing this error: Connection Error:…

Read More
Oracle client ORA-12541: TNS:no listener

I am new on Oracle database, but I have one issue. On my Database server (server1) listener and database instance run correctly and I can use sqlplus to connect to this DB. When I connect to database by using other …

Read More