vRanger does not support utilizing Oracle database. vRanger can only utilize a SQL database.
Application Databases
vRanger utilizes a SQL database to store application and task configuration data. The database can be either SQL Express 2005, which is the default, or an external SQL database running on your own SQL Server 2005 or SQL Server 2008 database server.
Note:The cataloging function of vRanger requires that the application and catalog databases be installed on the vRanger server. For more information, see “Before You Install” in the vRanger Installation and Setup Guide
Database deployment options
The database deployment occurs during the initial installation of vRanger.
Default
The Installation Wizard will default with a selection to install vRanger with the embedded SQL Express 2005 database. The default database can only be installed on the vRanger server. While the embedded SQL Express database is free and simple to install, there is a size limit of 4GB per database.
External SQL Server
The Installation Wizard will guide you through configuring vRanger with an external SQL database. There is also an option in the Install Wizard to configure the database connection manually, but the guided approach is recommended.
Most larger organizations chose to use the embedded database to comply with internal policies and best practices. A significant advantage of using an external database, however, is that all settings and configurations (which are stored in the application database) are stored separate from the vRanger installation. In the event of a failure on the vRanger machine, the application can be quickly installed on another machine and configured to use the existing database.
Using an external database also makes it possible to move the vRanger installation with minimal effort.
The following versions of Microsoft SQL are supported for operation with vRanger 5.3.
SQL 2005 SQL 2008
SQL 2005 SP1 SQL 2008 SP1
SQL 2005 SP2 SQL 2008 SP2
SQL 2005 SP3 SQL 2008 R2
Caution: If you chose to use Microsoft SQL Server instead of SQL Express, the SQL Server application must be installed on the vRanger Machine in order for the cataloging feature to function. For more information, see the vRanger Installation and Setup Guide.
