Managing Oracle WebLogic Integration Solutions

     Previous  Next    Open TOC in new window    View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

Configuring a Production Database

Configure the database to include the tables required by Oracle WebLogic Integration, before you start preparing a production environment for Oracle WebLogic Integration. To allow your database administrator to manage the process, the tables required are not created automatically. This section provides information about the scripts available to create the tables.

The SQL scripts that create the database tables used by Oracle WebLogic Integration can be found in the following directory: 

	BEA_HOME\wli_10.2\dbscripts\vendor\

In this path, BEA_HOME represents the home directory, and vendor represents the vendor of the database you will be using in production mode. Table 2-1 describes the scripts.

Table 2-1 SQL Scripts and Descriptions
Script filename
Description
wli_runtime.sql
SQL that creates tables involved in Oracle WebLogic Integration runtime activity.
wli_runtime_drop.sql
SQL that drops tables created by wli_runtime.sql.

Note: All runtime data is destroyed.
wli_archive.sql
SQL that creates tables used to store Oracle WebLogic Integration data for reporting and analysis.
wli_archive_drop.sql
SQL that drops tables created by wli_archive.sql.

Note: All runtime data is destroyed.
upgrade_wli_runtime_sp4_9.2.sql
SQL that runs upgrade_wli_runtime_sp4_9.2.sql in order to have an additional wli table WLI_EVENTGEN_STATE in upgraded WLI 10.2 Domain.
worklist_runtime.sql
SQL that creates tables involved in Worklist runtime activity.
upgrade_worklist_runtime_8.5_9.0.sql
SQL that runs upgrade_worklist_run
worklist_runtime_drop.sql
SQL that drops tables created by worklist_runtime.sql.
worklist_reporting.sql
SQL that creates tables to store reports created by worklist.
worklist_reporting_drop.sql
SQL that drops report tables created by worklist.

Use your preferred SQL tool to run the scripts to create or drop the Oracle WebLogic Integration tables in your production database.

Note: In addition to the Oracle WebLogic Integration tables, you must also create the database tables that store conversational state information. For more information about database tables, see Preparing a Database.

If you have trading partner management data, you can use the Bulk Loader to import the information. Refer to Using the Trading Partner Bulk Loader.


  Back to Top       Previous  Next