Skip Headers
Oracle® Fusion Middleware Database Administration Guide for Oracle WebLogic Portal
10
g
Release 3 (10.3.5)
Part Number E14233-03
Home
Contact Us
Next
View PDF
Contents
List of Examples
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction
1.1
Introduction to Using Databases with WebLogic Portal
1.2
How This Guide Fits into the Portal Life Cycle
2
Database Configuration Overview
2.1
Overview of Enterprise-Quality Database Configuration for WebLogic Portal
2.2
Manually Creating Database Objects and JDBC Settings
2.2.1
Creating Additional Content Management Databases
3
Database Setup and Maintenance Overview
3.1
Encrypting Passwords
3.2
Choosing Internationalization and Localization Settings
3.2.1
Changing the Language Settings in SQL Server
3.2.2
Supporting Unicode Languages in SQL Server
3.2.3
Choosing Character Sets and Sort Orders
3.2.3.1
Oracle
3.2.3.2
SQL Server
3.2.3.3
MySQL
3.2.3.4
Sybase
3.2.3.5
DB2
3.3
Performance Considerations
3.3.1
Collocating the Database and WebLogic Portal
3.3.2
Using Caching to Reduce Database Access
3.3.3
Caching Database Tables Using Database-Specific Settings
3.3.4
Improving Concurrency Using Sybase Locking
3.3.5
Improving Content Search Response Time for Oracle
3.3.6
Using Database Statistics for Table and Index Organization
3.3.7
Optimizing Table Data and Index Placement
3.3.7.1
Choosing Index Placement
3.3.7.2
Choosing Data Storage for Tables with CLOB/BLOB/TEXT/IMAGE Data
3.3.7.3
Choosing Behavior Tracking Data Placement
3.4
Sizing Considerations
3.4.1
Database Sizing
3.4.1.1
Monitoring Behavior Tracking Tables
3.4.1.2
Monitoring Personalization Tables
3.4.1.3
Monitoring Portal Framework and WSRP Tables
3.4.1.4
Monitoring Content Management Database Tables
3.4.1.5
Monitoring Community Database Tables
3.4.2
Setting Page and Block Sizes
3.4.3
Setting BLOB/CLOB Data Type Size Limits
3.5
Performing Database Backup and Recovery
3.6
Propagating Portal Environments
3.7
Support for Asynchronous Proliferation Requires XA
3.8
Note About Creating or Refreshing Database Objects
4
Using Microsoft SQL Server
4.1
Configuring Microsoft SQL Server Databases
4.2
Configuring the Main WebLogic Portal Database
4.3
Manually Creating a Separate Database and Database Objects for Behavior Tracking
4.4
Database Scripts and Usage Notes
5
Using Derby
5.1
About Derby
5.2
Derby Documentation
6
Using MySQL
6.1
Configuring MySQL Databases
6.2
Configuring the Main WebLogic Portal Database
6.3
Manually Creating a Separate Database and Database Objects for Behavior Tracking
6.4
Database Scripts and Usage Notes
7
Using Oracle
7.1
Configuring Oracle Databases
7.2
Configuring the Main WebLogic Portal Database
7.3
Manually Creating a Separate Database and Database Objects for Behavior Tracking
7.4
Database Scripts and Usage Notes
7.5
Using WebLogic Portal with Oracle RAC
7.5.1
Supported Configuration
7.5.2
Configuration Considerations for Oracle RAC
7.5.2.1
Multi-Data Source vs. Oracle Thin Driver
7.5.2.2
Fail-over vs. Load-Balancing
7.5.2.3
XA Considerations
7.5.2.4
Supported Configurations
7.5.3
Procedure for Using Oracle RAC with WebLogic Portal
7.5.4
Sample Configuration Files
8
Using Sybase
8.1
Configuring Sybase Databases
8.2
Configuring the Main WebLogic Portal Database
8.3
Manually Creating a Separate Database and Database Objects for Behavior Tracking
8.4
Database Scripts and Usage Notes
9
Using DB2
9.1
Configuring DB2 Databases
9.2
Configuring the Main WebLogic Portal Database
9.3
Manually Creating a Separate Database and Database Objects for Behavior Tracking
9.4
Database Scripts and Usage Notes
10
Data Dictionary
10.1
Personalization Database Objects
10.1.1
Base Personalization Database Tables
10.1.1.1
USER_PROFILE Database Table
10.1.1.2
ENTITY Database Table
10.1.1.3
PROPERTY_KEY Database Table
10.1.1.4
PROPERTY_VALUE Database Table
10.1.1.5
SEQUENCER Database Table
10.1.1.6
USERS Database Table
10.1.1.7
GROUPS Database Table
10.1.1.8
GROUPMEMBERS Database Table
10.1.1.9
P13N_QUIESCENT_STATE Database Table
10.1.1.10
P13N_LEASE Database Table
10.1.1.11
Credential Service Dictionary Tables
10.1.1.12
P13N_CREDENTIAL Database Table
10.1.1.13
P13N_CREDENTIAL_APPLICATION Database Table
10.1.1.14
P13N_CREDENTIAL_MASTER Database Table
10.1.1.15
P13N_CREDENTIAL_METADATA Database Table
10.1.1.16
Job Scheduler Dictionary Tables
10.1.1.17
P13N_JOB_DEFINITION Database Table
10.1.1.18
P13N_JOB_LISTENER Database Table
10.1.1.19
P13N_JOB_PARAMETER Database Table
10.1.1.20
P13N_JOB_RUN_HEADER Database Table
10.1.1.21
P13N_JOB_RUN_DATA Database Table
10.1.1.22
Entitlement Reference Dictionary Tables
10.1.1.23
P13N_ENTITLEMENT_APPLICATION Database Table
10.1.1.24
P13N_ENTITLEMENT_POLICY Database Table
10.1.1.25
P13N_ENTITLEMENT_RESOURCE Database Table
10.1.1.26
P13N_ENTITLEMENT_ROLE Database Table
10.1.1.27
P13N_DELEGATED_HIERARCHY Database Table
10.1.2
Tracked Anonymous User Dictionary Tables
10.1.2.1
P13N_ANONYMOUS_PROPERTY Database Table
10.1.2.2
P13N_ANONYMOUS_USER Database Table
10.1.3
Behavior Tracking Database Tables
10.1.3.1
BT_EVENT_TYPE Database Table
10.1.3.2
BT_EVENT Database Table
10.1.3.3
BT_EVENT_ACTION Database Table
10.1.4
Data Synchronization Database Tables
10.1.4.1
DATA_SYNC_APPLICATION Database Table
10.1.4.2
DATA_SYNC_ITEM Database Table
10.1.4.3
DATA_SYNC_SCHEMA_URI Database Table
10.1.4.4
DATA_SYNC_VERSION Database Table
10.2
Portal Services Database Objects
10.2.1
AD_BUCKET Database Table
10.2.2
AD_COUNT Database Table
10.2.3
PLACEHOLDER_PREVIEW Database Table
10.2.4
MAIL_ADDRESS Database Table
10.2.5
MAIL_BATCH Database Table
10.2.6
MAIL_BATCH_ENTRY Database Table
10.2.7
MAIL_HEADER Database Table
10.2.8
MAIL_MESSAGE Database Table
10.2.9
SCENARIO_END_STATE Database Table
10.3
Portal Framework Database Objects
10.3.1
Portal Framework Database Tables
10.3.1.1
PF_BOOK_DEFINITION Database Table
10.3.1.2
PF_BOOK_GROUP Database Table
10.3.1.3
PF_BOOK_INSTANCE Database Table
10.3.1.4
PF_DESKTOP_DEFINITION Database Table
10.3.1.5
PF_DESKTOP_INSTANCE Database Table
10.3.1.6
PF_LAYOUT_DEFINITION Database Table
10.3.1.7
PF_LOOK_AND_FEEL_DEFINITION Database Table
10.3.1.8
PF_MARKUP_DEFINITION Database Table
10.3.1.9
PF_MARKUP_XML Database Table
10.3.1.10
PF_MENU_DEFINITION Database Table
10.3.1.11
PF_PAGE_DEFINITION Database Table
10.3.1.12
PF_PAGE_INSTANCE Database Table
10.3.1.13
PF_PLACEHOLDER_DEFINITION Database Table
10.3.1.14
PF_PLACEMENT Database Table
10.3.1.15
PF_PORTAL Database Table
10.3.1.16
PF_PORTLET_CATEGORY Database Table
10.3.1.17
PF_PORTLET_CATEGORY_DEFINITION Database Table
10.3.1.18
PF_PORTLET_DEFINITION Database Table
10.3.1.19
PF_PORTLET_INSTANCE Database Table
10.3.1.20
PF_PORTLET_PREFERENCE Database Table
10.3.1.21
PF_PORTLET_PREFERENCE_VALUE Database Table
10.3.1.22
PF_PORTLET_USER_PROPERTIES Database Table
10.3.1.23
PF_SHELL_DEFINITION Database Table
10.3.1.24
PF_SHELL_PLACEMENT Database Table
10.3.1.25
PF_THEME_DEFINITION Database Table
10.3.1.26
PF_URL_COMPRESSION Database Table
10.3.2
Localization Dictionary Tables
10.3.2.1
L10N_INTERSECTION Database Table
10.3.2.2
L10N_LOCALE Database Table
10.3.2.3
L10N_RESOURCE Database Table
10.3.2.4
L10N_RESOURCE_TYPE Database Table
10.4
WSRP Portal Framework Database Objects
10.4.1
PF_CONSUMER_PORTLETS Database Table
10.4.2
PF_CONSUMER_PROPERTIES Database Table
10.4.3
PF_CONSUMER_REGISTRY Database Table
10.4.4
PF_PRODUCER_REGISTRY Database Table
10.4.5
PF_PROXY_PORTLET_INSTANCE Database Table
10.4.6
PF_PROXY_BOOK Database Table
10.4.7
PF_PROXY_PAGE Database Table
10.5
Communities Framework Database Objects
10.5.1
Communities Portal Framework Data Dictionary Tables
10.5.1.1
PF_COMMUNITY_DEFINITION Database Table
10.5.1.2
PF_COMMUNITY_MEMBER Database Table
10.5.1.3
PF_COMMUNITY_MEMBERSHIP Database Table
10.5.1.4
PF_MEMBERSHIP_CAPABILITY Database Table
10.5.1.5
PF_COMMUNITY_PROPERTY Database Table
10.5.1.6
PF_COMMUNITY_PROPERTY_VALUE Database Table
10.5.1.7
PF_FILE_TEMPLATE Database Table
10.5.1.8
PF_INVITATION Database Table
10.5.1.9
PF_INVITEE Database Table
10.5.1.10
PF_INVITEE_PROPERTY Database Table
10.5.1.11
PF_MESSAGING_ADDR Database Table
10.5.1.12
PF_NOTIFICATION Database Table
10.5.1.13
PF_NOTIFICATION_PAYLOAD Database Table
10.6
Content Management Database Objects
10.6.1
Content Management Data Dictionary Tables
10.6.1.1
CM_NODE Database Table
10.6.1.2
CM_COLLABORATION_API_METADATA Database Table
10.6.1.3
CM_OBJECT_CLASS Database Table
10.6.1.4
CM_PROPERTY Database Table
10.6.1.5
CM_PROPERTY_CHOICE Database Table
10.6.1.6
CM_PROPERTY_DEFINITION Database Table
10.6.1.7
CM_PROPERTY_TEXT Database Table
10.6.1.8
CM_WORKFLOW Database Table
10.7
Content Management Virtual Content Repository Database Objects
10.7.1
Content Management Virtual Object Data Dictionary Tables
10.7.1.1
CMV_NODE Table
10.7.1.2
CMV_NODE_ASSIGNED_ROLE Table
10.7.1.3
CMV_NODE_VERSION Table
10.7.1.4
CMV_PROPERTY Table
10.7.1.5
CMV_VALUE Table
10.7.1.6
CMV_VALUE_TEXT Table
10.7.1.7
CMV_NODE_VERSION_PROPERTY Table
10.8
RDBMS Security Store Tables
A
Scripts and Properties Files
A.1
WebLogic Portal DDL Modules
A.2
Content Management DDL Modules
A.3
Personalization DDL Modules
A.4
Using the database.properties File
A.4.1
Setting the Database Parameters in the Properties File
A.5
Scripts to Create an Additional Content Management Repository
A.6
Scripts to Manually Upgrade from Previous Versions
A.7
Scripts to Drop Deprecated Compoze Database Tables
A.8
Scripts to Drop Deprecated RDBMS Authenticator Tables
B
Database Schema Diagrams