Today, a database server is not logged on, reported Tns-12541:tns:no listener
Look at the listener status on the server
oracle@linux-34:~> lsnrctl status
lsnrctl for linux:version 11.1.0.6.0-production on 14-oct-2011 09:12:37
C Opyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (Description= (address= (protocol=tcp) (Host=linux-34.site) (port=1521))
Tns-12541:tns:no Listener
Tns-12560:tns:protocol Adapter Error
Tns-00511:no Listener
Linux Error:111:connection refused connecting to (description= (address=
) (key=extproc1521)))
Tns-12541:tns:no Listener
Tns-12560:tns:protocol Adapter error
Tns-00511:no listener
Linux error:111 : Connection refused
Start the next try.
oracle@linux-34:~> lsnrctl start
lsnrctl for linux:version 11.1.0.6.0-production on 14-oct-2011 09:12:45
Co Pyright (c) 1991, 2007, Oracle. All rights reserved.
Starting/home/oracle/product/11.1.0/db_1/bin/tnslsnr:please wait ...
Tnslsnr for linux:version 11.1.0.6.0-production
System parameter file is/home/oracle/product/11.1.0/db_1/network /admin/listener.ora
Log messages written To/home/oracle/diag/tnslsnr/linux-34/listener/alert/log.xml
Error listening on: (Address= (PROTOCOL=IPC) (Partial=yes) (queuesize=1))
No. longer on: (Listening ( Address= (PROTOCOL=TCP) (Host=linux-34.site) (port=1521))
Tns-12546:tns:permission denied Tns-12560:tns
:p Rotocol Adapter Error
tns-00516:permission denied
Linux Error:13:permission denied Listener failed
To start. The error message (s) above ...
Even reported Tns-12546:tns:permission denied
View the permissions access for the next/var/tmp/.oracle,/tmp/.oracle, and both directories.
linux-34:~ # ls-lrtd/tmp/.oracle
drwxrwxrwx 2 root 4096 May 9 16:01/tmp/.oracle linux-34:~
# LS-LRTD /var/tmp/.oracle
drwxr-xr-x 2 root 4096 Oct 09:45/var/tmp/.oracle
More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/
The reason should be right here,/var/tmp/.oracle is 755 permissions, modify it to 777.
Chmod-r 777/var/tmp/.oracle
Then start listening and try again.
oracle@linux-34:~> lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 14-OCT-2011 09:45:04
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /home/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /home/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/diag/tnslsnr/linux-34/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-34.site)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux-34.site)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 14-OCT-2011 09:45:04
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/diag/tnslsnr/linux-34/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-34.site)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
oracle@linux-34:~> lsnrctl status
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 14-OCT-2011 09:46:02
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux-34.site)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 14-OCT-2011 09:45:04
Uptime 0 days 0 hr. 0 min. 58 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/diag/tnslsnr/linux-34/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-34.site)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orarpt" has 1 instance(s).
Instance "orarpt", status READY, has 1 handler(s) for this service...
Service "orarpt_XPT" has 1 instance(s).
Instance "orarpt", status READY, has 1 handler(s) for this service...
The command completed successfully
Solve the problem.
This article is from "Richard's notes-accumulate micro Cheng" blog, please be sure to keep this source http://zxf261.blog.51cto.com/701797/722304