Sql*Plus Hangs 0r Crashes using LDAP Authenticated OS Accounts (Doc ID 736509.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 and later
SQL*Plus - Version 9.2.0.8 and later
Linux x86
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on SPARC (32-bit)
Intel Based Server LINUX


Symptoms

LDAP OS users within the same UNIX shell environment and UNIX groups are created.

OS accounts are NOT the Oracle software owner. 
There is no firewall in place.

SQL*Plus uses LDAP to connect.

Error encountered is.

Under Korn shell: "memory fault".
Under Bash shell: "Segmentation fault".

Tnsping works
==========
$ tnsping dimen2_prod
TNS Ping Utility for Linux: Version 9.2.0.8.0 - Production on 26-JUN-2008 17:48:17
Copyright (c) 1997, 2006, Oracle Corporation. All rights reserved.
Used parameter files:
ORACLE_HOME/sqlnet/admin/sqlnet.ora
Used ONAMES adapter to resolve the alias :
Attempting to contact (DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=
(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME= SID)))
OK (0 msec)

SQL*Plus crashes
============
$ sqlplus username@connect_string

SQL*Plus: Release 9.2.0.8.0 - Production on Thu Jun 26 17:48:26 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Memory fault

Output of strace shows these futex function calls.
@ munmap(0x200019e3000, 4096) = 0
@ getuid() = 13410
@ futex(0x200019499b8, FUTEX_WAIT, 2, NULL <unfinished ...>

Cause

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 hundreds of Community platforms