当前位置:数据库 > Oracle >>

oracle error:Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...解决

oracle error:Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...解决
 
首先说下环境吧:redhat 6.3,oracle11g;
 
本来设置的是oracle开机自动启动,谁知道开机后使用ps -ef | grep oracle 有进程,但是程序连接不了oracle;几经调试,才搞定。
 
1.首先使用 strace lsnrctl start 跟踪命令运行:
 
确定是和上面参考一样的问题时,修改/var/tmp/.oracle文件夹的权限用户为oracle;
 
2.重新启动,还是起不来
 
[plain] 
lsnrctl status  
  
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-JUN-2013 16:33:36  
  
Copyright (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 refused  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fansyPC)(PORT=1521)))  
TNS-12541: TNS:no listener  
 TNS-12560: TNS:protocol adapter error  
  TNS-00511: No listener  
   Linux Error: 111: Connection refused  
 
3.然后直接google   Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... 网上说可能是/etc/hosts问题
 
我的hosts  是  192.168.0.10 fansyPC 没有问题,但是需要  127.0.0.1 localhost  这一句?
 
加上后,重新启动完成。
 
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,