暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

TNS-01189: 监听程序无法验证用户

原创 Leo 2022-09-18
1195

系统:Windows 10 专业版
数据库:oracle 11.2.0.4
问题描述:windows 10上搭建dg,主库系统为Linux,备库查看监听状态时报错TNS-01189,如下所示:
C:\Users\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 18-9月 -2022 00:41:04

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

正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.133.120)(PORT=1521)))
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.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcldg)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1\)
(SID_NAME = orcldg)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.135)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = D:\app\Administrator\

如上,将主库IP 192.168.133.120修改为备库IP 192.168.133.135后,成功查看监听状态.

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论