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