Return
-
Title
Compare fails with error: "Failed to get stat() on" -
Description
When running compare command in sp_ctrl the following error is displayed:
Failed to get stat() on /SharePlex/vardir/log/*.sql - No such file or directory.
-
Cause
Lack of database privileges on the target.
-
Resolution
Perform the following on target:
Oracle 9i:
SQL> grant select any dictionary to <splex_user>;
Oracle 8i:
SQL> grant select_catalog_role to <splex_user>;
Re-run the compare command. -
Additional Information
This solution applies to Oracle 8i and 9i only.