TNS-01189: 监听程序无法验证用户
2025-05-19 09:04:30 阅读次数:2
用户,监听,验证
系统: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后,成功查看监听状态.
版权声明:本文内容来自第三方投稿或授权转载,原文地址:https://blog.51cto.com/u_12991611/5686961,作者:Liujun_Deng,版权归原作者所有。本网站转在其作品的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如因作品内容、版权等问题需要同本网站联系,请发邮件至ctyunbbs@chinatelecom.cn沟通。
上一篇:外设驱动库开发笔记54:外设库驱动设计改进的思考
下一篇:主库log_archive_dest_state_2为defer与enable的测试.