Configuring an Oracle Application Server Data Source for Identity Manager

Data source configuration can be performed entirely in the Oracle Enterprise Manager 10g Application Server Control Console. The online help in the Application Server Control Console provides useful information on data source settings.

Use the following procedure to update the repository configuration in Identity Manager to point to an Oracle Application Server Data Source.

This section is organized into the following sections:

• Create an Oracle Application Server Data Source

• To Create a JDBC Data Source

• To Point the Identity Manager Repository to the Data Source

Create an Oracle Application Server Data Source

This example procedure describes configuration steps to use an Oracle database driver. Specific entries you make will differ, depending on your database type.

To Create a Connection Pool

1. Log in to the Oracle 10g Application Server Control console (by default, http://localhost:port/me).

2. On the Cluster Topology page select View By Application Servers.

3. Click the OC4J home link, then on the OC4J:home page click the Administration link.

4. Click the Go to Task icon for Services -> JDBC Resources (Create/delete/view data sources and connection pools).

5. Under Connection Pools, click the Create button.

   1. Select idm from Application drop-down list

   2. Select the New Connection Pool radio button, then click Continue.

   3. On the Create Connection Pool page, configure the new connection pool as follows:

      Value	Action
      Name	Choose a unique name that identifies your connection pool. For example, IdmOraConnPool.
      Connection Factory Class	Use default value of oracle.jdbc.pool.OracleDataSource.
      JDBC URL	Specify jdbc:oracle:thin:@//hostname:1521/orcl (or fill in the Connection Information to have a URL generated for you)
      Hostname	Specify the host name of Oracle DB server.
      Port	Specify the port (default is 1521) for the database server.
      Username	Specify the database account users name used in the connection.
      Password	Specify the cleartext password for the account user.

   4. Click the Test Connection button to ensure connectivity.

   5. You may need to add additional properties on the Attributes and Properties pages depending on your installation. See the administrator’s guide for your target database.

6. Click the Finish button.

To Create a JDBC Data Source

1. On the JDBC Resources page, under Data Sources, click the Create button.

2. Select idm from Application drop-down list.

3. Select the Managed Data Source radio button.

4. Click the Continue button.

5. On the Create Data Source - Managed Data Source page, configure the JDBC Data Source as follows:

   Value	Action
   Name	Choose a unique name for this data source. For example, IdmOraDataSource
   JNDI Name	Specify the JNDI name. For example, jdbc/idmpool
   Transaction Level	Use the default value of Global & Local Transactions.
   Connection Pool	The name of the Connection Pool just created (IdmOraConnPool) should be displayed already. In this example we keep the default value.
   Login Timeout	Set as desired for your installation.

   It is not necessary to enter Username and Cleartext Password information in the Credentials section unless you need to override the information already provided in the connection pool configuration.

6. Click the Finish button.

   ---

   Note –

   The connection information is saved in your Oracle Application Server’s data-sources.xml file located in the $J2EE/home/application-deployments/idm directory.

   ---

To Point the Identity Manager Repository to the Data Source

1. Set the WSHOME environment variable to point to your Identity Manager installation. For example:

   set WSHOME=OracleAppServerInstallationDirectory/j2ee/home/applications/idm/idm

2. Make sure that the JAVA_HOME environment variable is set correctly. For example:

   set JAVA_HOME=/product/10.1.3.1/OracleAS_1/jdk

3. Create a CLASSPATH environment variable and set it to include the location of the oc4j-internal.jar file. This file is part of the application server distribution and is located here:

   OracleAppServerInstallationDirectory/j2ee/home/lib/oc4j-internal.jar

4. Change to the %WSHOME%\WEB-INF (Windows) or $WSHome/WEB-INF (UNIX) directory.

5. Make a backup of WEB-INF/ServerRepository.xml file and move it out of the directory. This is your direct connection setup from the original install of Identity Manager.

6. Point the repository to the new location using the Identity Manager lh command. For example:

   ../bin/lh setRepo -v -tOracle -icom.evermind.server.ApplicationInitialContextFactory -fjdbc/idmpool -n -oServerRepository.xml

   ---

   Note –

   The -f location flag should match the value you selected for the JNDI Name field.

   ---

7. If there are no reported errors, restart your Oracle Application Server to pick up the changes. (This also restarts the Identity Manager system.)