Hello all,
Using Oracle 18c:
I have a pl/sql code that implements DBMS_LDAP package.
The package has been working fine for several years but from time-to-time our LDAP host has changed.
Recently, I found out that I can still authenticate the LDAP users but when I try to call the PL/SQL code say 15 times, every 15th attempt gives me ORA-31203: DBMS_LDAP: PL/SQL - Init Failed error.
I am not sure if its every 15th attempt but the bottomline is that after certain number of successful attempts, I get this error. I can print out the error message to ensure that the dbms_ldap.init call has the correct hostname and port.
I do not exactly know since when this problem started. I can recreate this error from the SQL Developer.
So what is wrong with this sporadic behavior? Is there such thing as that the server is taking certain number of requests within a certain time period, or a limit on number of calls from the same user or same IP address within a time frame?
Or is something related to my database configuration?
How to start troubleshooting?
Thanks,
RN