Spotfire® Server and Environment - Installation and Administration

Variables in create_databases (Oracle)

Use these variables in the script for setting up a Spotfire database for Oracle.

Variable Description
SPOTFIREDB_ROOTFOLDER Location where the tablespaces are created. This must be a directory that is writable for the Oracle instance.

Example: <oracle install dir>/oradata/SID or <oracle install dir>/oradata/PDBNAME.

Note: Do not add a slash or backslash after the <SID>.
Note: This variable is not applicable for the Amazon RDS create_databases scripts.
DBSERVER_CONNECTIDENTIFIER Oracle TNS name/SID of the database/service name.

Example: ORCL or //<database server address>/<database name>.

DBSERVER_ADMIN_USERNAME Name of a user with Oracle Database administrator privileges for the database identified in the DBSERVER_CONNECTIDENTIFIER.

Example: system.

DBSERVER_ADMIN_PASSWORD Password of the DBSERVER_ADMIN_USERNAME.
Warning: This is visible in clear text. Delete the script after use.
SPOTFIREDB_USERNAME Name of the user to create to set up the Spotfire Server database.

Default: spotfire.

SPOTFIREDB_PASSWORD Password for SPOTFIREDB_USERNAME.
SPOTFIREDB_DATA_TABLESPACE Name of the tablespace to create.

Default: SPOTFIRE_DATA.

SPOTFIREDB_TEMP_TABLESPACE Name of the temporary tablespace to create.

Default: SPOTFIRE_TEMP.

Note: Conflicting tablespaces can occur if you are creating the Spotfire tablespaces on a database server that is already hosting an Analytics Server or a previous version of Spotfire Server. Make sure that you do not select any names for the new tablespaces and users that conflict with the already hosted tablespaces and users.