SQL-02128: Sessions still exist, not logged off



SQL-02128: Sessions still exist, not logged off..

Answer / guest

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

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-00087: EXEC SQL TYPE statement not allowed for this host language

1 Answers  


EXP-00006: internal inconsistency error

1 Answers  


ORA-31157: Invalid Content-Type charset

1 Answers  


ORA-09979: skxfqhsnd: Error Sending a message to another endpoint

1 Answers  


RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade

1 Answers  






ORA-13263: column string in table string is not of type SDO_GEOMETRY

1 Answers  


ORA-07759: slemtr: invalid destination

1 Answers  


ORA-31039: XML namespace length string exceeds maximum string

1 Answers  


ORA-13480: the Source Type is not supported

1 Answers  


RMAN-08091: channel string: specifying datafile(s) for proxy backup

1 Answers  


ORA-22894: cannot add constraint on existing unscoped REF columns of non-empty tables

1 Answers  


ORA-32817: message system link string is not configured with a log queue for string

1 Answers  


Categories