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.