7.2.1.2 XA Enabled Data Source

Follow the steps given below:
  1. Start the Administrative Console of Weblogic application server. You can start this by entering Oracle Weblogic Admin Console URL in the address bar in an internet browser.

    http://10.10.10.10:1001/console

    Eg: http://10.10.10.10:1001/consoleDescription of picture1.png follows
    Description of the illustration picture1.png

  2. Specify the Weblogic administrator user name and password. Click ‘Log In’.
  3. Navigate to Oracle Weblogic home page.Description of picture2.png follows
    Description of the illustration picture2.png
  4. Click ‘LOCK & EDIT’.

    Following screen is displayed:Description of picture3.png follows
    Description of the illustration picture3.png

  5. Expand ‘Services’ and then ‘Data Sources’ under it. Click ‘Lock & Edit’ buttonDescription of picture4.png follows
    Description of the illustration picture4.png
  6. To create a new data source, click ‘New’ and select ‘Generic Data Source’. The following screen is displayed.Description of picture5.png follows
    Description of the illustration picture5.png
  7. Specify the following details:
    JDBC Datasource Name Name of the data source
    JNDI Name JNDI name which will be used for lookup
    Database Type Type of the database which is Oracle
  8. Click ‘Next’.

    The following screen is displayed:Description of picture9.png follows
    Description of the illustration picture9.png

    Click next.

  9. Select the database driver as shown in the figure. Click ‘Next’.Description of picture10.png follows
    Description of the illustration picture10.png
  10. Specify the Database Name, Host Name, Port of the database server to connect, Database User Name and Password. Confirm the password.Description of picture11.png follows
    Description of the illustration picture11.png
  11. Click ‘Next’.

    The following screen is displayed.Description of picture12.png follows
    Description of the illustration picture12.png

  12. Specify the Driver Class Name (Eg: oracle.jdbc.OracleDriver).
  13. Specify the URL.
  14. jdbc:oracle:thin:@10.10.10.10:1001<INSTANCE_NAME>Specify the Database Username (Eg: FCPB1121) and password.
  15. Confirm the password.
  16. Click ‘Test Configuration’ tab.

    If the connection is established successfully, the message ‘Connection test succeeded’ is displayed.Description of picture13.png follows
    Description of the illustration picture13.png

  17. Click ‘Next’.

    The following screen is displayed:Description of picture14.png follows
    Description of the illustration picture14.png

  18. Check the boxes against the required servers. Click ‘Finish’. The following screen is displayed:Description of picture15.png follows
    Description of the illustration picture15.png
  19. Click ‘Activate Changes’ button. Click ‘Activate Changes’ button on the left pane. The message ‘All the changes have been activated. No restarts are necessary’ is displayed.Description of picture16.png follows
    Description of the illustration picture16.png
  20. The datasource has been created.
  21. Refer to “Resources_To_ Be_Created.doc” for the list of XA datasources to be created.