> Database Administration Guide

Database Administration Guide

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

Introduction

Introduction to Using Databases with WebLogic Portal

How This Guide Fits into the Portal Life Cycle

Database Configuration Overview

Overview of Enterprise-Quality Database Configuration for WebLogic Portal

Manually Creating Database Objects and JDBC Settings

Creating the GroupSpace Database

Creating Additional Content Management Databases

Database Setup and Maintenance Overview

Encrypting Passwords

Choosing Internationalization and Localization Settings

Changing the Language Settings in SQL Server

Supporting Unicode Languages in SQL Server

Choosing Character Sets and Sort Orders

Oracle

SQL Server

MySQL

Sybase

DB2

Performance Considerations

Collocating the Database and WebLogic Portal

Using Caching to Reduce Database Access

Caching Database Tables Using Database-Specific Settings

Improving Concurrency Using Sybase Locking

Improving Content Search Response Time for Oracle

Using Database Statistics for Table and Index Organization

Optimizing Table Data and Index Placement

Choosing Index Placement

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

Choosing Behavior Tracking Data Placement

Sizing Considerations

Database Sizing

Monitoring Behavior Tracking Tables

Monitoring Personalization Tables

Monitoring Portal Framework and WSRP Tables

Monitoring Content Management Database Tables

Monitoring Community Database Tables

Setting Page and Block Sizes

Setting BLOB/CLOB Data Type Size Limits

Performing Database Backup and Recovery

Propagating Portal Environments

Commerce JDBC Configuration Settings

Support for Asynchronous Proliferation Requires XA

Note About Creating or Refreshing Database Objects

Using PointBase

PointBase Documentation

PointBase JAR Files

PointBase Tools

WebLogic Portal PointBase Databases

PointBase Database Size Restriction

Administering the WebLogic Portal PointBase Database

Launching the PointBase Console from the Windows Start Menu

Launching the PointBase Console from the startPointBaseConsole Script

Using Microsoft SQL Server

Configuring Microsoft SQL Server Databases

Configuring the Main WebLogic Portal Database

Configuring the GroupSpace Database

Manually Creating a Separate Database and Database Objects for Behavior Tracking

Database Scripts and Usage Notes

Using MySQL

Configuring MySQL Databases

Configuring the Main WebLogic Portal Database

Configuring the GroupSpace Database

Manually Creating a Separate Database and Database Objects for Behavior Tracking

Database Scripts and Usage Notes

Using Oracle

Configuring Oracle Databases

Configuring the Main WebLogic Portal Database

Configuring the GroupSpace Database

Manually Creating a Separate Database and Database Objects for Behavior Tracking

Database Scripts and Usage Notes

Using WebLogic Portal with Oracle RAC

Supported Configuration

Configuration Considerations for Oracle RAC

Multi-Data Source vs. Oracle Thin Driver

Fail-over vs. Load-Balancing

XA Considerations

Supported Configurations

Procedure for Using Oracle RAC with WebLogic Portal

Sample Configuration Files

Using Sybase

Configuring Sybase Databases

Configuring the Main WebLogic Portal Database

Configuring the GroupSpace Database

Manually Creating a Separate Database and Database Objects for Behavior Tracking

Database Scripts and Usage Notes

Using DB2

Configuring DB2 Databases

Configuring the Main WebLogic Portal Database

Configuring the GroupSpace Database

Manually Creating a Separate Database and Database Objects for Behavior Tracking

Database Scripts and Usage Notes

Data Dictionary

Personalization Database Objects

Base Personalization Database Tables

USER_PROFILE Database Table

ENTITY Database Table

PROPERTY_KEY Database Table

PROPERTY_VALUE Database Table

SEQUENCER Database Table

USERS Database Table

GROUPS Database Table

GROUPMEMBERS Database Table

P13N_QUIESCENT_STATE Database Table

P13N_LEASE Database Table

Credential Service Dictionary Tables

P13N_CREDENTIAL Database Table

P13N_CREDENTIAL_APPLICATION Database Table

P13N_CREDENTIAL_MASTER Database Table

P13N_CREDENTIAL_METADATA Database Table

Job Scheduler Dictionary Tables

P13N_JOB_DEFINITION Database Table

P13N_JOB_LISTENER Database Table

P13N_JOB_PARAMETER Database Table

P13N_JOB_RUN_HEADER Database Table

P13N_JOB_RUN_DATA Database Table

Entitlement Reference Dictionary Tables

P13N_ENTITLEMENT_APPLICATION Database Table

P13N_ENTITLEMENT_POLICY Database Table

P13N_ENTITLEMENT_RESOURCE Database Table

P13N_ENTITLEMENT_ROLE Database Table

P13N_DELEGATED_HIERARCHY Database Table

Tracked Anonymous User Dictionary Tables

P13N_ANONYMOUS_PROPERTY Database Table

