Disable the OS authentication in Listener Oracle

Leave a reply

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

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

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