I am not sure I have the full story - apologies.
In ORDS 25.1 only, I am seeing ORDS_PLSQL_GATEWAY database user locked regularly - everyday.
I see FAILED logins - but think these relate to user (me) activity
unified_audit_trail WHERE action_name = 'LOGON' AND return_code != 0
Normal service is resume if I unlock the account.
I have not reset its password ( do I need to ? )
I believe / suspect ORDS connects as ORDS_PUBLIC_USER and proxies into ORDS_PLSQL_GATEWAY.
25.1 seems to have different setup
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/25.1/ordig/setting-up-a-PL-SQL-Gateway-user.html#GUID-C6D9AD0F-8329-4BB2-A878-D346CEC2222F
But I don't understand implications ( e.g. If you want the database pool to serve the PL/SQL gateway requests directly … - no idea, do I ?) - I just performed same installation steps as 24.2.
I also need to unlock ORDS_PUBLIC_USER & APEX database user account - not sure if that is related problem or not.
so I am looking for help identifying why user is getting locked and what I need to do to prevent it, and trying to determine if issue is specific to this user / version of ORDS or generic.