1. TNS-00525: insufficient privilege for operation
Started with pid=30869Listening 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 not permittedNo longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora11g)(PORT=1521)))2014-07-10 14:17:16.811000 +08:00System parameter file is /u01/app/11.2.0/grid/network/admin/listener.oraLog messages written to /u01/app/grid/diag/tnslsnr/ora11g/listener/alert/log.xmlTrace information written to /u01/app/grid/diag/tnslsnr/ora11g/listener/trace/ora_30888_47191985552112.trcTrace level is currently 0
Check whether the group of the/tmp/. Oracle and/var/tmp/. Oracle folders is correct. If not, change to chown-r grid: oinstall
2. Connection error ORA-12537: TNS: Connection closed when the above 2 directory permissions are correct
[[email protected] admin]$ tnsping 192.168.0.164/iscTNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 10-JUL-2014 14:20:44Copyright (c) 1997, 2011, Oracle. All rights reserved.Used parameter files:/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.oraUsed HOSTNAME adapter to resolve the aliasAttempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=isc))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.164)(PORT=1521)))OK (0 msec)[[email protected] admin]$ sqlplus isc/[email protected]192.168.0.164/iscSQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 10 14:21:09 2014Copyright (c) 1982, 2011, Oracle. All rights reserved.ERROR:ORA-12537: TNS:connection closedEnter user-name:
Tnsping is normal, listening is normal, but the connection reports an error ora-12537.
Check that the $ ORACLE_HOME/bin/Oracle permission should be 6751
[[email protected] admin]$ ls -la $ORACLE_HOME/bin/oracle-rwxr-s--x 1 oracle asmadmin 232399473 Nov 11 2013 /u01/app/oracle/product/11.2.0/db_1/bin/oracle[[email protected] admin]$ chmod 6751 $ORACLE_HOME/bin/oracle[[email protected] admin]$ ls -la $ORACLE_HOME/bin/oracle-rwsr-s--x 1 oracle asmadmin 232399473 Nov 11 2013 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
Official explanation:
Applies:
Oracle Net Services-version: 8.1.7.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 listener was not able to hand off the connection to Oracle processes or not able to spawn a new dedicated user process because 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 shocould be 777 with sticky bit set.
# Chmod 01777/var/tmp/. Oracle
2. check and correct permissions on $ ORACLE_HOME/bin/Oracle binary and make sure that it is set to 6751.
$ Chmod 6751 $ ORACLE_HOME/bin/Oracle