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. LiveCycle 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 LiveCycle. 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.

  • Create user quotas to allow the database to grow to accommodate persistent data from LiveCycle 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 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.

    // Ethnio survey code removed