Tuesday, June 9, 2020


Tns-01189:the listener could not authenticate the user



$ lsnrctl stat 

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-AUG-2015 01:47:42

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testdb)(PORT=1521)))
TNS-01189: The listener could not authenticate the user
Reason, the machine is cloned, modified the IP address, did not modify the corresponding Hosts file
# ifconfig
eth1      Link encap:Ethernet  HWaddr 00:50:56:A0:72:9A  
          inet addr:10.11.12.190  Bcast:10.11.12.255  Mask:255.255.255.0
          inet6 addr: fe80::250:56ff:fea0:729a/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:195745 errors:0 dropped:0 overruns:0 frame:0
          TX packets:101000 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:295931844 (282.2 MiB)  TX bytes:6260200 (5.9 MiB)
          
# more /etc/hosts
10.11.12.180    testdb
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
Modification Method:
Modifying the Host Configuration
# more /etc/hosts
10.11.12.190    testdb
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

No comments:

Post a Comment

  RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time https://shivanandarao-oracle.com/2012/12/05/rman-20207-until-time-or-re...