Creating New Dbvisit Database Repository (DDR)

Owned by Ankit Arora (Deactivated)
Last updated: Nov 03, 2014
3 min read

 

The below section outlines the steps for creating New Dbvisit Database Repository.

If you are recreating the DDR you will lose all the statistical information the GUI displays in the reporting section. You will also need to apply the Dbvisit Standby License again.

 

In this example the setup is as follow:

  • Dbvisit Standby version: 6.0.60
  • Operating System - Oracle Linux 5.8
  • Oracle Database version: 11.2.0.4
  • Database Name: testdb

 

Step 1: On the Primary Node execute the “dbvisit_setup” command.

 

oracle@dbvlin803[/usr/local/dbvisit/standby]: ./dbvisit_setup
=========================================================
     Dbvisit Standby Database Technology (6.0.60.11060)
           http://www.dbvisit.com
=========================================================
=>dbvisit_setup only needs to be run on the primary server.

Is this the primary server? <Yes/No> [Yes]:
=========================================================
     Dbvisit Standby Database Technology (6.0.60.11060)
           http://www.dbvisit.com


     Dbvisit Database setup
       Default values will be shown in []

  Options:
       1) New Dbvisit Database setup (combines options 2,3,4)
       1a) New Dbvisit 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
       7) Create Standby Database (and template)
       8) Synchronize Standby Database
       9) Uninstall Dbvisit Database repository (DDR)
       E) Exit
=========================================================
Please enter choice : 4
 
Continue ? <Yes/No> [No]: Yes
------------------------------------------------------------------------------
=>Creating Dbvisit Database repository (DDR).


Choose database:
The following Oracle database(s) have a Dbvisit Database configuration (DDC) file on this server:
     DDC
     ===
1)   testdb
2)   Return to menu

Please enter choice : 1

Is this correct? <Yes/No> [Yes]:
Database testdb is up.

=>ALERT : User dbvisit already exists in Database testdb.

Do you want to drop the existing Dbvisit Database repository (DDR) and all of its contents? Yes or return to the menu? <Yes/Return> [Return]: Yes
Are you sure? <Yes/No> [Yes]: Yes

Dropping user dbvisit... this may take a while
User dbvisit dropped.

------------------------------------------------------------------------------
Please select the default tablespace to install the Dbvisit Database repository (DDR).

The following tablespaces are available:
     Tablespace
     ===========
1)   USERS
2)   PRAC
3)   Refresh list

Please enter choice : 1

The default tablespace will be: USERS
Is this correct? <Yes/No> [Yes]:

------------------------------------------------------------------------------
Please select the temp tablespace to install the Dbvisit Database repository (DDR).

The following tablespaces are available:
     Tablespace
     ===========
1)   TEMP
2)   PRAC
3)   USERS
4)   Refresh list
Please enter choice : 1

The temp tablespace will be: TEMP
Is this correct? <Yes/No> [Yes]:
 
Dbvisit will now create the Dbvisit Database repository (DDR). Continue (Yes) or return to the menu? <Yes/Return> [Yes]: Yes
User dbvisit created.

Grants to user dbvisit completed.
Dbvisit Database repository (DDR) for dbvisit created.

Please press <Enter> to continue...


Step 2: Once the above is completed, Please apply the license which can be done using below command.

./dbvisit  -lic <DDC> <LICENSE_KEY>