Please let me know if anyone has experienced below kind of issue in real time execution of adapter services.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Socket read timed out
Issue is happening intermittantly
What is the minimum/maximum connection setting you set on your adapter connection that having problems with?
Also make sure the target db is accessible all times (check if there are any intermittent network outages for that DB connectivity)
Please check this Empower article and decide on the next steps in your env: