TNS-01189 错误,即“监听程序无法验证用户”,通常与 Oracle 数据库的监听配置有关。这个错误可能由多种原因引起,以下是一些解决此问题的步骤: 1. 确认 TNS-01189 错误信息的上下文和含义 TNS-01189 错误表明监听程序在尝试验证用户时失败了。这通常发生在尝试使用 lsnrctl 工具管理监听程序时。 2. 检查监听程序的配...
TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=leo)(PORT=1521))) TNS-01189: The listener could not authenticate the user 通过ps命令未见监听进程: [grid@dbserver ~]$ ps -ef|gr...
TNS-01189: The listener could not authenticate the user 查看监听进程：可能导致问题的原因：1、/etc...
TNS-01189: The listener could not authenticate the user 原因,本机器是克隆而来,修改了ip地址之后,没有修改对应的hosts文件 # ifconfig eth1 Link encap:Ethernet HWaddr00:50:56:A0:72:9A inet addr:10.11.12.190Bcast:10.11.12.255Mask:255.255.255.0inet6 addr: fe80::250:56ff:fea0:729a/64Scope:Li...
TNS-01189: 监听程序无法验证用户 异常原因:从主库拷贝过来的监听文件HOST未修改为备库IP. # listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. ...
TNS-01189: 监听程序无法验证用户 异常原因:从主库拷贝过来的监听文件HOST未修改为备库IP. # listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. ...
TNS-01189: The listener could not authenticate the user -- 这个问题基本2个原因导致, 1, /etc/hosts 文件中的 ip和主机名不一致 2, listener.ora 中监听主机非当前主机. listener.ora的位置在:/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin 目录 ...
通常造成TNS-01189有以下两个原因: a、/etc/hosts文件中IP与主机名不一致 b、listener.ora文件中监听主机并非当前主机 解决方案: 查看hosts、listener.ora文件. [grid@dbserver~]$ cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4localhost4.localdomain4 ...
[oracle@c6f97bbf42fb~]$ lsnrctl statusLSNRCTLforLinux:Version11.2.0.4.0-Productionon09-APR-202017:02:15Copyright(c)1991,2013,Oracle.Allrights reserved.Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.23.1.100)(PORT=1521)))TNS-01189:Thelistener couldnotauthenticate the user[oracle@c6f...
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: The user is ...