Listen for error tns-00525:insufficient privilege for operation 11GR2 + connection error ora-12537:tns:connection closed

Source: Internet
Author: User
Tags bit set chmod

1.tns-00525:insufficient Privilege for operation

Started with pid=30869
listening on: (Description= (Address= (protocol=tcp) (host=ora11g) (port=1521))
Error Listening on: (Description= (Address= (PROTOCOL=IPC) (key=extproc1521))
Tns-12555:tns:permission denied
 Tns-12560:tns:protocol Adapter Error
  tns-00525:insufficient privilege for Operation
   Linux Error:1: Operation N OT permitted
No longer listening on: (Description= (Address= (protocol=tcp) (host=ora11g) (port=1521
)) 2014-07-10 14:17:16.811000 +08:00
System parameter file Is/u01/app/11.2.0/grid/network/admin/listener.ora
Log messages Written To/u01/app/grid/diag/tnslsnr/ora11g/listener/alert/log.xml
Trace information written to/ U01/APP/GRID/DIAG/TNSLSNR/ORA11G/LISTENER/TRACE/ORA_30888_47191985552112.TRC
trace level is currently 0

Check that the group of 2 folders for/tmp/.oracle and/var/tmp/.oracle are correct, and if not, change to Chown-r Grid:oinstall

2. To ensure that the above 2 directory permissions are correct, the connection error ora-12537:tns:connection closed

[oracle@ora11g admin]$ tnsping 192.168.0.164/isc

TNS Ping Utility for linux:version 11.2.0.3.0-production on 10-JUL -2014 14:20:44

Copyright (c) 1997, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora

Used HOSTNAME Adapter to Resolve the alias
attempting to Contacts (description= connect_data= (Service_name=isc)) (Address= (PROTOCOL=TCP) ( host=192.168.0.164) (port=1521))
OK (0 msec)
[oracle@ora11g admin]$

Sqlplus Sql*plus:release 11.2.0.3.0 Production on Thu June 14:21:09 2014

Copyright (c) 1982, Oracle.  All rights reserved.

ERROR:
ora-12537:tns:connection closed

Tnsping Normal, listening state is normal, but the connection error ora-12537.

The permission to check $oracle_home/bin/oracle should be 6751

[oracle@ora11g admin]$ ls-la $ORACLE _home/bin/oracle
-rwxr-s--x 1 Oracle asmadmin 232399473 Nov one  2013/u01/app /oracle/product/11.2.0/db_1/bin/oracle
[oracle@ora11g admin]$ chmod 6751 $ORACLE _home/bin/oracle
[ oracle@ora11g admin]$ ls-la $ORACLE _home/bin/oracle
-rwsr-s--x 1 ORACLE asmadmin 232399473 Nov one  2013/u01/app/ Oracle/product/11.2.0/db_1/bin/oracle

The official explanation:

Applies To:
Oracle Net services-version:8.1.7.0 to 11.2.0.1-release:8.1.7 to 11.2
Generic UNIX
Checked for relevance on 30-apr-2010
Symptoms
Connection to the database server fails with ORA-12546 or ORA-12537

Local connections working fine but the connection via listener fails with ORA-12537 or ORA-12547

Cause
Permissions on Oracle binary ($ORACLE _home/bin/oracle) are not set correctly.

Solution
The OS level error message in the Listener log "Linux Error:13:permission denied" indicates that the LI Stener wasn't able to hand off the connection to Oracle processes or not able to spawn a new dedicated user process Becau SE of lack of permission at the OS level. To resolve the error-

1. Check and correct the permission On/var/tmp/.oracle directory. Permissions on this directory should is 777 with sticky bit set.
# chmod 01777/var/tmp/.oracle

2. Check and correct permissions on $ORACLE _home/bin/oracle binary and make sure this it is set to 6751.
$ chmod 6751 $ORACLE _home/bin/oracle

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.