Today, a database server is not logged on, reported Tns-12541:tns:no listener
Look at the listener status on the server
1. oracle@linux-34:~> lsnrctl Status
2.
3. Lsnrctl for linux:version 11.1.0.6.0-production on 14-oct-2011 09:12:37
4.
5. Copyright (c) 1991, 2007, Oracle. All rights reserved.
6.
7. Connecting to (description= address= (protocol=tcp) (Host=linux-34.site) (port=1521))
8. Tns-12541:tns:no Listener
9. Tns-12560:tns:protocol Adapter Error
Tns-00511:no Listener
Linux Error:111:connection refused
Connecting to (description= address= (PROTOCOL=IPC) (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.
1. oracle@linux-34:~> Lsnrctl Start
2.
3. Lsnrctl for linux:version 11.1.0.6.0-production on 14-oct-2011 09:12:45
4.
5. Copyright (c) 1991, 2007, Oracle. All rights reserved.
6.
7. Starting/home/oracle/product/11.1.0/db_1/bin/tnslsnr:please Wait ...
8.
9. 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))
Longer listening on: (Description= (Address= (protocol=tcp) (Host=linux-34.site) (port=1521))
Tns-12546:tns:permission denied
Tns-12560:tns:protocol Adapter Error
Tns-00516:permission denied
Linux Error:13:permission denied
18.
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.
1. linux-34:~ # Ls-lrtd/tmp/.oracle
2. drwxrwxrwx 2 root root 4096 May 9 16:01/tmp/.oracle
3.
4. linux-34:~ # Ls-lrtd/var/tmp/.oracle
5. drwxr-xr-x 2 root root 4096 Oct 09:45/var/tmp/.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.
1. oracle@linux-34:~> Lsnrctl Start
2.
3. Lsnrctl for linux:version 11.1.0.6.0-production on 14-oct-2011 09:45:04
4.
5. Copyright (c) 1991, 2007, Oracle. All rights reserved.
6.
7. Starting/home/oracle/product/11.1.0/db_1/bin/tnslsnr:please Wait ...
8.
9. 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))
14.
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
33.
Lsnrctl for linux:version 11.1.0.6.0-production on 14-oct-2011 09:46:02
35.
Copyright (c) 1991, 2007, Oracle. All rights reserved.
37.
Connecting to (description= address= (protocol=tcp) (Host=linux-34.site) (port=1521))
The 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. 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 the This service ...
Service "ORARPT_XPT" has 1 instance (s).
Instance "Orarpt", Status READY, has 1 handler (s) for the This service ...
The command completed successfully
Solve the problem.