You should run Database Vault Configuration Assistant (DVCA) after creating a new Oracle Database Vault database, if any of the following conditions is true:
Database Vault is installed into an Oracle home that has multiple database. You must run DVCA on the other databases in the Oracle home. This enables Database Vault security for those databases. The databases should meet the prerequisites for installing Oracle Database Vault, as discussed in "Preinstallation and Installation Tasks" .
Database Configuration Assistant (DBCA) is used to create a new Database Vault database in an Oracle home that has a Database Vault database. DVCA loads the Database Vault schema objects into the new database, creates the DV_OWNER
and optional DV_ACCTMGR
accounts, and deploys the Database Vault Administrator application for the database.
Use the following syntax to run the DVCA utility:
$ORACLE_HOME/bin/dvca -action option [-racnode host_name] -oh oracle_home -jdbc_str jdbc_connection_string -sys_passwd SYS_password -owner_account DV_owner_account_name -owner_passwd DV_owner_account_password [-acctmgr_account DV_account_manager_account_name] [-acctmgr_passwd DV_account_manager_password] [-logfile ./dvca.log] [-silent] [-nodecrypt][-lockout] [-languages {"[en],[de],[es],[fr],[it],[ja],[ko],[pt_BR],[zh_CN],[zh_TW]"}]
Where:
action
: The action to perform. option
creates the Database Vault schema objects, creates the DV_OWNER
account and the optional DV_ACCTMGR
account, and deploys the Database Vault Administrator application.
racnode
: The host name of the Oracle Real Application Clusters (Oracle RAC) node on which the action is being performed. Do not include the domain name with the host name. Use this option if this is Oracle RAC database.
oh
: The Oracle home for the database.
jdbc_str
: The JDBC connection string used to connect to the database. For example, jdbc:oracle:oci:@orcl1
, where orcl1
is the net service name in the tnsnames.ora
file ($ORACLE_HOME/network/admin/tnsnames.ora
).
sys_passwd
: Password for user SYS
. The command prompts for the password, if you do not enter it on the command line.
owner_account
: Oracle Database Vault Owner account name
owner_passwd
: Oracle Database Vault owner account password. The command prompts for the password, if you do not enter it on the command line.
acctmgr_account
: (Optional) Oracle Database Vault Account Manager user
acctmgr_passwd
: Oracle Database Vault Account Manager password (if a user name has been specified). The command prompts for the password, if you do not enter it on the command line.
logfile
: Optionally, specify a log file name and location. You can enter an absolute path or a path that is relative to the location of the $ORACLE_HOME/bin
directory
silent
: Required if you are not running DVCA in an xterm window
nodecrypt
: Reads plaintext passwords as passed on the command line. You must use this option if you are passing plaintext passwords to the command.
lockout
: Disables SYSDBA
operating system authentication
languages
: Declares the language content to load, defaults to "en"
(English). You can specify multiple languages. Include each language in quotation marks with commas separating different languages. Enclose the list of languages in braces. For example, -languages {"en","fr","ja"}
.
The following lists the language key:
de
: German
en
: English
es
: Spanish
fr
: French
it
: Italian
ja
: Japanese
ko
: Korean
pt_BR
: Brazilian Portuguese
zh_CN
: Simplified Chinese
zh_TW
: Traditional Chinese
Note:
If the Oracle system identifier (SID) of the database is more than 8 characters, then update the Net service name in the tnsnames.ora
file before running DVCA. Refer to Oracle Database Vault Release Notes for Linux x86 for more information.
DVCA should also be run before and after installing database options like Spatial, Java, and Intermedia. Refer to Oracle Database Vault Administrator's Guide for more details.