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

TNS-01112: Plug and play can either be ON or OFF

1 Answers  


ORA-27068: I/O buffer is not aligned properly

1 Answers  


QSM-02041: nested aggregate function

1 Answers  


ORA-16705: severe internal error in resource guard

1 Answers  


ORA-27199: skgfpst: sbtpcstatus returned error

1 Answers  






ORA-02310: exceeded maximum number of allowable columns in table

1 Answers  


ORA-28175: incorrect certificate type

1 Answers  


ORA-07613: $GETJPIW failed in retrieving the user's process label

1 Answers  


ORA-34361: (MXDSS12) number other user reading

1 Answers  


ORA-12010: cannot create materialized view log on table owned by SYS

1 Answers  


ORA-24095: invalid transformation, source type does not match that of the queue

1 Answers  


DRG-11215: index owner does not have access to filter stored procedure: string

1 Answers  


Categories