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:
Note:
The following steps use ordb.corp.adobe.com as the container database name. Replace it with the your container database name.
-
Create a container database using noninteractive/silent mode of Database Configuration Assistant (DBCA).
-
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 ordb.corp.adobe.com -sid ordb.corp.adobe.com -createAsContainerDatabase true -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL
-
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:
SQL> CREATE PLUGGABLE DATABASE mynewpdb ADMIN USER mynewadm IDENTIFIED BY password FILE_NAME_CONVERT=('D:\app\oracle\oradata\ordb\pdbseed','D:\app\oracle\oradata\ordb\mynewpdb');
-
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/ordb.corp.adobe.com 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;
- Create sessions,
-
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.