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.
Procedure
-
Copy the
<installation files
dir>/scripts/oracle_install directory to a location
where you can open and review (and if needed, edit) the contents.
This directory contains script files that correspond to supported
platforms. The file to edit depends on your platform.
- Linux:
create_databases.sh
- Windows:
create_databases.bat
- Linux (Oracle
Database running on Amazon RDS):
create_databases_rds.sh
- Windows (Oracle
Database running on Amazon RDS):
create_databases_rds.bat
-
Run the script, and provide the values for the variables as you
are prompted.
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_data_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.