DBMS_LDAP_UTL .GET_GROUP_MEMBERSHIP Fails With ORA-07445 [gslcoex_get_direct_group_membership_with_filter()+256] (Doc ID 1457923.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

Customer is having problems with the following (after upgrading to 11gR1 from 10gR1):

In Oracle 11g R1,
dbms_ldap_utl.get_group_membership (l_session, l_user_handle, dbms_ldap_utl.nested_membership, l_attrs, l_pset_coll)
fails whereas
dbms_ldap_utl.get_group_membership (l_session, l_user_handle, dbms_ldap_utl.direct_membership, l_attrs, l_pset_coll)
runs regularly.

    Possible English Version for you :)
        ORA-03113: End-of-file communication channel
        Operation No: 348
        Session No: 203 Serial Number: 42599

Alert.log shows:

ORA-07445: [gslcoex_get_direct_group_membership_with_filter()+256] [SIGSEGV] [ADDR:0x0] [PC:0x10831CFE0]

Ran the following inside SQL plus, and the following message has been prompted: 

SQL> declare

 2    l_result   varchar2(300);
 3  begin
 4    l_result :=  tfs_asb.api_wgr_roles.getLDAPRoles('T07925');
 5  end;
 6  /
 l_result   varchar2(300);
*
ERROR at line 2:
ORA-03113: end-of-file on communication channel
Process ID: 4143
Session ID: 136 Serial number: 99

ORA-07445: [gslcoex_get_direct_group_membership_with_filter()+256] [SIGSEGV] [ADDR:0x0] [PC:0x10831CFE0]

Additionally, all of them run regularly in Oracle 10g R1.

Changes

 upgraded to 11gR1 from 10gR1

Cause

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