今天一台数据库服务器登录不上，报TNS-12541: TNS:no listener
到服务器上看下监听器状态
oracle@linux-34:~>lsnrctlstatus LSNRCTLforLinux:Version11.1.0.6.0-Productionon14-OCT-09:12:37 Copyright(c)1991,,Oracle.Allrightsreserved. Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux-34.site)(PORT=1521))) TNS-12541:TNS:nolistener TNS-12560:TNS:protocoladaptererror TNS-00511:Nolistener LinuxError:111:Connectionrefused Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541:TNS:nolistener TNS-12560:TNS:protocoladaptererror TNS-00511:Nolistener LinuxError:111:Connectionrefused
启动下试试
oracle@linux-34:~>lsnrctlstart LSNRCTLforLinux:Version11.1.0.6.0-Productionon14-OCT-09:12:45 Copyright(c)1991,,Oracle.Allrightsreserved. Starting/home/oracle/product/11.1.0/db_1/bin/tnslsnr:pleasewait... TNSLSNRforLinux:Version11.1.0.6.0-Production Systemparameterfileis/home/oracle/product/11.1.0/db_1/network/admin/listener.ora Logmessageswrittento/home/oracle/diag/tnslsnr/linux-34/listener/alert/log.xml Errorlisteningon:(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1)) Nolongerlisteningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-34.site)(PORT=1521))) TNS-12546:TNS:permissiondenied TNS-12560:TNS:protocoladaptererror TNS-00516:Permissiondenied LinuxError:13:Permissiondenied Listenerfailedtostart.Seetheerrormessage(s)above...
竟然报TNS-12546: TNS:permission denied
查看下 /var/tmp/.oracle、/tmp/.oracle 这两个目录的权限访问。
linux-34:~#ls-lrtd/tmp/.oracle drwxrwxrwx2rootroot4096May916:01/tmp/.oracle linux-34:~#ls-lrtd/var/tmp/.oracle drwxr-xr-x2rootroot4096Oct1409:45/var/tmp/.oracle
原因应该就在这了，/var/tmp/.oracle是755权限，把它修改为777。
chmod-R777/var/tmp/.oracle
然后再启动监听试试。
oracle@linux-34:~>lsnrctlstart LSNRCTLforLinux:Version11.1.0.6.0-Productionon14-OCT-09:45:04 Copyright(c)1991,,Oracle.Allrightsreserved. Starting/home/oracle/product/11.1.0/db_1/bin/tnslsnr:pleasewait... TNSLSNRforLinux:Version11.1.0.6.0-Production Systemparameterfileis/home/oracle/product/11.1.0/db_1/network/admin/listener.ora Logmessageswrittento/home/oracle/diag/tnslsnr/linux-34/listener/alert/log.xml Listeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-34.site)(PORT=1521))) Listeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux-34.site)(PORT=1521))) STATUSoftheLISTENER ------------------------ AliasLISTENER VersionTNSLSNRforLinux:Version11.1.0.6.0-Production StartDate14-OCT-09:45:04 Uptime0days0hr.0min.0sec TraceLeveloffSecurityON:LocalOSAuthentication SNMPOFFListenerParameterFile/home/oracle/product/11.1.0/db_1/network/admin/listener.ora ListenerLogFile/home/oracle/diag/tnslsnr/linux-34/listener/alert/log.xml ListeningEndpointsSummary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-34.site)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Thelistenersupportsnoservices Thecommandcompletedsuccessfully oracle@linux-34:~>lsnrctlstatus LSNRCTLforLinux:Version11.1.0.6.0-Productionon14-OCT-09:46:02 Copyright(c)1991,,Oracle.Allrightsreserved. Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux-34.site)(PORT=1521))) STATUSoftheLISTENER ------------------------ AliasLISTENER VersionTNSLSNRforLinux:Version11.1.0.6.0-Production StartDate14-OCT-09:45:04 Uptime0days0hr.0min.58sec TraceLeveloffSecurityON:LocalOSAuthentication SNMPOFFListenerParameterFile/home/oracle/product/11.1.0/db_1/network/admin/listener.ora ListenerLogFile/home/oracle/diag/tnslsnr/linux-34/listener/alert/log.xml ListeningEndpointsSummary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-34.site)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) ServicesSummary... Service"orarpt"has1instance(s). Instance"orarpt",statusREADY,has1handler(s)forthisservice... Service"orarpt_XPT"has1instance(s). Instance"orarpt",statusREADY,has1handler(s)forthisservice... Thecommandcompletedsuccessfully
问题解决。
