Oracle Integration · Integration activation

Activation failure: ORA-12516 could not create pool connection

Short answer

ORA-12516 during an Oracle Integration activation means the activation hit database connection pool issues. Check that the database is running and has enough space.

VerifiedLast verified

01Error text

Oracle Integration error
Could not create pool connection for datasource 'SOALocalTxDataSource'.
ORA-12516, TNS:listener could not find available handler with matching protocol stack

02Likely causes

  • Connection pool issues, with the DBMS driver reporting that the listener refused the connection.

03How to fix it

  1. Check that the database is running and has enough space.
  2. If not, the database administrator must increase the database size limit or connection pool size.
  3. Retry the activation.

04Official documentation

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

More for Oracle Integration work:Open Oracle Integration jobsOracle Integration rates and salaries

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.