Oracle Listener startup Error-tns-12546:tns:permission denied

Source: Internet
Author: User
Tags date min reserved snmp linux


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


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.