Return
-
Title
"Internal error: cannot find last position in the gathered database" error when attempting to gather Oracle Standard Audit trail with an ODBC Proxy -
Description
When attempting to gather Oracle Standard Audit trail with an ODBC Proxy, an error similar to the following is recorded in the failed gathering session:
"Internal error: cannot find last position in the gathered database.[Microsoft][ODBC driver for Oracle][Oracle]ORA-00942:ta."
-
Cause
The rest of the Oracle error is likely, "ORA-00942: table or view does not exist".
There account specified in the connection string of the datasource on the InTrust server does not have all of the required Oracle permissions to gather the audit log.
-
Resolution
Ensure the account specified has the following minimum permissions (where account is the account used in the datasource):
GRANT SELECT ON "SYS"."AUD$" TO "account";GRANT SELECT ON "SYS"."V_$INSTANCE" TO "account";GRANT DELETE ON "SYS"."AUD$" TO "account";GRANT SELECT ON "SYS"."DBA_AUDIT_TRAIL" TO "account";GRANT "CONNECT" TO "account";