0

I am having this problem "Warning: odbc_connect(): SQL error: [Oracle][ODBC][Ora]ORA-02002: error while writing to audit trail ORA-55917: Table flush I/O failed for log ID: 1 bucket ID: 0 ORA-01691: unable to extend lob segment AUDSYS.SYS_LOB0000081269C00014$$ by 128 in tablespace SYSAUX ORA-02002: error while writing to audit trail ORA-55917: Table flush I/O failed for log ID: 1 bucket ID: 0 ORA-01691: unable to extend lob segment AUDSYS.SYS_LOB0000081269C00014$$ by 128 in tablespace SYSAUX , SQL state S1000 in SQLConnect in..." is there any known solutions?

0

ORA-01691: unable to extend lob segment AUDSYS.SYS_LOB0000081269C00014$$ by 128 in tablespace SYSAUX

The SYSAUX tablespace is full.

Because the Audit system can't record what you're up to, it won't let you do anything.

Most immediately, you need [to get your DBA's] to extend the SYSAUX tablespace so that the Audit system has somewhere to write to.

Then [they need to] dig through the Documentation about how to move the Audit Trail data out of the SYSAUX tablespace and into somewhere [slightly] more manageable.

Then [they need to] dig even deeper to figure out how to get rid of the Audit trail data that you no longer want (which is probably the vast majority of it!).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for?Browse other questions tagged or ask your own question.