Error: 'ORA-08103 object no longer exists.' (NETIQKB30514)

fact
VigilEnt Password Manager for Oracle 5.0

fact
VigilEnt Password Manager for Oracle 6.x

fact
VigilEnt Security Agent for Oracle 1.x

symptom
Error: 'ORA-08103 object no longer exists.'

symptom
The Audit scanner process in VigilEnt Password Manager for Oracle is recording an error.

cause
The Audit scanner process in VigilEnt Password Manager for Oracle reads from several Oracle objects. Specifically, the "sys.aud$"(table), "sys.dba_users"(view) and "sqlcqr.sqlcqr_userdata"(table) within the Oracle database are read. If for any reason one of these objects became unavailable to the Audit scanner, this type of message could be expected. The Audit scanner process is an Oracle job, owned by the SQLCQR user.

fix

1. Verify that all three Oracle objects exist:
   
• sys.aud$
• sys.dba_users
• sqlcqr.sqlcqr_userdata
  
2. Ensure the "sys.aud$" has not been truncated while the "Audit" scanner process was running.

If either case is TRUE, that would be the cause of this Oracle error message.  For case 1, restore the object from backup if needed.  For case 2, make sure the "Audit" scanner process has completely finished before scheduling any Oracle database maintenance.

Formerly known as NETIQKB30514