9.6.1 Configuring Oracle database connectivity

To enable WebLogic Server and your LiveCycle deployment to connect to the Oracle 11g database, you must create a database connection for WebLogic Server by setting up a connection pool and a data source.

Create a new data source for Oracle on WebLogic 11g

  1. Start the WebLogic Administration Console by typing http://[hostname]:[port]/console in the URL line of a web browser.

  2. Type the user name and password that you created for the WebLogic Server domain and click Log In.

  3. Under Change Center, click Lock & Edit.

  4. Under Domain Structure, click Services > JDBC > Data Sources and, in the right pane, click New, and select Generic Data Source from the drop-down menu.

  5. On the next screen, set the following properties:

    • In the Name box, typeIDP_DS.

    • In the JNDI name box, type IDP_DS.

    • In the Database Type list, select Oracle and click Next.

    • In the Database Driver list, select Oracle's Driver(Thin) for Instance Connections; Versions:9.0.1 and later:

  6. Click Next and select Supports Global Transactions and Emulate Two-Phase Commit.

  7. Click Next and define the following properties that apply to the Oracle database that you created during your LiveCycle installation preparations:

    Database Name: The name of the database you have created.

    Host Name: The name or IP address of the computer on which Oracle is running.

    Port: Database Port. The default is 1521.

    Database User Name: The name of the user you created on the Oracle database.

    Password and Confirm Password: The password associated with the user.

  8. Click Next and then click Test Configuration to verify the configuration settings

    Note: If the test is successful, a “Connection test succeeded” message appears. Click Next. Otherwise, review the error message that appears and modify the settings as required until the test succeeds.
  9. On the next screen, select the server that the data source will connect to (in this case, the managed server) and then click Finish.

Configure the connection pool settings

  1. Under Domain Structure, click Services > JDBC > Data Sources and, in the right pane, click IDP_DS.

  2. On the next screen, click the Configuration tab and the Connection Pool tab.

  3. In the Maximum Capacity box, type 30.

  4. In the Statement Cache Size box, type 80.

  5. Click Save and then click Activate Changes.

  6. Restart WebLogic managed server.

Create a new data source for Oracle for Rights Management on WebLogic 11g

Note: This procedure applies only if you have Rights Management installed.
  1. Under Change Center, click Lock & Edit.

  2. Under Domain Structure, click Services > JDBC > Data Sources and, in the right pane, click New.

  3. On the next screen, set the following properties:

    • In the Name box, type RM_DS.

    • In the JNDI Name box, type EDC_DS.

    • In the Database Type list, select Oracle and click Next.

    • In the Database Driver list, select Oracle’s Driver (Thin) for Server Connections; Versions: 9.0.1,9.2.0,10,11

  4. Click Next and select Supports Global Transactions and One-Phase Commit.

  5. Click Next and define the following properties that apply to the Oracle database you created during your LiveCycle install preparations:

    Database Name: The name of the database you have created.

    Host Name: The name or IP address of the computer on which Oracle is running.

    Port: Database Port. The default is 1521.

    Database User Name: The name of the user you created on the Oracle database.

    Password and Confirm Password: The password associated with the user.

  6. Click Next and then click Test Configuration to verify the configuration settings.

    Note: If the test is successful, a “Connection test succeeded” message appears. Click Next. Otherwise, review the error message that appears and modify the settings as required until the test succeeds.
  7. On the next screen, select the server that the data source will connect to (in this case, the managed server) and then click Finish.

Configure the connection pool settings

  1. Under Domain Structure, click Services > JDBC > Data Sources and, in the right pane, click RM_DS.

  2. On the next screen, click the Configuration tab > Connection Pool tab, and set the following properties:

    • In the Initial Capacity box, type 1.

    • In the Maximum Capacity box, type 20.

    • In the Statement Cache Size box, type 80.

  3. Click Save and then click Activate Changes.

  4. Restart WebLogic managed server.

// Ethnio survey code removed