Error: Last sequence from Standby Database Prod is not an integer (138,107). Dbvisit Standby terminated. Return code = 838

Read our docs 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

Problem Details

Problem Statement

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

N/A

Affected Versions

v7 & v8

Affected Platforms

platform e.g. Linux

Description

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

Solution

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.

We're here to help!

Comments