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 more than one 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] [-languages {["en"],["de"],["es"],["fr"],["it"],["ja"],["ko"],["pt_BR"],["zh_CN"],["zh_TW"]}]
In this specification:
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 (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 an 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
owner_account: Oracle Database Vault Owner account name
owner_passwd: Oracle Database Vault owner account password
acctmgr_account: (Optional) Oracle Database Vault Account Manager user
acctmgr_passwd: Oracle Database Vault Account Manager password (if a user name has been specified)
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.
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 you must update the Net service name in the tnsnames.ora file before running DVCA. See Oracle Database Vault Release Notes for hp Tru64 UNIX for more information about Bug 5258820.
Ensure that the database and the listener are running before you run the DVCA utility.
You should run DVCA before and after installing database options like Spatial, Java, and Intermedia. See Oracle Database Vault Administrator's Guide for more details.
In an Oracle Real Application Clusters (RAD) environment, after you run DVCA on a local node, run it again on the remote nodes by including option optionrac in the dvca command.