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 这一句?
加上后,重新启动完成。