4.3 Creating an Oracle database

If you prefer not to use the default database that was created when you installed Oracle 11g, create a new database by using the Database Configuration Assistant tool. Document Services supports Oracle 11g on WebLogic, WebSphere, and JBoss application servers.

Note: You can use the Transaction Processing or General Purpose templates while configuring an Oracle database instance for Document Services. If you wish to use the Custom Database template for configuring a database instance, the minimum set of database components you must include are Oracle JVM and Enterprise Manager Repository.

Do the following when you create your Oracle database:

  • Set the initial database size to a minimum of 500 MB. Increase this initial size if you are deploying Content Services.

  • Create user quotas to allow the database to grow to accommodate persistent data from Document Services applications.

  • Enable support for UTF-8 encoding.

  • Set Database Character Set to Unicode (AL32UTF8), and the National Character Set is AL16UTF16 (Unicode UTF-16 universal character set).

  • Set NLS_LENGTH_SEMANTICS to BYTE (if required). The database initialization fails if you set any other value.

  • You must install Oracle using Transaction Processing and set the connection mode for the server to Dedicated Processing.

4.3.1 Configuring Oracle for XA datasource

Note: Perform these steps only if you plan to work with Interactive Statements solution. Interactive Statements require configuring the XA datasource, and you need an XA-enabled database for XA datasource to configure properly.

For creating XA-enabled Oracle database, ensure that the Oracle user has permission to access the following database tables:

GRANT SELECT ON sys.dba_pending_transactions TO user; 
GRANT SELECT ON sys.pending_trans$ TO user; 
GRANT SELECT ON sys.dba_2pc_pending TO user; 
GRANT EXECUTE ON sys.dbms_xa TO user;

where user is the user defined to connect to the Oracle database.

4.3.2 User account and rights

Create a new user account on the database and assign it the following system privileges:

  • CREATE SEQUENCE

  • CREATE VIEW

  • UNLIMITED TABLESPACE

  • CREATE TABLE

  • CREATE CLUSTER

  • CREATE SESSION

Important: (WebLogic only) When using WebLogic and an Oracle database, ensure that the database user name does not have a number as the first character, nor a hyphen (-) within the user name. Otherwise, the database does not bootstrap properly.

For deployments on AIX, Linux, or Solaris, the user name must not exceed 8 characters; on Windows, it must not exceed 12 characters.

You need the following information when you configure the data source on the application server:

  • SID (Service ID)

  • User name and password of the Oracle user account

  • Host name or IP address of the database server

  • Oracle LISTENER port number (default is 1521)

For information about using Oracle 11g, see the appropriate user documentation.