Workato · Oracle connector

Something went wrong when loading Oracle metadata

Short answer

"Something went wrong" while Workato loads Oracle metadata, with ORA-12516 in the logs, means the Oracle database is not accepting new connections. Ask your DBA to raise the processes and sessions limits and check the listener.

VerifiedLast verified

01Error text

Workato error
Something went wrong

oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack

02Likely causes

  • The Oracle database is not accepting new connections when Workato loads metadata.

03How to fix it

  1. Ask the DBA to increase the processes and sessions limits.
  2. Review listener.ora for the handler configuration.
  3. Restart the Oracle listener service.
  4. Reduce simultaneous connections or optimize connection reuse.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Workato work:Open Workato jobsWorkato rates and salariesHire a senior Workato developer

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.