Charset

Server needs to use AL32UTF8, which is also Oracle's recommendation.

Package Dependencies

Database user for TIS

The database user needs the following system packages:

  • dbms_lob
  • utl_raw
  • dbms_sql
  • dbms_application_info
  • dbms_scheduler
  • dbms_monitor
  • dbms_transaction
  • dbms_job

Additionally the user must be member of the role TIS2005R.

Permissions

For setting up and using TISDB with Oracle you need a user with sufficient permissions. Further on, in the creation process an application user is created with sufficient permissions for conducting later schema updates.

Step

Permission Requirements

Scripts

Create Database

  • create tablespace
  • create temporary tablespace
  • read dba_tablespaces table
  • create user
  • create role
  • drop user
  • read dba_users table
declare
  v_rows int;
  v_sql varchar2(100);
 
begin
  select count(1) into v_rows from dual where exists
    (select null from dba_roles where role = upper('tis2005r'));
  if v_rows = 0 then
    V_SQL := 'create role tis2005r not identified';
    dbms_output.put_line(v_sql);
    execute immediate(v_sql);
    V_SQL := 'grant create procedure to tis2005r';
    execute immediate(v_sql);
    V_SQL := 'grant create session to tis2005r';
    execute immediate(v_sql);
    V_SQL := 'grant create sequence to tis2005r';
    execute immediate(v_sql);
    V_SQL := 'grant create synonym to tis2005r';
    execute immediate(v_sql);
    V_SQL := 'grant create table to tis2005r';
    execute immediate(v_sql);
    V_SQL := 'grant create trigger to tis2005r';
    execute immediate(v_sql);
    V_SQL := 'grant create type to tis2005r';
    execute immediate(v_sql);
    V_SQL := 'grant create view to tis2005r';
    execute immediate(v_sql);
 
    V_SQL := 'grant insert any table to tis2005r';
    execute immediate(v_sql);
    V_SQL := 'grant select any sequence to tis2005r';
    execute immediate(v_sql);
    V_SQL := 'grant select any table to tis2005r';
    execute immediate(v_sql);
    V_SQL := 'grant create job to tis2005r';
    execute immediate(v_sql);
  end if;
end;
/

Update Database

  • create procedure
  • create session
  • create sequence
  • create synonym
  • create table
  • create trigger
  • create type
  • create view
  • create job
  • insert any table
  • select any sequence
  • select any table

Client side

Starting from v 6.8 of TIS: On the TISInstaller host a sqlplus only installation of the Oracle Client needs to be installed. See also Oracle Docs

Performance

In some environments and use cases increasing the FetchSize improved the proformance of TIService (TIServiceWindowsService.exe.config) and TISBoard (web.config).

<oracle.dataaccess.client>
<settings>
<add name="FetchSize" value="15000000"/>
</settings>
</oracle.dataaccess.client>