Database Administration Guide

Database Configuration Roadmap

Overview of Database Configuration for WebLogic Portal

Manually Creating Database Objects and JDBC Settings

Database Setup and Maintenance Overview

Character Sets and Sort Orders

Oracle

SQL Server

Sybase

DB2

Disk and Data Placement

Placement of Indexes

Data Storage for Tables with CLOB/BLOB/TEXT/IMAGE Data

Behavior Tracking

Reporting on Behavior Tracking data

Database Table Caching

Page and Block Size

Sybase Locking

Database Sizing

Behavior Tracking

Personalization

Portal Framework and WSRP

Content Management & Virtual Content Management (Versioning)

Content Search (Oracle)

Updating Database Statistics

Database Reorganizations

Database Backup and Recovery

Commerce Functionality in an XA Domain

WebLogic Portal Propagation Utility

Colocation of Database and WebLogic Portal

Using PointBase

PointBase Documentation

PointBase JAR Files

PointBase Tools

WebLogic Portal PointBase Databases

Administering the WebLogic Portal PointBase Database

Launching the PointBase Console from the Windows Start Menu

Launching the PointBase Console from the startPointBaseConsole Script

Using a Microsoft SQL Server Database

Configuring a Microsoft SQL Server Database

Manually Creating Database Objects

Manually Configuring Your Domain's JDBC Driver Settings

Creating a Separate Database for Behavior Tracking Events

Using an Oracle Database

Configuring an Oracle Database

Manually Creating Database Objects

Manually Configuring Your Domain's JDBC Driver Settings

Creating a Separate Database for Behavior Tracking Events

WebLogic Platform Support for Oracle9i RAC

Oracle 10g R2 Database Requires Manual Privilege Setup

Using a Sybase Database

Configuring a Sybase Database

Using a Supported Version

Defining an 8K Page Size

Running Upgrade Script for 7.0 to 8.1

Install and Configure the Sybase Client

Manually Creating Database Objects

Manually Configuring Your Domain's JDBC Driver Settings

Creating a Separate Database for Behavior Tracking Events

Using a DB2 Database

Configuring a DB2 Database

DB2 Configuration Parameter Minimum Settings

Manually Creating Database Objects

Manually Configuring Your Domain's JDBC Driver Settings

Creating a Separate Database for Behavior Tracking Events

Data Dictionary

Information Provided

Portal Database Components Covered

Behavior Tracking Database Objects

The BT_EVENT_TYPE Database Table

The BT_EVENT Database Table

The BT_EVENT_ACTION Database Table

Commerce Services Database Objects

Product Catalog Database Tables

The CATALOG_ENTITY Database Table

The CATALOG_PROPERTY_KEY Database Table

The CATALOG_PROPERTY_VALUE Database Table

The WLCS_CATEGORY Database Table

The WLCS_PRODUCT Database Table

The WLCS_PRODUCT_CATEGORY Database Table

The WLCS_PRODUCT_KEYWORD Database Table

Order and Discount Database Objects

The Order Processing Data Dictionary Tables

The DISCOUNT Database Table

The DISCOUNT_ASSOCIATION Database Table

The ORDER_ADJUSTMENT Database Table

The ORDER_LINE_ADJUSTMENT Database Table

The WLCS_CREDIT_CARD Database Table

The WLCS_CUSTOMER Database Table

The WLCS_ORDER Database Table

The WLCS_ORDER_LINE Database Table

The WLCS_SAVED_ITEM_LIST Database Table

The WLCS_SECURITY Database Table

The WLCS_SHIPPING_ADDRESS Database Table

The WLCS_SHIPPING_METHOD Database Table

The WLCS_TRANSACTION Database Table

The WLCS_TRANSACTION_ENTRY Database Table

Personalization Database Objects

The Portal Personalization Database Tables

The GROUP_HIERARCHY Database Table

The GROUP_SECURITY Database Table

The USER_GROUP_CACHE Database Table

The USER_GROUP_HIERARCHY Database Table

The USER_PROFILE Database Table

The USER_SECURITY Database Table

The ENTITY Database Table

