How to fix the Oracle error SQL-02128: Sessions still exist, not logged off?

In this post, you’ll learn more about the Oracle ErrorSQL-02128: Sessions still exist, not logged off with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL-02128: Sessions still exist, not logged off

Reason for the Error SQL-02128: Sessions still exist, not logged off

Cause: A host was not removed (“logged off”) from SQLLIB because XA still has sessions associated with that host.

How to fix the Error SQL-02128: Sessions still exist, not logged off ?

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

Action: Before calling SQLXDH to drop a host, XA must either drop all sessions for that host or set the “doit_anyway” flag. *Note: This error *msg* is never actually used. The error *number* is used, given as a possible return value to the sqllib xa function sqlxdh.