5.4.2 Configuring Oracle for Adobe-preconfigured JBoss

1. Open the [appserver root] \standalone\configuration\lc_turnkey.xml file in a text editor and locate this line:

   <connection-url>jdbc:oracle:thin@localhost:1521:adobe</connection-url> 
   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> 

2. Replace the following text from the above line with values that are specific to your database:

   • localhost: The name, IP address, or fully-qualified path of the computer that hosts the database. The default is localhost .

   • 1521: The port used to access the database. The default port is 1521 .

   • adobe: The SID of the database that stores the AEM forms on JEE data. Replace the default value, adobe , with your database SID.

3. In the lines that follow the <connection-url> settings, locate the user-name and password settings and replace the default values with the user name and password that the application server uses to access your database.

4. (Only for Oracle RAC) Replace the connection URL mentioned in step 1 with the following connection URL:

   jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=broken) (ADDRESS_LIST=(ADDRESS= (PROTOCOL=TCP) (HOST=yourhost1) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP) (HOST=yourhost2) (PORT=1521)) (LOAD_BALANCE=on) (FAILOVER=on)) (CONNECT_DATA=(SERVER=dedicated) (SERVICE_NAME=service.yourcompany.com) (FAILOVER_MODE=(TYPE=session) (METHOD=basic) (RETRIES=10) (DELAY=3))))

   Note: Ensure that this entry appears as a single line in the adobe-ds.xml file.

5. (Only for Oracle RAC) Replace the following text from the connection URL in step 4 with values that are specific to your database:

   • yourhost1: The name, IP address, or fully-qualified domain name of the first node in the cluster that hosts the database.

   • yourhost2: The name, IP address, or fully-qualified domain name of the second node in the cluster that hosts the database.

     Note: The cluster hosting the database could have n nodes. yourhost1 and yourhost2 are examples in the case of a two-node cluster.

   • service.yourcompany.com: The service name for the Oracle RAC database.

6. Ensure that the minimum and maximum values for the data source connections are set as follows:

   • For IDP_DS:

     <min-pool-size>1</min-pool-size> 
     <max-pool-size>30</max-pool-size>

   • For EDC_DS:

     <min-pool-size>1</min-pool-size> 
     <max-pool-size>30</max-pool-size>

     Note: If your AEM forms on JEE server handles heavy load, increase the number of maximum JDBC connections to ensure that all jobs are processed. In such cases, increase <max-pool-size> to 50 or more for both IDP_DS and EDC_DS.

7. Save and close the file.

If you are running AEM forms on JEE with an Oracle database, you must set Oracle as the default data source for JBoss. This procedure assumes that the Oracle JDBC driver is installed in the [appserver root] /standalone/configuration directory.

1. Open the [appserver root] /standalone/configuration/lc_turnkey.xml file in a text editor and modify the <datasource> element with your Oracle connection settings:

   <jndi-name>DefaultDS</jndi-name> 
   <connection-url>jdbc:oracle:thin@localhost:1521:adobe</connection-url> 
   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> 
   <security-domain>OracleDbRealm</security-domain>

2. Replace the bold text in the above lines with values that are specific to your database:

   localhost: Replace this value with the host name of your Oracle server.

   1521: If Oracle is not using the default port, replace this value with the appropriate port number.

   adobe : Replace this value with your database SID.

3. In the lines that follow the <connection-url> settings, locate the user-name and password settings and replace the default values with the user name and password that the application server uses to access your database.

4. (Only for Oracle RAC) Replace the connection settings mentioned in the first step with the following connection URL:

   jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=broken) (ADDRESS_LIST=(ADDRESS= (PROTOCOL=TCP) (HOST=yourhost1) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP) (HOST=yourhost2) (PORT=1521)) (LOAD_BALANCE=on) (FAILOVER=on)) (CONNECT_DATA=(SERVER=dedicated) (SERVICE_NAME=service.yourcompany.com) (FAILOVER_MODE=(TYPE=session) (METHOD=basic) (RETRIES=10) (DELAY=3))))

   Note: Ensure that this entry appears as a single line in the oracle-ds.xml file.

5. (Only for Oracle RAC) Replace the following text from the connection URL in the previous step with values that are specific to your database:

   • yourhost1: The name, IP address, or fully-qualified domain name of the first node in the cluster that hosts the database.

   • yourhost2: The name, IP address, or fully-qualified domain name of the second node in the cluster that hosts the database.

     Note: The cluster hosting the database could have n nodes. yourhost1 and yourhost2 are examples in the case of a two-node cluster.

   • service.yourcompany.com: The service name for the Oracle RAC database.

6. Save and close the file.

1. Open the [appserver root] /standalone/configuration/lc_turnkey.xml file in a text editor and modify the following code within the <authentication> element:

   Replace  : 
    
   <security-domain name="EncryptDBPassword"> 
                       <authentication> 
                           <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required"> 
                               <module-option name="userName" value="adobe"/> 
                               <module-option name="password" value="5c2f412d6fa61722"/> 
                               <module-option name="managedConnectionFactoryName" value="jboss.jca:name=DefaultDS,service=LocalTxCM"/> 
                           </login-module> 
                       </authentication> 
                   </security-domain> 
             <security-domain name="EncryptDBPassword_IDP_DS"> 
                       <authentication> 
                           <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required"> 
                               <module-option name="userName" value="adobe"/> 
                               <module-option name="password" value="5c2f412d6fa61722"/> 
                               <module-option name="managedConnectionFactoryName" value="jboss.jca:name=IDP_DS,service=LocalTxCM"/> 
                           </login-module> 
                       </authentication> 
                   </security-domain> 
           <security-domain name="EncryptDBPassword_EDC_DS"> 
                       <authentication> 
                           <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required"> 
                               <module-option name="userName" value="adobe"/> 
                               <module-option name="password" value="5c2f412d6fa61722"/> 
                               <module-option name="managedConnectionFactoryName" value="jboss.jca:name=EDC_DS,service=LocalTxCM"/> 
                           </login-module> 
                       </authentication>

2. Replace the bold text with values that are specific to your database so that the application server can access your database.

   Note: For Oracle RAC, replace adobe with the service name specific to your database.

3. Save and close the file.

4. Start JBoss.