1. Weblogic Configuration
  2. Create Resources on Weblogic
  3. Resource Administration
  4. Create Data Source
  5. XA Enabled Data Source

8.1.1.1 XA Enabled Data Source

This topic explains the systematic instructions to create the XA enabled data source in the Weblogic application server.

To create the XA enabled data source, follow the steps given below:
  1. Start the Administrative Console of the WebLogic application server. Enter the Oracle WebLogic Admin Console URL in the address bar in an internet browser. For example:http://10.10.10.10:1001/console
    Oracle Weblogic Server - Welcome screen is displayed.

    Figure 8-1 Oracle Weblogic Server - Welcome


    The image shows the Oracle Weblogic Login Screen. It displays several fields to specify the Oracle Weblogic Login.

  2. Specify the WebLogic administrator Username, Password and click Log In.
    Oracle Weblogic Server - Home Page screen is displayed.

    Figure 8-2 Oracle Weblogic Server - Home Page


    The image shows the Oracle Weblogic Home page Screen. It displays several fields to specify the Oracle Weblogic Home page.

  3. Under the Change Center, click on the Lock & Edit button.
  4. Go to Data Sources.
    Summary of JDBC Data Sources screen is displayed.

    Figure 8-3 Summary of JDBC Data Sources


    The image shows the JDBC Data Source. It displays several fields to specify the JDBC Data Source.

  5. On the left pane, under Domain Structure, expand Services and then Data Sources under it. Click the Lock & Edit button.
    Summary of JDBC Data Sources - Configuration screen is displayed.

    Figure 8-4 Summary of JDBC Data Sources - Configuration


    The image shows the Summary of JDBC Data Source. It displays several fields to specify the Summary of JDBC Data Source.

  6. To create a new data source, click New and select Generic Data Source from the drop-down.
    Create a New JDBC Data Source screen is displayed.

    Figure 8-5 Create a New JDBC Data Source


    The image shows the Summary of JDBC Data Source. It displays several fields to specify the Summary of JDBC Data Source.

  7. On the Create a New JDBC Data Source screen, specify the fields.

    Table 8-2 Create a New JDBC Data Source

    Field Description
    JDBC Datasource Name Name of the data source.
    JNDI Name JNDI name which will be used for lookup.
    Database Type Specify the database type as Oracle from the drop-down list.
  8. Click Next.
    Create a New JDBC Data Source - JDBC Data Source Properties screen is displayed.

    Figure 8-6 Create a New JDBC Data Source - JDBC Data Source Properties


    The image shows the Create a New JDBC Data Source. It displays several fields to specify the Create a New of JDBC Data Source.

  9. Select the database driver from the drop-down list and click Next.
    Create a New JDBC Data Source - Transaction Options screen is displayed.

    Figure 8-7 Create a New JDBC Data Source - Transaction Options


    The image shows the Create a new JDBC Data Source. It displays several fields to specify the Create a new of JDBC Data Source.

  10. On the Create a New JDBC Data Source - Connection Properties screen, specify the Database Name, Host Name, Port of the database server to connect, Database User Name, Password. and Confirm password.
    Create a New JDBC Data Source - Connection Properties screen is displayed.

    Figure 8-8 Create a New JDBC Data Source - Connection Properties


    The image shows the Create a new JDBC Data Source. It displays several fields to specify the Create a new of JDBC Data Source.

  11. Click Next.
    Create a New JDBC Data Source - Test Database Connection screen is displayed.

    Figure 8-9 Create a New JDBC Data Source - Test Database Connection


    The image shows the Summary of JDBC Data Sources - New Data Source Screen. It displays several fields to specify the Summary of JDBC Data Sources - New Data Source.

  12. Specify the Driver Class Name (Eg: oracle.jdbc.OracleDriver).
  13. Specify the URL as jdbc:oracle:thin:@10.10.10.10:1001<INSTANCE_NAME>.
    If the target database is Autonomous Database then, the URL Format to connect to Autonomous Database must be as follows: Jdbc:oracle:thin:@<Database Service Connect string >?TNS_ADMIN=<TNS ADMIN PATH>
  14. Specify the Database Username (Eg: FCPB1121) and password.
  15. Confirm the password.
  16. Click on Test Configuration button.
  17. If the connection is established successfully, the message Connection test succeeded is displayed.
    Create a New JDBC Data Source - Messages screen is displayed.

    Figure 8-10 Create a New JDBC Data Source - Messages (TBD Redwood)


    The image shows the Create a new JDBC Data Source. It displays several fields to specify the Create a new of JDBC Data Source.

  18. Click Next.
    Create a New JDBC Data Source - Select Targets screen is displayed.

    Figure 8-11 Create a New JDBC Data Source - Select Targets


    The image shows the Summary of JDBC Data Sources Screen. It displays several fields to specify the Summary of JDBC Data Source.

  19. Check the boxes against the required servers and click Finish.
    Summary of JDBC Data Sources - New Data Source screen is displayed.

    Figure 8-12 Summary of JDBC Data Sources - New Data Source


    The image shows the Summary of JDBC Data Sources Screen. It displays several fields to specify the Summary of JDBC Data Source.

  20. Click the Activate Changes button on the left pane. The message All the changes have been activated. No restarts are necessary is displayed.
    Summary of JDBC Data Sources - Activate Changes Message screen is displayed.

    Figure 8-13 Summary of JDBC Data Sources - Activate Changes Message


    The image shows the Summary of JDBC Data Sources Screen. It displays several fields to specify the Summary of JDBC Data Source.

  21. Refer to unresolvable-reference.html#GUID-74C0D61B-7D45-4776-99C2-8D9829E74773 for the list of XA data sources to be created.
New Data Source is created.

Parent topic: Create Data Source