oracle服务器无法连接,报错TNS:tns:lost contact
来源:互联网 发布:coap协议默认的端口号 编辑:程序博客网 时间:2024/04/30 19:31
监听器 The listener supports no services 问题解决方法
ORACLE版本:11gR2
开启监听器,远程连接报错:
ORA-12514: TNS:linstener does not currently know of service requested in connect descriptor
解决问题思路:
查看监听器状态,关闭后重新启动监听器
[oracle@rhel5 admin]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-AUG-2012 19:20:55
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/rhel5/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.210)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.210)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 14-AUG-2012 19:20:55
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/rhel5/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.210)(PORT=1521)))
The listener supports no services
The command completed successfully
结果发现错误信息:The listener supports no services
查看数据库service_name
sys@ORCL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl
手工注册有时能够解决问题:
sys@ORCL> alter system register;
System altered.
查看监听器状态:
[oracle@rhel5 admin]$ lsnrctl start
注册成功:
[oracle@rhel5 admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-AUG-2012 20:23:26
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rhel5.oraclelinux.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 14-AUG-2012 20:22:49
Uptime 0 days 0 hr. 0 min. 36 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/rhel5/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel5.oraclelinux.com)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
注册依然失败:
[oracle@rhel5 admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-AUG-2012 20:18:02
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rhel5.oraclelinux.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 14-AUG-2012 20:17:45
Uptime 0 days 0 hr. 0 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/rhel5/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel5.oraclelinux.com)(PORT=1521)))
The listener supports no services
The command completed successfully
依然有错误信息:The listener supports no services
重建监听器:
问题依旧
查看LISTENER内容:
[oracle@rhel5 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rhel5.oraclelinux.com)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
在LISTENER里添加内容:
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
#BEQUEATH CONFIG
(GLOBAL_DBNAME=orcl)
(SID_NAME=orcl)
(ORACLE_HOME=/u01/app/oracle/product/11.2)
#PRESPAWN CONFIG
(PRESPAWN_MAX=20)
(PRESPAWN_LIST=
(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
)
)
)
重启监听器,问题解决。
- oracle服务器无法连接,报错TNS:tns:lost contact
- Oracle 启动监听报错TNS-12547: TNS:lost contact
- oracle 启动监听报错TNS-12547: TNS:lost contact
- 启动监听报错TNS-12547: TNS:lost contact
- 启动监听报错TNS-12547: TNS:lost contact
- sqlplus登录报错TNS-12547: TNS:lost contact
- Linux环境下使用sqlplus登录Oracle,报'ORA-12547: TNS:lost contact’丢失连接错误
- TNS-12547: TNS:lost contact
- TNS-12547: TNS:lost contact
- Oracle dbca时报错:ORA-12547: TNS:lost contact
- TNS-12547: TNS:lost contact 错误解决
- TNS-12547: TNS:lost contact解决办法
- TNS-12547: TNS:lost contact 错误解决
- TNS-12547: TNS:lost contact解决办法
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- Android 常用工具类源码大全
- 导出pem证书给服务端Push Notification使用
- strong,weak, retain, assign的区别
- 再回首,数据结构——字符串与数组的常见操作(顺序存储)
- BFS和A*算法分别解决N-数码问题
- oracle服务器无法连接,报错TNS:tns:lost contact
- IE下 iframe子页面document.documentElement报错问题(未指明的错误。)
- Android 各大网络请求库的比较及实战
- poj 2316 SPIN
- IOS开发之获取Storyboard创建的ViewController
- 用matlab 保存带标记图像、图片的方法总结
- 孩子玩叛逆,家长不如以退为进
- Java并发工具包java.util.concurrent用户指南
- 再回首,数据结构——字符串与数组的常见操作(链式存储,包含朴素匹配算法等)