The solution is:
Enter both the Oracle user password and the ASM password in the same Password field/tab, separated by a comma. This needs to be updated either in the Secrets Manager or directly in the Endpoint.
For example: Oracle123,ASM123