The steps in this article apply when you try to run Log gap report and get these messages: Error: Last sequence from Standby Database PROD is not an integer (138,107). Return code = 838
What is required to address the Last sequence from Standby Database is not an integer, Return Code = 838, messages when running a Log gap report
Applicable Error Code
v7 & v8
platform e.g. Linux
When running a Log Gap report you get the following error messages :
Add any paragraph
Error: Last sequence from Standby Database Prod is not an integer (138,114).
Please contact Dbvisit support.
Dbvisit Standby terminated.
Return code = 838
Somehow a number format was added to the $ORACLE_HOME/sqlplus/admin/glogin.sql script.
So dbvisit misunderstands the sequence number when running the log gap report
Comment out the number format.
Run the log gap report "dbvisit -i PROD" from the Primary server.
It should be working now.