Main Generic Settings

Owned by KrupeshD (Deactivated)
Last updated: Jan 17, 2013
3 min read
Variable NameMeaning
ORACLE_SIDName of the Oracle database for which these configuration variables apply. In a RAC environment, this will be the name of the instance.
Example:
    ORACLE_SID = w102n
OWNERWindows account owner that will run Dbvisit Standby. 
It is recommended that this be the same user as the Oracle database owner.
This account must also exist on the standby database server.
Example: 
    OWNER = oracle
ORATABOnly used for Unix/Linux
This file lists the databases present on this server. For Solaris and for some Linux this can be /var/opt/oracle/oratab
For others this is /etc/oratab
Example:
    ORATAB = /etc/oratab
CPExternal copy method, to transfer the (archive) log files from the source server to the standby server.
It is recommended to use a secure copy method (scp) or secure ftp (sftp).
The external copy method must be configured so that no password or pass phrase is required.
Example:
    CP = C:\Program Files\Bitvise Tunnelier\sftpc.exe
RSHExternal remote shell method for Dbvisit Standby operation.
It is recommended to use SSH (secure shell).
The external remote shell method must be configured so that no password or pass phrase is required.
Example:
    RSH = C:\Program Files\Bitvise Tunnelier\sexec.exe
COMPRESSThe compression method used to compress the (archive) log files.
The following compression options are available:
1.     Dbvisit Standby internal compression.  This uses the zlib compression library. Dbvisit Standby will compress the archives on disk first before transferring to the standby server. This will leave the files on the server in a compressed state. 
Set COMPRESS=dbvisit 
for Dbvisit Standby internal compression.
2.     SSH compression. This uses the zlib compression library to compress the files as they are being transferred to the standby server. This option is only available if ssh (secure shell) is being for the transfer method. This will leave the files uncompressed on the server.
Set COMPRESS=ssh
for ssh compression.
3.     This turns compression off. Use this option if the network speed is sufficiently fast to transfer uncompressed (archive) log files and disk space is sufficient to hold uncompressed files. 
Set COMPRESS=No
for no compression.
 
Unix/Linux:
For Unix and Linux and alternate external compression method (like gzip or compress) can also be specified. 
Examples:
   COMPRESS  = /bin/gzip
   COMPRESS  = /usr/bin/compress
NOTE: It is recommended to disable any other compression routines used to compress the Oracle (archive) log files.
If unsure set compression method to Dbvisit Standby internal compression:
Example:
COMPRESS = dbvisit
UNCOMPRESSThe uncompress method used to uncompress the (archive) log files.
The following options are available:
1.     Dbvisit Standby internal compression.  This uses the zlib compression library. Dbvisit Standby will uncompress the archives on disk first before applying to the standby server. After applying to the standby server, the files will be compressed again to save disk space.
 Set UNCOMPRESS=dbvisit 
for Dbvisit Standby internal uncompression.
2.     SSH compression. This uses the zlib compression library to uncompress the files as they are being received on the standby server. This option is only available if ssh (secure shell) is being for the transfer method. This will leave the files uncompressed on the server.
Set UNCOMPRESS=ssh
for ssh uncompression.
3.     This turns compression off.  If compression is turned off, Dbvisit Standby will still recognize if a file is compressed and uncompress the file (using the Dbvisit Standby internal method).
Set UNCOMPRESS=No
for no uncompression.
 
Unix/Linux:
For Unix and Linux and alternate external compression method (like gzip or compress) can also be specified. 
Examples:
   COMPRESS  = /bin/gzip
   COMPRESS  = /usr/bin/compress
NOTE: It is recommended to disable any other compression routines used to compress the Oracle (archive) log files.
If unsure set uncompression method to Dbvisit Standby internal compression:
Example:
UNCOMPRESS = dbvisit
Note: The UNCOMPRESS method must match the COMPRESS method.
ZIP_EXTENSIONThe extension of the compressed file. This depends on the compression method used. In most cases this is either:
    .gz (for gzip and Dbvisit Standby internal compression)
    .Z (for compress)
Example:
    ZIP_EXTENSION = .gz
SEND_HEARTBEAT_TIME24The time that the daily heartbeat alert (email) will be sent.
This is a daily email to ensure that emailing from Dbvisit Standby is active. This will be sent from the primary and standby server.
The time is in 24 hour format and should be between 0000 and 2359 and must be 4 digits. If this variable is not present, an email will be sent at the start of each day (midnight). Multiple times separated by colon can be set.
Also see the  E-Mail setup section.
Example:
    SEND_HEARTBEAT_TIME24 = 0700
    SEND_HEARTBEAT_TIME24 = 0700:1300:1800
TMPThe directory where the Dbvisit Standby temporary and trace files will be located. 
Example:
    TMP = C:\temp
    TMP = /usr/tmp
PATHPath to the server environment.
Windows:
Set to the Windows and Windows command directories.
Example:
    PATH = C:\WINDOWS;C:\WINDOWS\system32 
Unix/Linux:
Set to the usual bin directories.
Example:
    PATH = /usr/bin:/bin:/usr/sbin:/usr/local/bin:/sbin
ORACLE_HOMESpecify the Oracle Home of the database. 
In most cases this setting is not required as Dbvisit Standby can determine the ORACLE_HOME.Â