5.4.2 Creating an Oracle database

If you prefer not to use the default database that was created when you installed the database, create a new database by using the Database Configuration Assistant tool. For a list of supported databases for AEM forms on JEE, see Supported Platforms .

Note: You can use the Transaction Processing or General Purpose templates while configuring an Oracle database instance for AEM forms on JEE. 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 applications for AEM forms on JEE.

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

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

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 database, see the appropriate user documentation.

// Ethnio survey code removed