LOCAL = NO: non-local connection, namely a network connection. Listener connect to the server. Client application through the client listener listener sends a request to the server, the server listens received in connection with the database, perform related operations, the results returned to the client. This is the process by listening. So you need to configure the client listener that is configured tnsnames.ora.

bash-3.00$ ps -ef grep 17480

oracle 17480 17479 0 03:02:03 ? 0:48 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
bash-3.00$ ps -ef grep 16789

oracle 16789 1 33 22:33 ? 00:00:54 oracleorcl (LOCAL=NO)

LOCAL = YES: local connection. The local connection does not go listening, local sqlplus so in the case of services the listener does not start, or can connect to the database.

Oracle server process initiated by a client tool/applicatoion local to the database host. Communication happens between client & the server via Bequeth protocol.

* oraclePROD (LOCAL=NO)
Oracle server process initiated by the Listener upon connection request from client tool/application.

In general, when LOCAL=YES, you have not used the listener to establish a connection (i.e. not used the tns alias in the connection string).

When LOCAL=NO, the connection was established via the listener.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.