ORA-12537 While Connecting To Database Via Listener

ORA-12537 While Connecting To Database Via Listener

Connection to the database server fails with ORA-12537

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

[oracle@myhost]$ sqlplus myuser/mypass@mytns

SQL*Plus: Release 11.1.0.7.0 – Production on Fri Apr 30 21:32:18 2010

ERROR:
ORA-12537: TNS:connection closed

The listener log for the failing connection shows following error message –

TNS-12518: TNS:listener could not hand off client connection
TNS-12546: TNS:permission denied
   TNS-12560: TNS:protocol adapter error
    TNS-00516: Permission denied
      Linux Error: 13: Permission denied

Permissions on oracle binary ( $ORACLE_HOME/bin/oracle ) would not have set correctly.

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 should 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

Reference Metalink Note :1050756.6

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.