Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Oracle Content DB Administration Concepts

• About the Oracle Content DB System Administrator
  • Skills Required to Administer Oracle Content DB
  • Administrative Accounts
  • Oracle Content DB Administration Tools
    • Application Server Control
    • Grid Control
    • Oracle Content DB Administration Mode
    • Oracle Identity Management Tools
    • 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 Internet Directory
    • Provisioning Users in Oracle Content DB
    • Deleting Users
  • The Site Model
• 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 Application Server Containers for J2EE (OC4J)
    • Oracle Process Manager and Notification Server (OPMN)
    • Oracle Enterprise Manager
    • Oracle Internet Directory
    • Oracle BPEL Process Manager
      • About BPEL
    • Oracle Workflow

2 Planning for Oracle Content DB Deployment

• Oracle Content DB Deployment Configurations
  • Single-Computer Deployment
  • Multiple-Computer Deployment
  • High Availability Considerations
• 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

• User Authentication
• Security Considerations for Protocol Servers
  • FTP and FTPS
  • HTTP and WebDAV
  • Network Channel Encryption
• Malicious Uploads
• Client Session Timeout Period
• SSL Configuration for Oracle Content DB
  • Connecting to Oracle Internet Directory Using SSL
• Changing the Oracle Content DB Schema Password
• Oracle Records DB
  • Using a Retention Hardware Solution

4 Oracle Content DB Protocol Support

• About the Oracle Content DB Protocol Servers
• Using FTP with Oracle Content DB
  • Accessing Oracle Content DB Using FTP or FTPS
  • Enabling FTP
  • Enabling Anonymous FTP Access
    • Modifying the FTP Server Configuration
    • Enabling the Ability to Grant Public Access
    • Allowing Public Access to Oracle Content DB Folders
  • Enabling FTPS
    • Enabling the Explicit FTPS Server
    • Enabling the Implicit FTPS Server
• Using WebDAV with Oracle Content DB
  • Accessing Oracle Content DB Using WebDAV
• Authenticating Against WebDAV and FTP
• 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 from the Client CD

5 Choosing Oracle Content DB Options

• Setting Up Oracle Records DB
  • Enabling Oracle Records DB
    • Enabling Oracle Records DB OC4J Instances
    • Activating Oracle Records DB HTTP Node Configurations
    • Activating the Records DB Lifecycle Agent
  • Configuring Metrics Related to Oracle Records DB
• Setting Up Antivirus Integration
  • Setting Up SAVSE
  • Enabling Antivirus Functionality in Oracle Content DB
  • 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
  • Near-Line Storage for Records
    • Setting Up Near-Line Storage for Records
  • Specifying Storage Management Options
• Integrating with Solutions for Records Management Retention
  • Configuring Oracle Content DB for Network Appliance SnapLock
    • Configuring the Database Computer for Network Appliance SnapLock
    • Configuring the Middle-Tier Computer for Network Appliance SnapLock
  • Configuring Oracle Content DB for EMC Centera
    • Installing the EMC Centera Software
    • Setting Domain Properties for EMC Centera
    • Specifying Credential Information for EMC Centera
• Changing the Oracle Content DB Port Number
  • Changing the Port Number in Oracle HTTP Server
  • Changing the Port Number in OracleAS Web Cache
  • Registering the New Port with OracleAS Single Sign-On
  • Changing the Port Number in Oracle Content DB
  • Updating Metric Configuration URLs
• Allowing Access to Oracle Content DB from Outside the Firewall
• Changing a Middle-Tier Host Name or IP Address
• Customizing the New User Orientation

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
  • Enabling BPEL Workflow Creation in Oracle Content DB
  • Registering Custom Workflows
• 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
  • Using the Application Server Home Page to Start and Stop Oracle Content DB
• Managing Nodes at Run Time
  • Starting, Stopping, and Restarting Nodes
  • Modifying Nodes at Run Time
  • Deactivating Nodes
• 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
  • Creating Regular Node Configurations
  • Creating HTTP Node Configurations
  • Modifying Node Configurations
  • Deleting Node Configurations
  • Configuring Node Loggers
    • Configuring Loggers from the Node Page
    • Configuring Loggers by Modifying the Node Configuration
• 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 Domain Performance
  • About Oracle Content DB Performance Metrics
  • Viewing Performance Information
    • Using the All Metrics Link
    • Using the Domain Performance & Statistics Pages
  • Configuring Performance Metrics
• Monitoring Node Performance
• Monitoring Service Performance
  • Logging Service Performance Information
• Monitoring Server Performance
• Viewing Logs
  • Oracle Content DB Logs
    • The Node Log
    • The Application Log
    • Log for changehostname Script
  • Viewing Oracle Content DB Logs from the Application Server Control
• Accessing Metrics and Monitoring Metric Alerts
  • Installing the Grid Control and Oracle Management Agent
  • Setting the Management Agent Classpath
  • Accessing the Grid Control
  • Changing the Default Metric Collection Behavior
    • Reconfiguring Oracle Content DB (oracle_files) Targets in the Grid Control
  • Viewing Oracle Content DB Metrics in the Grid Control
  • Metric Thresholds and Metric Collection Intervals
    • Metric Collection Intervals

10 Managing Oracle Content DB Formats

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

11 Managing Oracle Content DB Sites

• About Sites
• Creating Sites
• Modifying Sites
• Granting the Security Administrator Role
• Enabling and Disabling Sites
• Deleting Sites

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 Problems with Oracle Content DB Protocols
• 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
• Audit Event Dispatch Agent
• Audit Event Handler Agent
• Background Request Agent
• Cleanup Agent
• Content Agent
• Content Garbage Collection Agent
• Dangling Object AV Cleanup Agent
• Event Exchanger Agent
• Event Handler Agent
• Expiration Agent
• Folder Index Agent
• Folder Index Analyzer Agent
• FTP Server
• FTPS Server - Explicit
• FTPS Server - Implicit
• Garbage Collection Agent
• HTTP Server
• Inbound Queue Listener Agent
• Lock Expiration Agent
• Most Recent Doc Agent
• Oracle Event Handler Agent
• Oracle Internet Directory Credential Manager Agent
• Quota Agent
• Read Document Agent
• Reassign Quota Agent
• Records DB HTTP Server
• Records DB Lifecycle Agent
• Refresh Security Agent
• Secure Enterprise Search Group Agent
• Service Warmup Agent
• Service Watchdog Agent
• Statistics Agent
• Version Purge Agent
• Virus Repair Agent

F FTP Quote Command Reference

• SETCHARACTERSET
• SETCOMMANDCHARACTERSET
• SETLANGUAGE
• SHOWCHARACTERSET
• SHOWLANGUAGE

G 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
  • FTP
• Character Sets Supported in Oracle Content DB
• Document Languages Supported in Oracle Content DB

Glossary

Index