thanks for responding.
I checked your links but the first link deals with wrong ACL Settings and the second link is about setting up group authorization correctly.
In our environment
- custom Login is set up and working (also ACL)
- group authorization is set up and working
Maybe the Problem is that we call AD 6 times on page 101:
1. apex_authentication.login (custom auth) - 2 calls to DBMS_LDAP.INIT
2. get custom Attribute
3. get Location Attribute
4. get full Name Attribute
5. get role (membeOf)
Eventually calling the AD this often could trigger the problem, although it feels like a bug and not a traceable error.
The real Problem was:
ORA-31223: DBMS_LDAP: cannot open more than 63 LDAP server connections
If you encounter this problem make sure that dbms_ldap_unbind_s is called in all cases before your custom ldap functions returns any value.
When debugging in SQL Developer you probably don't use the APEX_05000 Schema but your application owner.
This user will still be able to open up new LDAP Server Connections. It seems ist not a db instance Limit but a user Limit.
Every DB User will be able to open up 63 Connections.