My Oracle Support Banner

UNIX: ORA-12537 or ORA-12546 or ORA-12547 when connecting to the Database via the Listener (Doc ID 1050756.6)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Net Services - Version 8.1.7.0 to 12.2.0.1 [Release 8.1.7 to 12.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 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 (BEQUEATH) connections work fine but a connection via the Listener fails with ORA-12537 or ORA-12547

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

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

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

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


Or

TNS-12518: TNS:listener could not hand off client connection
  TNS-12547: TNS:lost contact
   TNS-12560: TNS:protocol adapter error
    TNS-00517: Lost contact
     IBM/AIX RISC System/6000 Error: 32: Broken pipe

 

Changes

 This is likely a new installation. 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.