TNS-01189: 监听程序无法验证用户
系统: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后,成功查看监听状态.
版权声明
本文仅代表作者观点,不代表博信信息网立场。
上一篇:centos怎么删除php 下一篇:详解centos之find命令