MINE crashes after an upgrade due to insufficient privilege on gv_$transaction

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
1 min read

Description

MINE crashes after upgrade complaining about insufficient privileges.

Solution

If upgrading from a previous version of Dbvisit Replicate to 2.6.04.4136 or later and running RAC, the following grant should be executed by sysdba:

SQL> grant select on gv_$transaction to dbvrep;

Krupesh Desai May 21, 2014 16:47