Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Oracle Content DB Administration Concepts

• About Oracle Content DB System Administration
  • Skills Required to Administer Oracle Content DB
  • Administrative Accounts
  • Oracle Content DB Administration Tools
    • Application Server Control
      • Accessing the Oracle Content DB Home Page
    • Oracle Content DB Administration Mode
    • Other Oracle Application Server Tools
  • Oracle Content DB System Administration Tasks Not Covered in This Guide
• Oracle Content DB Architecture
  • Oracle Content DB Web Services
  • Oracle Content DB Application Architecture
  • Oracle Content DB Domain
    • Oracle Content DB Nodes
    • Services, Servers, and Agents
  • Oracle Content DB User Repository
  • Oracle Content DB Site
• About the Oracle Content DB Protocol Servers
  • Using WebDAV with Oracle Content DB
• Integration with Key Oracle Technologies
  • Integration with Oracle Database
    • Oracle Database and the Oracle Content DB Schema
    • Oracle Text
    • Oracle Streams Advanced Queueing
    • Oracle Real Application Clusters (Oracle RAC)
  • Integration with Oracle Application Server
    • Oracle Containers for J2EE (OC4J)
    • Oracle Process Manager and Notification Server (OPMN)
    • Oracle Enterprise Manager
    • Oracle BPEL Process Manager
      • About BPEL
    • Oracle Workflow
• A Note for Windows Platforms

2 Planning for Oracle Content DB Deployment

• Oracle Content DB Deployment Configurations
  • Single-Computer Deployment
  • Multiple-Computer Deployment
  • High Availability Considerations
    • Best Practices for High Availability of Agents in a Multiple Middle Tier Environment
• Oracle Content DB Sizing Guidelines
  • Hardware Requirements
  • Sizing Formulas for Each Middle-Tier Computer
    • Number of CPUs
    • Required Usable Disk Space
    • Total Computer Memory, HTTP as the Primary Protocol
    • Total Computer Memory, Primary Protocol Other Than HTTP
  • Sizing Formulas for the Database Computer
    • Number of CPUs
    • Required Usable Disk Space
    • Total Computer Memory
  • Memory Requirements: Sample Deployment
• Oracle Content DB Tablespaces
  • Data Types and Storage Requirements
  • Storing Files in an Oracle Database
  • Oracle Content DB Metadata and Infrastructure
  • Oracle Text
  • Disk Space Requirements: Sample Deployment

3 Oracle Content DB Security

• SSL Configuration for Oracle Content DB
  • Setting Up SSL for Client Connections to Oracle Content DB
  • Setting Up SSL Between Oracle Content DB and the User Repository
    • Setting Up Server Only SSL Between Oracle Content DB and Your LDAP Server
    • Setting Up Anonymous SSL Between Oracle Content DB and Your LDAP Server
• About User Authentication in Oracle Content DB
  • Authenticating as a Trusted Application Over Web Services
• Setting Up a Server Keystore for WS-Security
  • About Oracle Content DB Access to the Server Keystore
  • Configuring a Server Keystore
  • Importing Client Public Keys Into the Server Keystore
• Changing the Private Server Key and Keystore Passwords
  • Changing the Private Server Key Password
  • Changing the Keystore Password for WS-Security
  • Changing the LDAP Keystore Password
• Changing the Oracle Content DB Schema Password
• Security Considerations for HTTP/WebDAV
  • Network Channel Encryption
• Preventing Malicious Uploads
• Changing the Client Session Timeout Period
• Applying the Latest Critical Patch Updates to Oracle Content DB

4 Choosing Oracle Content DB Options

• Enabling Oracle Content DB Error Reporting and Site Quota Warning Notifications
• Setting Up Antivirus Integration
  • Setting Up SAVSE
  • Enabling Antivirus Functionality in Oracle Content DB
    • Enabling Antivirus Functionality and Setting the Maximum Number of Repair Attempts
    • Configuring the Virus Repair Agent
  • Excluding Formats from Being Scanned
  • Performance Implications of Scanning for Viruses
