Creating and configuring an Oracle pluggable database

This article includes instructions on how to manually create and configure an Oracle pluggable database on WebLogic. Oracle pluggable database on AEM Forms on JEE can be configured manually only and not through Configuration Manager. 

For introduction to pluggable database and multi-tenant architecture, see Introduction to the Multitenant Architecture.  

To create and configure an Oracle pluggable data source, complete the following steps:


The following steps use as the container database name. Replace it with the your container database name.

  1. Create a container database using noninteractive/silent mode of Database Configuration Assistant (DBCA).

    1. Go to your oracle home. For example, on Windows you can run cd%Oracle_HOME%\bin to go to your Oracle home.

    2. Pass the following command to create the container database in noninteractive/silent mode using Database Configuration Assistant (DBCA). Replace the database name in the command with your database name. 

      dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname -sid -createAsContainerDatabase true -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL
  2. Using SQL*Plus®, connect to the new container database as the DBA:

    sqlplus system/password@localhost:1521/ as sysdba
  3. In SQL*Plus®, to create pluggable database with the appropriate name (here mynewpdb) and user name and password (here mynewadm/password), pass the following command:

  4. Alter the database by running the following command in SQL*Plus® to open the database in the read-write mode:

  5. Grant the required access to the admin users of the pluggable database. The minimum access that the admin users require to work with the database are to:

    • Create sessions,
    • Create tables,
    • Create views, 
    • Create sequences, and  
    • Access unlimited tablespace.

    Following is the sample command for achieving this in SQL*Plus®:

    sqlplus mynewadm/password@localhost:1521/ as sysdba
    SQL> grant CREATE SESSION to mynewadm;
    SQL> grant CREATE TABLE to mynewadm;
    SQL> grant CREATE VIEW to mynewadm;
    SQL> grant CREATE SEQUENCE to mynewadm;
    SQL> grant UNLIMITED TABLESPACE to mynewadm;
  6. Configure JDBC connectivity manually. For more information on connecting to JDBC, see Configure JDBC connectivity in Configuring Adobe Experience Manager Forms On JEE On WebLogic Cluster.

    1. Before clicking Test Configuration, update the JDBC URL for both RM_DS and IDP_DS. Replace : (colon) in the URL with a / (forward slash). For example: 

    2. Click Test Configuration to verify the pluggable database connectivity.