...

  1. Create a New JDBC Data Source.
  2. In WebLogic Adminstration Console, go to mydomain > Services > Data Sources.



  3. Select New > Generic Data Source.



  4. Enter the values as shown in the following table:

    Field Name

    Values

    Comments

    Name

    JDBC Data Source-0

    Name of the JDBC data source

    JNDI Name

    ModelHouseCT


    Database Type

    Oracle





  5. Click Next.
  6. Select values for the fields as mentioned in the following table:

    Field Name

    Values

    Comments

    Database Driver

    *Oracle's Driver (Thin) for Service Connections; Versions: Any



  7. Click Next and select the Emulate Two-Phase Commit check box checkbox.

  8. Click Next to configure the Connection Properties.
  9. Enter the values as mentioned in the following table:

    Field Name

    Sample Values

    Comments

    Database Name

    Database / SID name: SIR08875

    Database name in which the DB schema for CT is created.

    Host Name

    IP Address / Host name: 10.10.16.211

    The value is the Hostname / IP address of the Database server.

    Port

    Port Number: 1521

    The port number allocated for the Database communication for the IP / host name.

    Database User Name

    DB Schema Name: CT_MODEL_HOUSE

    Database schema name that is created for CT.

    Password DB

    Schema password: ****************

    Database schema password for CT.

    Confirm Password

    DB Schema password: ****************

    Database schema password for CT.


  10. Click Next.
  11. Click Test configuration to test the database availability and the connection properties that you have provided.



    Once the test is successful, the following message will appear:



  12. Click Finish.

...