• Managing Storage Options
  • Data Aging and Archiving
    • Setting Up Data Aging
    • Setting Up Data Archiving
  • Specifying Storage Management Options
• Changing the Oracle Content DB Port Number
  • Changing the Port Number in Oracle HTTP Server
  • Changing the Port Number in Oracle Content DB
• Allowing Access to Oracle Content DB from Outside the Firewall
• Changing a Middle-Tier Host Name or IP Address
• Changing the Oracle Database URL
• Using Oracle Drive with Oracle Content DB
  • Setting Up an Administrator-Configured Installation of Oracle Drive
    • Configuring Oracle Drive Service Details For Your Users
      • Setting Up config.xml
      • Setting Up update.xml
      • Setting Up odrive.ini
    • Preparing for Deployment Using Active Directory
    • Deploying Oracle Drive Using Active Directory
    • Redeploying Oracle Drive
    • Removing Oracle Drive from User Workstations
  • Packaging Service Information with the Oracle Drive Executable
  • Installing Oracle Drive
• Customizing the New User Orientation

5 Managing Oracle Content DB Users

• Using Oracle Internet Directory with Oracle Content DB
  • Logging In to Oracle Content DB for the First Time
  • Managing Users in Oracle Internet Directory
• Using a Third-Party LDAP Server with Oracle Content DB
  • Logging In to Oracle Content DB for the First Time
  • Managing Users in a Third-Party LDAP Solution
• Using a File-Based User Repository with Oracle Content DB
  • Logging In to Oracle Content DB for the First Time
  • Using a File-Based User Repository with Multiple Oracle Content DB Middle Tiers
  • Managing Users in a File-Based User Repository
    • Using the Application Server Control to Manage Users
    • Using the OracleAS JAAS Provider Admintool to Manage Users
• User Provisioning in Oracle Content DB
• Deleting Users in Oracle Content DB
  • Running the deleteuser Script
  • What Happens to User Content When a User Is Deleted?
• Updating User Information in the Oracle Content DB Web Client
  • User Profile Information
  • User Preferences Information
  • Setting the First Name, Last Name, and E-mail Address Attributes

6 Using Custom BPEL Workflows in Oracle Content DB

• About Custom Workflows
  • About BPEL
• Creating Custom Workflows in Oracle BPEL Process Manager
• Registering Custom Workflows with Oracle Content DB
• Deleting Custom Workflows from Oracle Content DB

7 Managing Oracle Content DB Processes

• About the Oracle Content DB Domain
• Starting and Stopping the Oracle Content DB Domain
  • Starting the Domain
  • Restarting the Domain
  • Stopping the Domain
• Managing Nodes at Run Time
  • Starting, Stopping, and Restarting OC4J_Content Instances
  • Modifying Nodes at Run Time
• Managing Services at Run Time
  • Creating Services
    • Creating Services at Run Time
    • Permanently Adding Services to a Node
  • Modifying Run-Time Service Parameters
    • Changing the Service Configuration Used by the Service
  • Managing the Committed Data Cache
    • Making Run-Time Changes to Committed Data Cache Properties
  • Managing the Connection Pools
    • About the Statement Cache
    • Making Run-Time Changes to Connection Pool Properties
  • Deleting Services
    • Deleting Services at Run Time
    • Permanently Removing Services from a Node
• Managing Servers at Run Time
  • Creating Servers
    • Creating Servers at Run Time
    • Permanently Adding Servers to a Node
  • Starting, Stopping, Restarting, Suspending, and Resuming Servers
    • Ensuring Servers Are Started When the Node Is Started
  • Modifying Run-Time Server Parameters
    • Changing the Server Configuration Used by the Server
  • Reloading Servers
  • Deleting Servers
    • Deleting Servers at Run Time
    • Permanently Removing Servers from a Node
• Managing Oracle Content DB from the Command Line

