How to fix the Oracle error ORA-24422: error occurred while trying to destroy the Session Pool?

In this post, you’ll learn more about the Oracle ErrorORA-24422: error occurred while trying to destroy the Session Pool with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-24422: error occurred while trying to destroy the Session Pool

Reason for the Error ORA-24422: error occurred while trying to destroy the Session Pool

An attempt was made to destroy the session pool while some sessions in the pool were busy.

How to fix the Error ORA-24422: error occurred while trying to destroy the Session Pool ?

You can fix this error in Oracle by following the below steps

Ensure that no sessions from the pool are being used OR call OCISessionPoolDestroy with mode set to OCI_SPD_FORCE.