aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

TNS-01189: The listener could not authenticate the user

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.

请先 登录 后评论

1 个回答

小智
TNS-01189:侦听器无法验证用户,
.原因:用户尝试发出特权管理命令,但是侦听器无法使用本地操作系统身份验证机制成功进行身份验证。这可能是由于以下原因之一:,
.1.用户正在运行低于侦听器版本的LSNRCTL版本。,
.,
.2.用户尝试从远程节点管理侦听器。,
.,
.3.侦听器无法获得执行身份验证所需的系统资源。,
.,
.侦听器和LSNRCTL之间的本地网络连接在认证消息交换期间意外终止,例如,如果LSNRCTL程序突然中止。,
.,
.5.监听器和LSNRCTL之间的通信被恶意用户拦截。,
.,
.6.用户正在运行的软件不遵循认证协议,指示恶意用户。,
.,
.操作:确保使用等于或大于侦听器版本的LSNRCTL工具发出管理命令,并且该工具和侦听器在同一节点上运行。您可以发出VERSION命令来查找侦听器的版本。如果怀疑有恶意用户,请使用侦听器日志文件中提供的信息来确定请求的来源和性质。启用侦听器跟踪以获取更多信息。如果错误仍然存??在,请联系Oracle支持服务。,
.
请先 登录 后评论