8 Changing Oracle Content DB Configuration Settings

• Managing Domain Properties
  • Changing Domain Properties
• Managing Node Configurations
  • Modifying Node Configurations
  • Adjusting Java Parameters for Nodes
• Managing Service Configurations
  • About Service Configurations
  • Creating Service Configurations
  • Modifying Service Configurations
  • Deleting Service Configurations
• Managing Server Configurations
  • About Server Configurations
    • Changing Values of Inherited Properties
    • Viewing Inherited Properties
  • Creating Server Configurations
  • Modifying Server Configurations
  • Deleting Server Configurations

9 Monitoring Domain, Node, Service, and Server Performance

• Monitoring Node Performance
• Monitoring Service Performance
  • Logging Service Performance Information
• Monitoring Server Performance
• Viewing Logs
  • Oracle Content DB Logs
  • Viewing Oracle Content DB Logs from the Application Server Control
  • Changing the Log Level for Oracle Content DB Processes

10 Managing Oracle Content DB Formats

• About Formats
• Adding Formats
• Modifying Formats
• Deleting Formats
• Default Formats

11 Managing the Oracle Content DB Site

• About the Oracle Content DB Site
• Modifying Site Settings
• Granting the Security Administrator Role

12 Oracle Content DB Maintenance and Tuning

• Backup and Recovery
• Service Configurations and Java Memory Sizing
  • Calculating Xmx Settings
  • Adjusting Service Configuration Settings
• Performance Tuning
  • Running the Oracle Content DB analyze.sql Script
    • Restoring Prior Statistics
• Analyzing Performance Problems
  • If the Database Is Causing the Problem
  • If the Java Processes Are Causing the Problem
    • Viewing Cache Statistics and Changing Cache Settings
    • Viewing Connection Pool Statistics and Changing Connection Pool Settings

A Troubleshooting Oracle Content DB

• Solving General Administration Problems
• Solving Performance Problems

B Migrating Content to Oracle Content DB

• Migration Tasks
• Migrating Oracle Content DB Users
• Creating Oracle Content DB Libraries
  • Scripted Library Creation
• Migrating Oracle Content DB Content
  • How to Copy the Data

C Managing the Oracle Text Index

• Oracle Text Tablespaces and Disk Utilization
• Creating and Maintaining the Oracle Text Index
  • Maintaining the IFS_TEXT Index by Using the Oracle Text PL/SQL Packages
    • Sync Job
    • Optimize Job
    • Monitoring DBMS_JOBS
    • Changing or Removing the Default DBMS_JOBS
    • Manually Synchronizing and Optimizing IFS_TEXT
  • Monitoring Oracle Text Indexing of Oracle Content DB Documents
  • Indexing Non-Standard Content Types
• Modifying the Search Timeout Parameter
• Troubleshooting Oracle Text Problems

D Service Configuration Properties

E Server Configuration Properties

• Shared Properties
• Background Request Agent
• Cleanup Agent
• Content Agent
• Content Garbage Collection Agent
• Dangling Object AV Cleanup Agent
• Event Exchanger Agent
• Expiration Agent
• Folder Index Agent
• Folder Index Analyzer Agent
• Garbage Collection Agent
• HTTP Server
• Inbound Queue Listener Agent
• Lock Expiration Agent
• Most Recent Doc Agent
• Quota Agent
• Read Document Agent
• Reassign Quota Agent
• Refresh Security Agent
• Service Warmup Agent
• Service Watchdog Agent
• Statistics Agent
• User Connect Agent
• Version Purge Agent
• Virus Repair Agent

F Oracle Content DB Globalization Support

• How to Choose the Database Character Set for Oracle Content DB
• How to Ensure Documents Are Properly Indexed in Oracle Content DB
  • Character Set
  • Language
• Globalization and the Oracle Content DB Protocols
• Character Sets Supported in Oracle Content DB
• Document Languages Supported in Oracle Content DB

Glossary

Index