We're here to help!

ERROR_CODE:1 Error executing sqlite statement:no such table: DBV_VERSION

Follow

Sometimes Creating standby database  fails with ERROR_CODE:1 Error executing SQLite statement:no such table: DBV_VERSION 


Problem Details

Problem Statement

Creating a standby database fails with this error and it is observed in RAC

Applicable Error Code

ERROR_CODE:1 Error executing sqlite statement:no such table: DBV_VERSION 

Affected Versions

v8 and v9

Affected Platforms

All

 

Description

The reason for having this error when creating a standby database is either the Dbvisit SQL-repository is corrupted or incorrect DDC parameter setting especially in RAC configuration or it could be both.

Solution

Option 1: Check the RAC parameter are set right in the Dbvisit conf file. Follow the below steps to set the parameter.

Step1: Edit the DDC configuration file and set the right values to RAC parameter

 For eg: I have taken a 2 node primary RAC instance MYDEV1 and MYDEV2 and single node standby.

 The VIP on the RAC Cluster is running on kiwi81 and is called "kiwi812-vip"

Primary
Server1: kiwi81
server2: kiwi82

DB_NAME=MYDEV

SOURCE =kiwi812-vip
ORACLE_SID =MYDEV1
ORACLE_SID_ASM = +ASM1
DB_UNIQUE_NAME = MYDEV
RAC1 =1:kiwi81:MYDEV1:+ASM1
RAC2 =1:kiwi82:MYDEV2:+ASM1=
Step3. Start CSD again.
 
In case the repository is corrupted then recreate the repository using option 2 and  start CSD again 
 
Option 2:  Recreate repository
 
Please follow the link to recreate the repository
 You can backup the existing repository( DBVISIT_BASE/standby/conf and it has the format <DB_NAME>.db) and re-create a new one.
 
 
 
 
Have more questions? Submit a request

Comments