Dbvisit quick installation - Linux/Unix

The complete installation and configuration should take less than 30 minutes. The server or the database does not need to be restarted.

This is a quick installation guide only. For the complete step-by-step instructions please see the Dbvisit Installation Guide and User Manual.

RAC environment

In an Oracle RAC environment, Dbvisit must be installed and configured as below on each primary node in the RAC cluster.

Primary Server (or primary node)

  1. Unzip the dbvisit51_<os>.zip file to a temporary directory. This can be done on a local PC.

(where <os> is the Operating System - linux, hpux, aix, solaris etc.)

2.     Login as the Oracle database owner (e.g.: oracle) to the primary server.

  1. Create the directory /usr/local/dbvisit and ensure that the oracle user has full access to this directory.

/usr/local/> chown oracle:dba dbvisit

Where oracle is the Oracle database owner and dba is the database group.

  1. Copy the installation file dbvisit51.tar to the install (/usr/local/dbvisit) directory on the primary server.
  2. Change directory to the installation directory (/usr/local/dbvisit).
  3. Untar the file:

/usr/local/dbvisit/> tar xvf dbvisit51.tar

      Where /usr/local/dbvisit/ >   is the prompt of the OS showing the current directory.

  1. Ensure the files are executable:

/usr/local/dbvisit/> chmod 750 *
  1. The tar file can be deleted if required:

/usr/local/dbvisit/> rm dbvisit51.tar

 

Standby Server

  1. Login as the Oracle database owner (e.g.: oracle) to the standby server.
  2. Create the directory /usr/local/dbvisit and ensure that the oracle user has full access to this directory.

/usr/local/> chown oracle:dba dbvisit

Where oracle is the Oracle database owner and dba is the database group.

The Dbvisit software has been installed. The standby database can now be created.

Creating a standby database

If a standby database is already created, then this step can be ignored. Please continue with the next step.

See http://www.dbvisit.com/docs/Creating_a_standby_database_linux.pdf on how to create a standby database.

Configure secure shell – SSH

Secure shell is the preferred method to transport the Oracle logs from the primary to the standby servers.

If a SSH without a password or passphrase is already configured, then this step can be ignored. Please continue with the next step.

See http://www.dbvisit.com/docs/Setup_ssh_without_passphrase.pdf on how to setup SH without a password or passphrase.

Configure Dbvisit - Linux/Unix

Once the Dbvisit software is installed and the standby database is created, Dbvisit can be configured (or setup) for a specific database.

Primary server (or primary RAC node) setup

  1. Go to the Dbvisit install directory and start the Dbvisit setup utility.

/usr/local/dbvisit/dbvisit_setup
  1. Confirm that this is the primary server.

=>dbvisit_setup only needs to be run on the primary server.

Is this the primary server? <Yes/No> [Yes]:
  1. Choose option 1 (for RAC choose option 1a) and follow the on-screen instructions and accepts the defaults:

=========================================================

     Dbvisit Standby Database technology

           http://www.dbvisit.com

 

     Dbvisit Database setup

       Default values will be shown in []

 

  Options:

       1) New Database setup (combines options 2,3,4)

       1a) New RAC Instance setup (combines options 2,3,4)

 

       2) New Dbvisit Database configuration (DDC) file setup

       3) New Dbvisit Archive Management Module (AMM) setup

       4) New Dbvisit Database repository (DDR) setup

 

       5) Manage Dbvisit Database repository (DDR)

       6) Update Dbvisit Database configuration (DDC) file

 

       9) Uninstall Dbvisit Database repository (DDR)

 

       E) Exit

 

=========================================================

Please enter choice : 1

 

  1. Once the Dbvisit setup is complete, choose option E to exit.
  2. The Dbvisit configuration will be automatically replicated to the standby server the first time Dbvisit is executed.

Running Dbvisit (executing Dbvisit)

Executing Dbvisit commands

Dbvisit is run from the Dbvisit install directory.

1.     Go to the Dbvisit install directory:

cd /usr/local/dbvisit/

 

2.     Executing Dbvisit on the primary server:

dbvisit oracle_database

Where oracle_database is the name of the database (or RAC instance).

Example

/usr/local/dbvisit/dbvisit w120n

Where w120n is the name of your database

The first time that Dbvisit executes, the Dbvisit installation and configuration files will be copied over to the standby server. This is equivalent to running Dbvisit with the -c option.

3.     Executing Dbvisit on the standby server:

dbvisit oracle_database

Where oracle_database is the name of the database (or RAC instance).

Example

/usr/local/dbvisit/dbvisit w120n

Where w120n is the name of your standby database

 

For the complete list of Dbvisit commands see Dbvisit commands overview.

 

Dbvisit quick installation guide - www.dbvisit.com