今天照例開始學習oracle,例項啟動了，但是listener卻突然**了，怎麼都起不來。

我檢查了下listener配置，網路配置，ssh服務，一切都正常，最後看防火牆開著，關了以後，問題還是照舊。

[oracle@oel log]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 02-MAY-2013 12:11:38

sWelcome to LSNRCTL, type "help" for information.

LSNRCTL> tatus

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))

start

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

LSNRCTL> Starting /u01/app/ora10g/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /u01/app/ora10g/product/10.2.0/db_1/network/admin/listener.ora

Log messages written to /u01/app/ora10g/product/10.2.0/db_1/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521)))

Error listening on: (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))

TNS-12555: TNS:permission denied

TNS-12560: TNS:protocol adapter error

TNS-00525: Insufficient privilege for operation

Linux Error: 1: Operation not permitted

Listener failed to start. See the error message(s) above...

最後各處查詢，總算找到了問題根源。在 /var/tmp下的 .oracle許可權有問題

[root@oel tmp]# ll -a

total 24

drwxrwxrwt 4 root root 4096 May 2 12:10 .

drwxr-xr-x 24 root root 4096 Jun 16 2012 ..

drwxrwxrwt 2 root root 4096 May 2 12:11 .oracle

drwx------ 2 oracle dba 4096 May 1 12:36 yum-oracle-n3UNcY

[root@oel tmp]# cd .oracle

[root@oel .oracle]# ll

total 0

srwxrwxrwx 1 oracle dba 0 Apr 1 16:44 s#16480.1

srwxrwxrwx 1 oracle dba 0 Apr 1 16:44 s#16480.2

srwxrwxrwx 1 ora11g dba 0 Apr 21 16:59 s#2171.1

srwxrwxrwx 1 ora11g dba 0 Apr 21 16:59 s#2171.2

srwxrwxrwx 1 ora11g dba 0 Apr 21 16:59 sPNPKEY

[root@oel .oracle]#

改正一下，應該是上次啟動的時候用root來啟動，之後再用oracle使用者就啟動不了了。

[root@oel tmp]# chown oracle:dba .oracle

[root@oel tmp]# ll

total 4

drwx------ 2 oracle dba 4096 May 1 12:36 yum-oracle-n3UNcY

[root@oel tmp]# ll -a

total 24

drwxrwxrwt 4 root root 4096 May 2 12:10 .

drwxr-xr-x 24 root root 4096 Jun 16 2012 ..

drwxrwxrwt 2 oracle dba 4096 May 2 12:11 .oracle

drwx------ 2 oracle dba 4096 May 1 12:36 yum-oracle-n3UNcY

修改以後，再啟動一次試試。成功了。

LSNRCTL> status

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))

startTNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

LSNRCTL>

Starting /u01/app/ora10g/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /u01/app/ora10g/product/10.2.0/db_1/network/admin/listener.ora

Log messages written to /u01/app/ora10g/product/10.2.0/db_1/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 02-MAY-2013 12:15:07

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/ora10g/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/app/ora10g/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

Services Summary...

Service "CUST01" has 1 instance(s).

Instance "CUST01", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL>

關於listener無法啟動的問題解決

相關文章