listener TNS-01189 问题
来源:互联网 发布:问道手游辅助软件 编辑:程序博客网 时间:2024/06/06 12:51
-- 启动监听,提示已经启动.
[oracle@sh ~]$ lsnrctl start
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-FEB-2017 15:30:14
Copyright (c) 1991, 2014, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
-- 通过ps 命令没有发现 监听的进程
[root@sh ~]# ps -ef | grep -i tns
root 36 2 0 Jan26 ? 00:00:00 [netns]
root 14995 14824 0 15:30 pts/1 00:00:00 grep -i tns
-- 查看监听状态,报错; TNS-01189
[oracle@sh ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-FEB-2017 15:57:39
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wh)(PORT=1521)))
TNS-01189: The listener could not authenticate the user
-- 这个问题基本2个原因导致,
1, /etc/hosts 文件中的 ip和主机名不一致
2, listener.ora 中监听主机非当前主机.
通过检查, 是 listener.ora 监听主机填写错误错误
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sh)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
修改为当前主机名后,重启监听恢复正常.
- listener TNS-01189 问题
- 【监听问题】TNS-12541 TNS : no listener
- TNS-12541: TNS:no listener
- TNS-12541: TNS:no listener
- TNS-12541: TNS:no listener
- TNS-12541:TNS: No Listener
- ubuntu下oracle问题 ORA-12541: TNS:no listener
- TNS-00511: No listener
- TNS-01189: The listener could not authenticate the user
- TNS-01189 The listener could not authenticate the user
- TNS-01189 The listener could not authenticate the user
- TNS-01189: The listener could not authenticate the user
- tnsping报TNS-12541: TNS:no listener
- ORA-12541:TNS:no listener
- ORA-12541:TNS:no listener
- ORA-12541: TNS:no listener
- ORA-12541:TNS:no listener
- ORA-12541: TNS:no listener
- tomcat配置,通过域名访问指定项目
- shiro整合springmvc
- [转]如何更改AD域安全策略-密码必须符合复杂性要求
- jQuery学习总结
- CDH集群迁移
- listener TNS-01189 问题
- Codeforces Beta Round #11 D. A Simple Task(状压DP)
- 1069. The Black Hole of Numbers (20)
- (转)android Activity runOnUiThread() 方法使用
- linux权限问题
- nginx 安装、配置、参数介绍
- BZOJ 1007, 水平可见直线
- MYSQL的八大缺陷
- Sublime Text 3鼠标选中时背景色的修改方法