Set up an Oracle database

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

1. 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.

2. Connect to your Oracle database.
   • SQL> connect <adminusername>@<db_name>/<adminpassword> as sysdba
3. 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.
4. 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.