Oracle 监听lsnrctl命令启动报错(TNS-12537,TNS-12560,TNS-00507)
来源:互联网 发布:ubuntu 16.04 升级 编辑:程序博客网 时间:2024/06/14 07:31
LINUX登录oracle用户,通过lsnrctl start命令启动数据库时,报错如下:
“ [oracle@localhost ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-APR-2015
07:38:11Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr:
please wait…TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
Linux Error: 29: Illegal seek“`
原因:
/etc/hosts内有两个localhost的主机名,监听冲突。
解决方法:
1、修改其中一个主机名,比如oracle,执行以下命令。
hostname oracle
2、在/etc/hosts内修改一个主机名为oracle。
[root@oracle etc]# cat /etc/hosts
127.0.0.1 localhost
::1 oracle
3、在/etc/sysconfig/network修改主机名为oracle。
[root@oracle etc]# cat /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=oracle
4、重新启动,在oracle用户下执行lsnrctl start。
[oracle@oracle ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-APR-2015 07:46:27Copyright (c) 1991, 2009, Oracle. All rights reserved.Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionSystem parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraLog messages written to /home/oracle/app/diag/tnslsnr/oracle/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 29-APR-2015 07:46:29Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File /home/oracle/app/diag/tnslsnr/oracle/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))The listener supports no servicesThe command completed successfully
- Oracle 监听lsnrctl命令启动报错(TNS-12537,TNS-12560,TNS-00507)
- 启动oracle监听报错:TNS-12537 TNS-12560 TNS-00507 Linux Error
- TNS-12541,TNS-12560,TNS-00511,TNS-12542,TNS-12560,TNS-00512数据库启动监听报错
- Oracle 启动监听报错TNS-12547: TNS:lost contact
- oracle 启动监听报错TNS-12547: TNS:lost contact
- Oracle 监听 启动报错 tns-12560 tns-00530 linux error:20:not a directory 解决方法
- Oracle 监听 启动报错 tns-12560 tns-00530 linux error:20:not a directory 解决方法
- Oracle 监听器无法启动(TNS-12537,TNS-12560,TNS-00507)
- Oracle EBS系统数据库监听报错TNS-12547、TNS-12560和TNS-00517解决方法
- Oracle监听 报错TNS-12541: TNS: 无监听程序 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序
- 启动监听报错TNS-12547: TNS:lost contact
- 启动监听报错TNS-12547: TNS:lost contact
- TNS-12537, TNS-12560,TNS-00507 解决方法
- TNS-12537, TNS-12560, TNS-00507
- TNS-12537,TNS-12560,TNS-00507问题解决
- RAC启动监听报错:TNS-12555 TNS-12560 TNS-00525 Linux Error: 1: Operation not permitted
- Oracle 11Gr1监听报错TNS-12542 12560 00512
- Oracle监听启动失败“TNS-12541:TNS: No Listener”
- VBA第3课 常量与变量
- 點絳唇(林逋)
- equals 和 ==
- C++ 线段树—模板&总结
- Android 系统权限
- Oracle 监听lsnrctl命令启动报错(TNS-12537,TNS-12560,TNS-00507)
- C++使用memset时候注意
- linux 命令系列之 字符截取命令 cut(54)
- 在 SQL 中,视图是基于 SQL 语句的结果集的可视化的表
- 关于Android在线支付Alipay(支付宝)开发的经验分享
- 快速理解Linux下网络编程基础
- PHP中单引号和双引号的区别
- IAR for AVR设置生成HEX文件
- CPP 1373 Easy as A+B(冒泡排序)