Xerox DocuShare Support & Software インストールガイド

DocuShare Installation Guide

3–1

Database configuration

3

Before starting the DocuShare software installation, the Oracle database administrator must:

•

Create a DocuShare/Oracle user and a tablespace.

If you choose to use an existing Oracle database or prefer to manually create and define an Oracle 
tablespace, the following is an example of a typical DocuShare tablespace creation script.

CREATE TABLESPACE <name> DATAFILE <file> SIZE <size> AUTO EXTEND ON NEXT 512K 
MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

•

Designate a location on the Oracle system that has the required space for the new tablespace file.

•

Set character encoding to AL32UTF8 if the system will be operating with multibyte characters.

•

Change the value of nls_length_semantics from byte to char if the system will be operating with 
multibyte characters. If the value of nls_length_semantics is byte, the max length of DocuShare is 
different from the max length of DB because 1 multi-byte character in UTF-8 is 3byte.

DocuShare 5.x had a Connect role that gave the DocuShare user account the authority to create Oracle 
connections, table, and sequence privileges. If upgrading from DocuShare 5.x to DocuShare 6, an 
additional role, CTXAPP, must be granted to Oracle database users. CTXAPP is required by the 
DocuShare Extensible Database Service (XDB). DocuShare 6 installation automatically grants both 
Connect and CTXAPP roles to the DocuShare user account.

The database administrator can grant the CTXAPP role to DocuShare users by logging on as either 
SYSTEM or as a user with DBA privileges and entering: 

SQL> GRANT CTXAPP, CREATE SEQUENCE to <DS user>.

For Oracle 10.2.0.4, the Connect role has been stripped of the create table and create sequence 
privileges.These privileges need to be restored. If an Oracle 9.x or 10.1 database is upgraded to 10.2, the 
database administrator needs to make sure that the following roles are present: