DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, June 19, 2017

TNS-01189: The listener could not authenticate the user

Listener local os authentication parameter control the start or stop listener services through remotely.

Reference :
Doc ID 2009573.1 (Oracle Support)

APPLIES TO:
Oracle Database - Version 12.1.0.1.0 and later

Below is a example of the listener status
LSNRCTL> status ORCL
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     ORCL
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                21-APR-2017 23:17:26
Uptime                    58 days 16 hr. 56 min. 33 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/orcl/orcl/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  Services Summary...
Service "ORCL.oracle.com" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...
The command completed successfully

SOLUTION:

Turn off local os authentication by adding the following line to the listener.ora.

LOCAL_OS_AUTHENTICATION_<listener> = OFF

Now the listener status will be like below
LSNRCTL> status ORCL
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     ORCL
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                21-APR-2017 23:17:26
Uptime                    58 days 16 hr. 56 min. 33 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/orcl/orcl/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  Services Summary...
Service "ORCL.oracle.com" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...

The command completed successfully

No comments: