学堂 学堂 学堂公众号手机端

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

lewis 5年前 (2020-12-12) 阅读数 5 #技术
系统: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后,成功查看监听状态.

版权声明

本文仅代表作者观点,不代表博信信息网立场。

热门