TIBCO Spotfire® Server and Environment - Installation and Administration

Running database preparation scripts manually

If you plan to set up Kerberos authentication between your database and Spotfire Server, you must run the database SQL preparation scripts manually.

Procedure

  1. Read through the create_databases script to understand how the scripts work.
  2. Run the following scripts:
    • create_server_db.sql
    • populate_server_db.sql
    • create_server_env.sql
    Important: For Oracle, the create_databases script passes the following variables to these scripts. When you run the database Oracle scripts manually, make sure to pass these variables along to the scripts:
    • ROOTFOLDER
    • CONNECTIDENTIFIER
    • SERVER_DATA_TABLESPACE
    • SERVER_TEMP_TABLESPACE
    Important: For SQL, the create_databases script passes the following variable to these scripts. When you run the database SQL scripts manually, make sure to pass this variable along to the scripts:
    • SERVERDB_NAME