首页 / ORACLE / oracle 监听启动错误
oracle 监听启动错误
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了oracle 监听启动错误，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含6316字，纯文字阅读大概需要10分钟。
内容图文
上午启动应用连接测试数据库的时候一直显示连接已满,然后上网查需要修改数据库最大连接数SQL> alter system set processes=1000 scope=spfile;
然后重启数据库,但是
1234567891011121314151617181920212223 | ? /Users/huangrupeng >ssh root@172.31.201.155root@172.31.201.155's password:Last login: Fri Jul 15 10:52:39 2016 from 172.31.131.154[root@localhost ~]# sqlplus-bash: sqlplus: command not found[root@localhost ~]# su - oracle[oracle@localhost ~]$ sqlplusSQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 15 10:55:07 2016Copyright (c) 1982, 2009, Oracle. All rights reserved.Enter user-name: exit[oracle@localhost ~]$ export ORACLE_SID=bdcor2[oracle@localhost ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 15 10:55:25 2016Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn /as sysdbaERROR:ORA-00020: maximum number of processes (500) exceeded |
但是进入sqlplus也没法连接到数据库,我想直接kill -9 pid,没搞定
12345 | [oracle@localhost ~]$ ps -ef|grep oracleroot 941 882 0 10:55 pts/2 00:00:00 su - oracleoracle 942 941 0 10:55 pts/2 00:00:00 -bashoracle 3425 942 0 10:59 pts/2 00:00:00 ps -eforacle 3426 942 0 10:59 pts/2 00:00:00 grep oracle |
索性直接reboot了,重启完之后,正常启动数据库,但是监听却启动不了了
123456789101112131415161718192021222324252627282930313233343536 | [oracle@localhost ~]$ export ORACLE_SID=bdcor2[oracle@localhost ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 15 11:33:05 2016Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn /as sysdbaConnected.SQL> select instance_name from v$instance;INSTANCE_NAME----------------bdcor2SQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@localhost ~]$ lsnlsnodes lsnrctl lsnrctl0[oracle@localhost ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-JUL-2016 11:33:44Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refusedConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=T 大专栏 oracle 监听启动错误CP)(HOST=localhost.localdomain)(PORT=1521)))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused |
按照网上找的,修改hostname, /etc/hosts, /etc/sysconfig/network,然后重启,果然启动了
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253 | [oracle@localhost ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_l/network/admin/listener.ora samples/ shrept.lst sqlnet.ora tnsnames.oraroot@localhost oracle][root@localhost oracle]# hostnameoracle[root@localhost oracle]# vim /etc/hosts[root@localhost oracle]# vim /etc/sysconfig/network[root@localhost oracle]# source /etc/sysconfig/network[root@oracle ~]# cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 localhost localhost.domain::1 localhost6.localdomain6 localhost6172.31.201.155 oracle[root@oracle ~]# cat /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=yesHOSTNAME=oracle[root@oracle ~]# hostnameoracle[root@localhost oracle]# su - oracle[oracle@oracle ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-JUL-2016 12:26:30Copyright (c) 1991, 2009, Oracle. All rights reserved.Starting /u01/app/oracle/product/11.2.0/dbhome_l/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionSystem parameter file is /u01/app/oracle/product/11.2.0/dbhome_l/network/admin/listener.oraLog messages written to /u01/app/oracle/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 15-JUL-2016 12:26:32Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_l/network/admin/listener.oraListener Log File /u01/app/oracle/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 |
但是,此时我在本地telnet oracle服务器的1521端口却不通,而且防火墙是关着的,但是服务器的1521端口已经是启动的
123456789 | [root@oracle ~]# netstat -apn|grep 1521tcp 0 0 127.0.0.1:1521 0.0.0.0:* LISTEN 6428/tnslsnrtcp 0 0 127.0.0.1:12746 127.0.0.1:1521 ESTABLISHED 4580/ora_pmon_bdcortcp 0 0 127.0.0.1:12761 127.0.0.1:1521 ESTABLISHED 4419/ora_pmon_orcltcp 0 0 127.0.0.1:1521 127.0.0.1:12746 ESTABLISHED 6428/tnslsnrtcp 0 0 127.0.0.1:1521 127.0.0.1:12761 ESTABLISHED 6428/tnslsnrunix 2 [ ACC ] STREAM LISTENING 23791 6428/tnslsnr /var/tmp/.oracle/sEXTPROC1521[root@oracle ~]# service iptables status防火墙已停 |
我找到oracle的监听文件,将HOST = localhost 修改为 HOST = oracle,重启监听,问题得到了解决
1234567891011121314 | [root@oracle ~]# cd /u01/app/oracle/product/11.2.0/dbhome_l/network/admin/[root@oracle admin]# cat listener.ora# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_l/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521)) ) )ADR_BASE_LISTENER = /u01/app/oracle |
内容总结
以上是互联网集市为您收集整理的oracle 监听启动错误全部内容，希望文章能够帮你解决oracle 监听启动错误所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】