Oracle Listener startup error-tns-12546:tns:permission Denied____oracle

Source: Internet
Author: User
Tags reserved snmp

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.

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.