Wednesday, October 21, 2020

TNS-01189: The listener could not authenticate the user

 This happened to me when I cloned a VM.


[oracle@serpentcustom logs]$ lsnrctl status


LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 21-OCT-2020 20:19:59


Copyright (c) 1991, 2019, Oracle.  All rights reserved.


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=serpentcustom.ecp.priv)(                                                                             PORT=1521)))

TNS-01189: The listener could not authenticate the user



SOLUTION:

[oracle@serpentcustom admin]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
10.131.128.78 serpentcustomclone.ecp.priv serpentcustomclone

edit your listener.ora  to the correct host
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = serpentcustomclone.ecp.priv)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

No comments:

Post a Comment