QSA-20391 ORA-20777 during internal SQL (os errno 0) (34056)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

QSA-20391 ORA-20777 during internal SQL (os errno 0)
Description

Space Manager aborts a reorg with the errors QSA-20391 ORA-20777 during internal SQL (os errno 0), and in the log is found "Trigger Oracle error is ORA-4016"
Cause

QSA is trying to query a sequence that it has created.

Oracle bug 2217015 returns this error for a newly created sequence if SMON is busy when you query the sequence.
Resolution

This is an Oracle bug (number 2217015 ) which is found in databse version 8.1.7. Contact Oracle Support for infomation regarding a fix.

Feedback submitted.

Was this article helpful?

[Select Rating]

Title