TNS-01189: The listener could not authenticate the user

Hi,

Sometimes You can get “TNS-01189: The listener could not authenticate the user ” error.

 

TNS-01189: The listener could not authenticate the user

Details of error are as follows.

TNS-01189: The listener could not authenticate the user

Cause: The user attempted to issue a privileged administrative command, but could not be successfully authenticated by the listener

using the local OS authentication mechanism. This may occur due to one of the following reasons:1. The user is running a version of LSNRCTL that is lower than the version of the listener.

2. The user is attempting to administer the listener from a remote node.

3. The listener could not obtain the system resources needed to perform the authentication.

4. The local network connection between the listener and LSNRCTL was terminated unexpectedly during authentication message exchange,

such as if LSNRCTL program was suddenly aborted.

5. The communication between the listener and LSNRCTL is being intercepted by a malicious user.

6. The software that the user is running is not following the authentication protocol, indicating a malicious user.


Action: Make sure that administrative commands are issued using the LSNRCTL tool that is of a version equal or greater than the

version of the listener, and that the tool and the listener are running on the same node. You can issue the VERSION command to

find out the version of the listener. If a malicious user is suspected, use the information provided in the listener log file

to determine the source and nature of the requests. Enable listener tracing for more information. If the error persists,

contact Oracle Support Services.


TNS-01189

This issue was caused by LOCAL_OS_AUTHENTICATION_LISTENER check if it is set LOCAL_OS_AUTHENTICATION_LISTENER as OFF  in the listener.ora under $ORACLE_HOME/network/admin.

 

LOCAL_OS_AUTHENTICATION_LISTENER =OFF


my listener ora is as follows.
LOCAL_OS_AUTHENTICATION_LISTENER =OFF
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.63.34)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

SID_LIST_LISTENER = 
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = MSDB)
(ORACLE_HOME = /u01/app/db_home_18c )
(SID_NAME = MSDB1 )
)
)

Or Backup listener.ora file and Configure the IPC in first place and reload the listener as follows.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.63.34)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)


 

Do you want to learn more details about RMAN, then read the following articles.

RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *