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.
* (LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
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
