Help Center/ DataArts Studio/ FAQs/ DataArts Migration (Real-Time Jobs)/ What Should I Do If Error Message "cannot read the redo log position via 'SELECT CURRENT_SCN FROM V$DATABASE', make sure your server is correctly configured" Is Displayed During Incremental Synchronization from Oracle?
Updated on 2025-11-17 GMT+08:00
View PDF
Share

What Should I Do If Error Message "cannot read the redo log position via 'SELECT CURRENT_SCN FROM V$DATABASE', make sure your server is correctly configured" Is Displayed During Incremental Synchronization from Oracle?

Symptom

During incremental synchronization from Oracle, an error message is displayed, indicating that the V$database view cannot be read. The JobManager or TaskManager log contains the error message "cannot read the redo log position via 'SELECT CURRENT_SCN FROM V$DATABASE', make sure your server is correctly configured".

Possible Causes

The Oracle connection needs to query the SCN used by the current database from the V$database view. However, the user of the Oracle connection does not have the permission to query the V$database view. As a result, the query fails.

Solution

Grant the required permissions to the user in the Oracle connection by following the instructions provided in How Do I Grant the Log Archiving, Query, and Parsing Permissions of an Oracle Data Source?.