Run the script for Oracle interactively

If you are a new administrator and are creating only one Spotfire database, then this option of running the database configuration interactively, providing the values at the prompts, might best suit your scenario.

Before you begin

Complete the requirements and steps described in Setting up the Spotfire database (Oracle).

Procedure

Run the script, and provide the values for the variables as you are prompted.

For more information about the variables, see Variables in create_databases (Oracle).

When you have provided valid values for each of the prompts, a confirmation message similar to the following example is displayed.

You have supplied the following information:
SPOTFIREDB_ROOTFOLDER:              c:\orcl
DBSERVER_CONNECTIDENTIFIER:         192.168.56.5/xepdb1
DBSERVER_ADMIN_USERNAME:            system
DBSERVER_ADMIN_PASSWORD:            *********
SPOTFIREDB_USERNAME:                spt_new_var_server
SPOTFIREDB_PASSWORD                 *********
SPOTFIREDB_DATA_TABLESPACE:         spot_dita_server
SPOTFIREDB_TEMP_TABLESPACE:         SPOT_TEMP_SERVER

Would you like to use the above information to create the spotfire server database? [y/n]:

Press y to confirm.

Results

The required Spotfire user and database table schemas are created in your database.

The log file log.txt file is created in the working directory. If the execution fails, then the log file contains information about the failure. If the execution succeeds, then information about changes to the database (such as Tablespace created, User created, and so on) are reflected in the log file.

What to do next

Install Spotfire Server