3 Datasource Creation

This topic provides the systematic instruction to create datasource.

3.1 Create Datasource

Specify User ID and Password to login to Oracle WebLogic Administration Console.

Perform the following steps to create data source:

1. Start AdminServer and Node Manager.

   Note:

   Make sure that all the managed servers (targets) are in running mode.
2. On Domain Structure, click Services. Under Services, click Data Sources.
3. On the Data Sources (Filtered - More Columns Exist) table, click New and select Generic Data Source from drop-down list.
   The Summary of JDBC Data Sources screen displays.

   Figure 3-1 Summary of JDBC Data Source

   
   

   
   Description of "Figure 3-1 Summary of JDBC Data Source"

   
   
4. Specify the Name and JNDI Name on Create a New JDBC Data Source and click Next.
   The Create a New JDBC Data Source screen displays.

   Figure 3-2 Create a New JDBC Data Source

   
   

   
   Description of "Figure 3-2 Create a New JDBC Data Source"

   
   
5. On Database Driver, select Thin for Service Connections (Instant) from drop-down list and click Next.
   The Create a New JDBC Data Source - Database Driver screen displays.

   Figure 3-3 Create a New JDBC Data Source - Database Driver

   
   

   
   Description of "Figure 3-3 Create a New JDBC Data Source - Database Driver"

   
   
6. Uncheck the Supports Global Transactions and click Next.
   The Create a New JDBC Data Source - Transaction Options screen displays.

   Figure 3-4 Create a New JDBC Data Source - Transaction Options

   
   

   
   Description of "Figure 3-4 Create a New JDBC Data Source - Transaction Options"

   
   
7. Specify the required fields on Connection Properties.
   The Create a New JDBC Data Source - Connection Properties screen displays.

   Figure 3-5 Create a New JDBC Data Source - Connection Properties

   
   

   
   Description of "Figure 3-5 Create a New JDBC Data Source - Connection Properties"

   
   
8. Click Next to test connection.
   The Connection test succeeded message displays.

   Figure 3-6 Connection test succeeded - Message

   
   

   
   Description of "Figure 3-6 Connection test succeeded - Message"

   
   
9. Select the target Servers and Clusters to deploy the data source and click Next.

   Figure 3-7 Servers and Clusters

   
   

   
   Description of "Figure 3-7 Servers and Clusters"

   
   
10. Go to Summary of JDBC Data Sources.
11. On the Data Sources (Filtered - More Columns Exist) table, verify the JNDI Name and Targets.

    Figure 3-8 Summary of JDBC Data Source - Configuration

    
    

    
    Description of "Figure 3-8 Summary of JDBC Data Source - Configuration"

    
    
12. On the Change Center, click Activate Changes once the details are confirmed.
    All the changes are activated.

    Figure 3-9 Change Center

    
    

    
    Description of "Figure 3-9 Change Center"

    
    

    Figure 3-10 Changes - Success Message

    
    

    
    Description of "Figure 3-10 Changes - Success Message"