Oracle Installation

Once you've downloaded the ProvenDB for Oracle binary, you should install the provendb user and internal tables using the provendb-oracle install command. This command has the following usage:

proofable-oracle$ ./provendb-oracle install  --help
Installs the ProvenDB for Oracle users and tables

USAGE
  $ provendb-oracle install

OPTIONS
  -v, --verbose                                        increased logging verbosity
  --config=config                                    Create config file
  --createDemoAccount                        Create the ProofableDemo account
  --dropExisting                                      Drop existing users if they exist
  --oracleConnect=oracleConnect        (required) Oracle connection String
  --provendbPassword=provendbPassword  (required) Oracle connection String
  --sysPassword=sysPassword              SYS Password

The installer takes the following arguments:

Argument	Type	Description
config	String	If specified, a configuration file for the newly installed provendb configuration will be created
createDemoAccount	None	If specified a `provendbdemo` account will be created with sample tables
dropExisting	None	If specified, existing user accounts will be dropped if they already exist
oracleConnect	String	Mandatory. The Oracle connection to use - either an EZconnect string or a TNSnames alias
provendbPassword	String	Password to be used for the new Provendb user (mandatory)
sysPassword	String	Password for the SYS account in the target database. Will be prompted for if not provided.
dbaUserName	String	DBA user for the installation (instead of SYS)
dbaPassword	String	Password for the DBA user

Here is an example installer session:

$ provendb-oracle install --oracleConnect=centosdb --dropExisting --provendbPassword=DBEnvy2016 --createDemoAccount --sysPassword=DBEnvy2016 --config=mynewconfig.yaml
14:32:31.353 INFO  Connecting to Oracle as SYS...
14:32:31.803 INFO  Connected to SYS
14:32:31.803 INFO  Installing ProvenDB for Oracle users and tables
14:32:31.804 INFO  Dropping existing users
14:32:32.107 INFO  Creating ProvenDB user
14:32:32.280 INFO  Creating demo account
14:32:32.384 INFO  Installing ProvenDB user tables
14:32:32.546 INFO  Connected to provendb
14:32:32.700 INFO  Creating demo tables
14:32:32.865 INFO  Connected to provendbdemo
14:32:33.075 INFO  Install complete
14:32:33.078 INFO  Wrote new config to mynewconfig.yaml

🚧
Note
If you auto-generated a configuration file, then a trial key will be inserted into the file. To use your own key you will need to add your API key to the configuration file. See Configuration file Reference .

🚧Note

🚧
Note