User`s guide

Chapter 14: Database Administration 213
14 Database Administration
The database installation is a typical Oracle database server installation. For how
to install an Oracle database server, see the related documentation supplied by
Oracle.
Vizrt’s standard installation of a VCP database uses the service name VIZRTDB .
The SQL schema and table creation scripts add the user PILOT with password
PILOT which makes up the schema name and the default credentials all VCP
applications are configured to use. All this can be changed either during
installation or after installation.
VCP’s database setup involves the use of Viz Content Pilot’s Database
Administrator tool (VCP DBA).
VCP DBA is a program that is used by database administrators (DBA) in order to
install, maintain and upgrade the Viz Content Pilot database system.
VCP DBA also enables the database administrator to check the current status of
the database.
IMPORTANT! Vizrt does not support installations on express edition (XE) databases.
This section contains information on the following topics:
• Requirements
• Installation
• Getting Started
• User Interface
• Management Options
14.1 Requirements
To run VCP DBA, the following software is required:
• VCP DBA client
• Oracle 11g Administrator Client.
• Installs the management console, management tools, networking services,
util, and basic client software.
Table 31: Database connection parameters
Oracle system identifier (SID/Service name) VIZRTDB
All system users (default) system/oracle
sys/oracle
All users (default) PILOT/PILOT
Database schema (default) PILOT