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
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 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:
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