Configure a Data Source Using the Oracle WebLogic Server Administration Console

Use these steps to configure a data source using the Oracle WebLogic Server Administration Console.

The schema owner of the tables is defined in Create a Sample Schema for Users and Groups.

1. Log in to Oracle WebLogic Server Administration Console, navigate to the Change Center, click Lock & Edit.
2. Click Services and click Data Sources.
3. In the Summary of Data Sources page, click New, and select Generic Data Source.
4. In the JDBC Data Sources Properties page, enter or select values for the following properties:

   • Name - For example, enter: UserGroupDS

     The name used in the underlying configuration file (config.xml) and throughout the Administration Console whenever referring to this data source.

   • JNDI Name - For example, enter: jdbc/UserGroupDS

     The JNDI path to which this JDBC data source is bound.

   • Database Type - For example, select: Oracle

     The DBMS of the database that you want to connect to.

5. Click Next.
6. Select a database driver from the Database Driver list.

   For example, select: Oracle's Driver (Thin) for Service Connections; Releases:9.0.1 and later

7. Click Next.
8. Click Next.
9. On the Connection Properties page, enter values for the following properties:

   • Database Name - For example, enter: ora12c

     The name of the database that you want to connect to.

   • Host Name - For example, enter: mymachine.example.com

     The DNS name or IP address of the server that hosts the database.

   • Port - For example, enter: 1521

     The port on which the database server listens for connections requests.

   • Database User Name

   • Password/Confirm Password

     The password for the Database User Name.

10. Click Next.
11. Check the details on the page are correct, and click Test Configuration.
12. Click Next.
13. In the Select Targets page select the servers or clusters for deploying the data source.

    You should select the Administration Server and Managed server as your targets, for example:

    • In the Servers pane

      Select the AdminServer check box.

    • In the Clusters pane

      Select the bi_server1 option.

14. Click Finish.
15. In the Change Center, click Activate Changes.
16. Restart the system.