经历共享

1.LINUX AS3 , 原有10G , 数据库,监听,都正常.
2.为了配置DATA GUARD,又装了9i. (选择9i也是迫不得已,另一台测试机内存只有128M)
3.配置完9i后,回到10G(没有重新安装,主要是.bash_profile的修改)
4.数据库启动正常.
5.监听出现如下问题

[oracle@ora1 oracle]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-APR-2007 08:37:52

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
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=ora1)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

查看监听文件:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora1)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = RVER/ora10/product/10.20.1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = heyf)
(ORACLE_HOME = RVER/ora10/product/10.20.1)
(SID_NAME = heyf)
)
)
没有什么可疑!

6.GOOGLE搜索关于:Linux Error: 111: Connection refused
虽有不少解决问题的办法,
比如:
add follow message to /etc/hosts :
127.0.0.1 localhost:locahostdomain localhost

权限设置

cd $ORACLE_HOME/bin
relink all
但对于我的机子都没有作用.

已是晚上23:00,暂且搞一段落.

7.次日,在sosdb QQ群,发送帮助.
8.SOMEBODY建议用NETCA重建LISTENER
9.到服务器前,用ORACLE登陆, 重新配置LISTENER,问题解决.
10.虽然问题解决,但还是不知道导致这个问题的真正原因.
11.如果条件限制,不能到服务器前用netca,该如何处理?
12.最后感谢网络,感谢SOSDB成员给予的帮助.