Error when creating StandBy Database

[fabien.morel]

Hello,

I try DbVisit for my company, but I've got a problem when I create the standby database :

=>Oracle does not seem to be installed on standby_server. Please install Oracle first on standby_server before creating a standby database.

I don't understand because Oracle is already install and I can create manually a database. Do you have any idea of the cause of this problem ?

Here are my variable for DBVisit :

Would you like to review all the variables? <Yes/No> [Yes]:

=====10 Generic Settings=====
1) COMPRESS=dbvisit
2) CP=E:\oracle\Bitvise Tunnelier\sftpc.exe
3) ORACLE_HOME=E:\oracle\product\10.2.0\db_1
4) ORACLE_SID=oradev2
5) ORATAB=
6) OWNER=administrateur
7) PATH=C:\Windows;C:\Windows\system32
8) RSH=E:\oracle\Bitvise Tunnelier\sexec.exe
9) SEND_HEARTBEAT_TIME24=0700
10) TMP=e:\oracle\Dbvisit_temp
11) UNCOMPRESS=dbvisit
12) ZIP_EXTENSION=.gz

=====15 RAC Settings=====
13) RAC=N
14) RAC_TAKEOVER=
15) RAC_TAKEOVER_FORCE=
16) RAC_TAKEOVER_SID=

=====20 Primary Server Settings=====
17) BINDIR=e:/Oracle/Dbvisit
18) CHECKPOINT=No
19) DBPASSWD=******
20) DBUSER=dbvisit
21) ENCRYPT_PASSWDS=No
22) JOBHIST=dbvisit.hist
23) LEAVE_COMPRESS_SOURCE=Yes
24) LOGDIR=E:\oracle\product\10.2.0\admin\oradev2\dbvisit
25) ORACLE_BASE=E:\oracle
26) PFILE=E:\oracle\product\10.2.0\db_1\database\spfileoradev2.ora
27) SOURCE=first_server
28) SYNCH_DBVISIT_INSTALL=Yes

=====25 Sys Logon Settings=====
29) SYS_LOGON=No
30) SYS_LOGON_STRING=
31) SYS_USER=sys
32) _SYS_PASSWD=

=====30 Standby Server Settings=====
33) ADD_DATAFILE=Yes
34) ARCHDEST=E:\oracle\oraarch\oradev2
35) BINDIR_DR=e:/Oracle/Dbvisit
36) DESTINATION=standby_server
37) JOBHIST_DR=dbvisit.hist
38) LEAVE_COMPRESS_DEST=Yes
39) LOGDIR_DR=E:\oracle\product\10.2.0\admin\oradev2\dbvisit
40) MAX_TIMES_TRIED=4
41) ORACLE_BASE_DR=e:\oracle\product\10.2.0\db_1
42) ORACLE_HOME_DR=E:\oracle\product\10.2.0\db_1
43) ORACLE_SID_DEST=oradev2backup

=====40 Mail Settings=====
44) ADMINS=administrateur@qsd.com
45) MAILCFG_FROM=Dbvisit@qsd.com
46) MAILCFG_FROM_DR=Dbvisit_StdBy@qsd.com
47) MAILCFG_MAIL_CLIENT=Dbvisit
48) MAILCFG_SMTP_SERVER=192.168.1.249
49) MAILCFG_SMTP_SERVER_DR=192.168.1.249
50) SUCCESSMAIL=Yes
51) SUCCESSMAIL_DR=Yes

=====50 Primary Archive Log Management Settings=====
52) ARCHSOURCE_MANAGEMENT=Yes
53) DAYS_TO_KEEP_ARCHSOURCE=7
54) DELETE_ARCHSOURCE=No
55) NUM_ARCHSOURCE_TO_KEEP=0
56) THRESHOLD_ARCHSOURCE=80

=====60 Standby Archive Log Management Settings=====
57) ARCHDEST_MANAGEMENT=Yes
58) DAYS_TO_KEEP_ARCHDEST=7
59) DELETE_ARCHDEST=No
60) NUM_ARCHDEST_TO_KEEP=0
61) THRESHOLD_ARCHDEST=80

The server are on windows 2008 and the database is Oracle 10.2.0.4

[Arjen Visser]

Thank you for trying Dbvisit.

Dbvisit on the primary will go to the standby server and check if the Oracle executable exists to determine if Oracle in installed on the standby server or not. In your case it checks for:

E:\oracle\product\10.2.0\db_1\bin\oracle.exe

Does this Oracle executable exist on your standby server?

It uses ORACLE_HOME_DR to determine the location of the Oracle executable. Your ORACLE_HOME_DR is set to:
ORACLE_HOME_DR=E:\oracle\product\10.2.0\db_1

If this is not correct then please update the ORACLE_HOME_DR setting to the actual ORACLE_HOME on the standby server.

You can edit the Dbvisit Database Configuration (DDC) file with any editor and change it. In your case the DDC file is probably called dbv_oradev2.env.
Only edit the DDC file on the primary server. Dbvisit will synchronise the DDC file with the standby server, the next time Dbvisit or dbvisit_setup is called.

If this is not the issue, then please send us all trace files from e:\oracle\Dbvisit_temp\*.trc on the primary and standby server and we will investigate the issue for you.

You can log a new job and upload the trace files at: http://www.dbvisit.com/support.php

Thank you.

[fabien.morel]

By looking the trace file, this error is due to wrong right on the standby server, a path could not be created. I correct it but I've got another problem.
I ask the support for that.

Regards,
Fabien Morel