Tag Archives: Listener parameter

Disable the OS authentication in Listener Oracle

Disable the OS authentication in Listener Oracle

Oracle listener is securing listener by using Local OS authentication.
Local OS authentication means you are working on user account in machine which the listener is running and configured.
(means user is the owner of Oracle while installation)

Check listener Status to See OS authentication is on or off

lsnrctl status

C:\oracle>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 19-APR-2018 02:10:32
Copyright (c) 1991, 2017, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.85)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 18-APR-2018 13:05:31
Uptime 0 days 13 hr. 5 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF

Disable Local OS Authentication

Go to the Location %ORACLE_HOME%\network\admin and add a new parameter in Listener.ora File

local_os_authentication_=off

In my case, i am having default listerner name, so used LISTENER
local_os_authentication_LISTENER=off