Sun Identity Manager 8.1 Installation

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

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

ProcedureTo 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:




      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)


      Specify the host name of Oracle DB server. 


      Specify the port (default is 1521) for the database server. 


      Specify the database account users name used in the connection. 


      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.

ProcedureTo 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:




    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.

ProcedureTo 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/
  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:


  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.)