Set up an Oracle database on its own server

To use an Oracle database for your CollabNet TeamForge data, set up the Oracle database and tell the installer how to handle it.

1. Install Oracle according to the instructions provided.
2. Under "Application settings" in the site-options.conf file, create (or reuse) a HOST_<hostname> token to specify the machine where the database service will run. For example:
   • HOST_databox.supervillain.org=database
3. Under "Database tokens," configure the site to use the database application.
   • If you are using a PostgreSQL database, keep the value of the DATABASE_TYPE variable at the default value, postgresql.
   • If you are using an Oracle database:
     • Set the value of the DATABASE_TYPE variable to oracle.
     • Set the value of the DATABASE_PORT variable to 1521.
4. Set values for the other key database variables. (Replace the terms in angle brackets with any string you want.)
   • DATABASE_NAME=<database_name>
   • DATABASE_USERNAME=<database_user>
   • DATABASE_PASSWORD=<database_password>
   Note: The database password must not contain any special characters. Only alphanumerics will work.
5. Make sure your database uses UTF8 or AL32UTF8 encoding. This is needed to support users in Asian languages.

   For information about discovering and changing the database encoding, see this Oracle knowledge base article.

6. Connect to your Oracle database.
   • SQL> connect <adminusername>@<db_name>/<adminpassword> as sysdba
7. Create the database user and password you will use to connect from CollabNet TeamForge to Oracle.

   SQL> create user <sf user> identified by <sf passwd> default tablespace <your tablespace> temporary tablespace <temporary tablespace>;

   User created.
8. Grant permissions to the user that you just created.
   • SQL> grant unlimited tablespace to <sf user>;
   • SQL> grant create snapshot to <sf user>;
   • SQL> grant create cluster to <sf user>;
   • SQL> grant create database link to <sf user>;
   • SQL> grant create procedure to <sf user>;
   • SQL> grant create sequence to <sf user>;
   • SQL> grant create synonym to <sf user>;
   • SQL> grant create trigger to <sf user>;
   • SQL> grant create type to <sf user>;
   • SQL> grant create view to <sf user>;
   • SQL> grant query rewrite to <sf user>;
   • SQL> grant alter session to <sf user>;
   • SQL> grant create table to <sf user>;
   • SQL> grant create session to <sf user>;
   • SQL> exit
   Note: The CollabNet TeamForge installer creates the tables and default values for you.