P13N_ANONYMOUS_USER Database Table

Behavior Tracking Database Tables

BT_EVENT_TYPE Database Table

BT_EVENT Database Table

BT_EVENT_ACTION Database Table

Data Synchronization Database Tables

DATA_SYNC_APPLICATION Database Table

DATA_SYNC_ITEM Database Table

DATA_SYNC_SCHEMA_URI Database Table

DATA_SYNC_VERSION Database Table

Portal Services Database Objects

AD_BUCKET Database Table

AD_COUNT Database Table

PLACEHOLDER_PREVIEW Database Table

MAIL_ADDRESS Database Table

MAIL_BATCH Database Table

MAIL_BATCH_ENTRY Database Table

MAIL_HEADER Database Table

MAIL_MESSAGE Database Table

SCENARIO_END_STATE Database Table

Portal Framework Database Objects

Portal Framework Database Tables

PF_BOOK_DEFINITION Database Table

PF_BOOK_GROUP Database Table

PF_BOOK_INSTANCE Database Table

PF_DESKTOP_DEFINITION Database Table

PF_DESKTOP_INSTANCE Database Table

PF_LAYOUT_DEFINITION Database Table

PF_LOOK_AND_FEEL_DEFINITION Database Table

PF_MARKUP_DEFINITION Database Table

PF_MARKUP_XML Database Table

PF_MENU_DEFINITION Database Table

PF_PAGE_DEFINITION Database Table

PF_PAGE_INSTANCE Database Table

PF_PLACEHOLDER_DEFINITION Database Table

PF_PLACEMENT Database Table

PF_PORTAL Database Table

PF_PORTLET_CATEGORY Database Table

PF_PORTLET_CATEGORY_DEFINITION Database Table

PF_PORTLET_DEFINITION Database Table

PF_PORTLET_INSTANCE Database Table

PF_PORTLET_PREFERENCE Database Table

PF_PORTLET_PREFERENCE_VALUE Database Table

PF_PORTLET_USER_PROPERTIES Database Table

PF_SHELL_DEFINITION Database Table

PF_SHELL_PLACEMENT Database Table

PF_THEME_DEFINITION Database Table

PF_URL_COMPRESSION Database Table

Localization Dictionary Tables

L10N_INTERSECTION Database Table

L10N_LOCALE Database Table

L10N_RESOURCE Database Table

L10N_RESOURCE_TYPE Database Table

WSRP Portal Framework Database Objects

PF_CONSUMER_PORTLETS Database Table

PF_CONSUMER_PROPERTIES Database Table

PF_CONSUMER_REGISTRY Database Table

PF_PRODUCER_REGISTRY Database Table

PF_PROXY_PORTLET_INSTANCE Database Table

PF_PROXY_BOOK Database Table

PF_PROXY_PAGE Database Table

Communities Framework Database Objects

Communities Portal Framework Data Dictionary Tables

PF_COMMUNITY_DEFINITION Database Table

PF_COMMUNITY_MEMBER Database Table

PF_COMMUNITY_MEMBERSHIP Database Table

PF_MEMBERSHIP_CAPABILITY Database Table

PF_COMMUNITY_PROPERTY Database Table

PF_COMMUNITY_PROPERTY_VALUE Database Table

PF_FILE_TEMPLATE Database Table

PF_INVITATION Database Table

PF_INVITEE Database Table

PF_INVITEE_PROPERTY Database Table

PF_MESSAGING_ADDR Database Table

PF_NOTIFICATION Database Table

PF_NOTIFICATION_PAYLOAD Database Table

Content Management Database Objects

Content Management Data Dictionary Tables

CM_NODE Database Table

CM_COLLABORATION_API_METADATA Database Table

CM_OBJECT_CLASS Database Table

CM_PROPERTY Database Table

CM_PROPERTY_CHOICE Database Table

CM_PROPERTY_DEFINITION Database Table

CM_PROPERTY_TEXT Database Table

CM_WORKFLOW Database Table

Content Management Virtual Database Objects

Content Management Virtual Object Data Dictionary Tables

CMV_NODE Table

CMV_NODE_ASSIGNED_ROLE Table

CMV_NODE_VERSION Table

CMV_PROPERTY Table

CMV_VALUE Table

CMV_VALUE_TEXT Table

CMV_NODE_VERSION_PROPERTY Table

Scripts and Properties Files

WebLogic Portal DDL Modules

Content Management DDL Modules

Personalization DDL Modules

Using the database.properties File

Setting the Database Parameters in the Properties File

Scripts to Create the GroupSpace Repository Database

Scripts to Create an Additional Content Management Repository

Scripts to Manually Upgrade from Version 8.1, 9.2, or 10.0

Scripts to Drop Deprecated Compoze Database Tables

Scripts to Drop Deprecated RDBMS Authenticator Tables


  Back to Top       Previous  Next