Database Administration Guide
|
 |
 |
|
 |
 |
Database Configuration Roadmap
This document helps you set up and start using a database management system (DBMS) with WebLogic Portal.
By default, you can run the code samples provided with WebLogic Portal using the PointBase DBMS. PointBase is a pure-Java relational database management system that BEA includes with WebLogic Platform to allow you to run code samples. It is supported only for the design, development, and verification of applications; it is not supported for production server deployment. For more information about PointBase, see Using PointBase.
To maximize the performance of your database configuration, refer to the database section of the WebLogic Portal Performance Tuning Guide, located at
http://download.oracle.com/docs/cd/E13218_01/wlp/docs81/perftune/index.html
Overview of Database Configuration for WebLogic Portal
Configuring a database for use with WebLogic Portal involves preparing the vendor database with several configuration scripts before connecting it to WebLogic Portal. Depending on your environment, the process may be entirely manual or you can use the WebLogic Configuration Wizard for part of the process.
To configure databases for use with WebLogic Portal, use the following steps.
- http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/index.html
- http://download.oracle.com/docs/cd/E13196_01/platform/docs81/interm/relnotes.html
- Create your vendor database(s). If you want to use behavior event tracking in a production environment, consider using a separate database for behavior event tracking.
- Prepare the database for use with WebLogic Portal. BEA provides several sample initialization scripts that you must modify and run on the vendor database before using the database with WebLogic Portal.
- After the database is configured, use the Configuration Wizard to create and load appropriate database objects and set JDBC driver settings at domain creation time. For more information about how to use the WebLogic Configuration Wizard, see http://download.oracle.com/docs/cd/E13196_01/platform/docs81/confgwiz/index.html.
You might want to perform this step manually under certain conditions; for details, see Manually Creating Database Objects and JDBC Settings.
Manually Creating Database Objects and JDBC Settings
In some cases, you may need to manually configure your database(s) without the use of the Configuration Wizard.
You can manually create database objects and JDBC settings in the following cases:
- When setting up your production database.
- If your desired database was not configured using the WebLogic Configuration Wizard.
- If after running the Configuration Wizard you decide to have your domain point to a different database.
- If you would like to refresh your database with the base configuration data that comes with the product.
- When you want to create only a subset of Portal database objects, for example to create only Behavior Tracking database objects for a particular database.
Note: BEA's database creation scripts first drop all database objects and then recreate them, which means all data added since your original installation will be lost. Upon completion of the database creation scripts, only the base configuration data that is needed for the product will exist.
