今天在linux搭建的IPV6環(huán)境下重新啟動(dòng)了一下oracle,在啟動(dòng)listener時(shí)得到如下的輸出:
LSNRCTL> start
Starting /oracle/11g/bin/tnslsnr: please wait
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /oracle/11g/network/admin/listener.ora
Log messages written to /oracle/diag/tnslsnr/node2/listener/alert/log.xml
Trace information written to /oracle/diag/tnslsnr/node2/listener/trace/ora_8028_3086591680.trc
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 06-JAN-2010 13:07:43
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level admin
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/11g/network/admin/listener.ora
Listener Log File /oracle/diag/tnslsnr/node2/listener/alert/log.xml
Listener Trace File /oracle/diag/tnslsnr/node2/listener/trace/ora_8028_3086591680.trc
Listening Endpoints Summary
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2)(PORT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node2)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
根據(jù)提示listener在start后,顯示啟動(dòng)成功,但是查看狀態(tài)時(shí)報(bào)錯(cuò),隨即分析了Listener的日志,并且將listener的trace level設(shè)定為了admin,也無(wú)法定位問(wèn)題。
隨后,在google進(jìn)行搜索,發(fā)現(xiàn)在linux下出現(xiàn)listener相關(guān)的問(wèn)題,有很大部分是和/etc/hosts的配置有關(guān),特別是其中一篇提到在/etc/hosts 中沒(méi)有設(shè)定 127.0.0.1,會(huì)產(chǎn)生錯(cuò)誤,的確在這個(gè)IPV6的環(huán)境中,已經(jīng)將127.0.0.1從/etc/hosts,替換為::1,在/etc/hosts恢復(fù)了127.0.0.1的配置,問(wèn)題解決。不知這個(gè)問(wèn)題是否oracle的一個(gè)缺陷?特別是啟動(dòng)的提示太有誤導(dǎo)了,一點(diǎn)提示都找不到