The PROPERTY_KEY Database Table

The PROPERTY_VALUE Database Table

The SEQUENCER Database Table

The WEBLOGIC_IS_ALIVE Database Table

Data Synchronization Database Objects

The DATA_SYNC_APPLICATION Database Table

The DATA_SYNC_ITEM Database Table

The DATA_SYNC_SCHEMA_URI Database Table

The DATA_SYNC_VERSION Database Table

WebLogic Portal Services Database Objects

The Portal Services Database Tables

The AD_BUCKET Database Table

The AD_COUNT Database Table

The PLACEHOLDER_PREVIEW Database Table

The MAIL_ADDRESS Database Table

The MAIL_BATCH Database Table

The MAIL_BATCH_ENTRY Database Table

The MAIL_HEADER Database Table

The MAIL_MESSAGE Database Table

The SCENARIO_END_STATE Database Table

Portal Framework Database Objects

The Portal Framework Database Tables

The PF_BOOK_DEFINITION Database Table

The PF_BOOK_GROUP Database Table

The PF_BOOK_INSTANCE Database Table

The PF_DESKTOP_DEFINITION Database Table

The PF_DESKTOP_INSTANCE Database Table

The PF_LAYOUT_DEFINITION Database Table

The PF_LOOK_AND_FEEL_DEFINITION Database Table

The PF_MARKUP_DEFINITION Database Table

The PF_MENU_DEFINITION Database Table

The PF_PAGE_DEFINITION Database Table

The PF_PAGE_INSTANCE Database Table

The PF_PLACEHOLDER_DEFINITION Database Table

The PF_PLACEMENT Database Table

The PF_PORTAL Database Table

The PF_PORTLET_CATEGORY Database Table

The PF_PORTLET_CATEGORY_DEFINITION Database Table

The PF_PORTLET_DEFINITION Database Table

The PF_PORTLET_INSTANCE Database Table

WSRP (Web Services for Remote Portlets) Objects

The PF_CONSUMER_PORTLETS Database Table

The PF_CONSUMER_PROPERTIES Database Table

The PF_CONSUMER_REGISTRY Database Table

The PF_PRODUCER_PROPERTIES Database Table

The PF_PRODUCER_REGISTRY Database Table

The PF_PROXY_PORTLET_INSTANCE Database Table

The PF_PORTLET_PREFERENCE Database Table

The PF_PORTLET_PREFERENCE_VALUE Database Table

The PF_SHELL_DEFINITION Database Table

The PF_THEME_DEFINITION Database Table

Content Management Database Objects

The Content Management Data Dictionary Tables

The CM_NODE Database Table

The CM_OBJECT_CLASS Database Table

The CM_PROPERTY Database Table

The CM_PROPERTY_CHOICE Database Table

The CM_PROPERTY_DEFINITION Database Table

Content Management Virtual Database Objects

The CMV_NODE Table

The CMV_NODE_ASSIGNED_ROLE Table

The CMV_NODE_VERSION Table

The CMV_PROPERTY Table

The CMV_VALUE Table

The CMV_NODE_VERSION_PROPERTY Table

Localization Database Objects

The Localization Dictionary Tables

The L10N_INTERSECTION Database Table

The L10N_LOCALE Database Table

The L10N_RESOURCE Database Table

The L10N_RESOURCE_TYPE Database Table

Tracked Anonymous User Database Objects

The Tracked Anonymous User Dictionary Tables

The P13N_ANONYMOUS_PROPERTY Database Table

The P13N_ANONYMOUS_USER Database Table

Entitlement Reference Database Objects

The Entitlement Reference Dictionary Tables

The P13N_ENTITLEMENT_APPLICATION Database Table

The P13N_ENTITLEMENT_POLICY Database Table

The P13N_ENTITLEMENT_RESOURCE Database Table

The P13N_ENTITLEMENT_ROLE Database Table

The P13N_DELEGATED_HIERARCHY Database Table

WebLogic Portal DDL Modules

Property Files and Database Scripts

The db_settings.properties file

Definitions Section

Database Parameters

Scripts to Create or Upgrade Databases