Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Mail

1 Introduction to Oracle Mail Administration

• Overview of Oracle Mail
• Overview of Oracle Mail Administration
  • Oracle Collaboration Suite 10g WebMail Client
  • Oracle Enterprise Manager 10g Application Server Control Console for Collaboration Suite
  • Oracle Enterprise Manager 10g Grid Control Console
  • Oracle Mail Command-Line Utilities

2 Managing Oracle Mail Objects

• Managing Oracle Mail Users
  • Adding E-mail Users
  • Modifying E-mail User Attributes
  • Setting Default New User Attributes
  • Removing E-mail Users
  • Recovering Deleted Messages
• Managing Oracle Mail Domains
  • Creating Domains
  • Modifying Domain Settings
• Managing Distribution Lists
  • Setting Default Distribution List Attributes
  • Distribution List Parameters
  • Creating a Distribution List
  • Modifying Distribution List Properties
  • Modifying Default Distribution List Parameter Values
  • Deleting a Distribution List
  • Managing Distribution List Members
  • Showing All Distribution Lists to Which a User Subscribes
• Managing Aliases
  • Creating a New Alias
  • Editing Alias Attributes
  • Deleting Aliases
• Managing News Objects
  • Managing Peer Servers
    • Adding Peer Servers
    • Editing Peer Server Properties
    • Deleting Peer Servers
  • About Newsgroups
  • Managing Newsgroups
    • Adding Private Newsgroups
    • Editing Private Newsgroup Properties
    • Deleting Private Newsgroups
    • Adding Public Newsgroups
    • Editing Public Newsgroup Properties
    • Deleting Public Newsgroups

3 Oracle Mail Servers

• Oracle Collaboration Suite Database
  • Modifying Oracle Collaboration Suite Database Connection Parameters
• Managing Oracle Mail Servers and Instances
  • Log Files
  • Enabling and Disabling Servers
  • Starting, Stopping, Restarting, or Refreshing All Server Instances
  • Creating a Server Instance
  • Deleting a Server Instance
  • Modifying Server Instance Default Parameter Settings
  • Modifying Parameter Settings for a Specific Server Instance
• Protocol Servers
  • IMAP and POP Servers
    • IMAP and POP Server Architecture
    • IMAP and POP Session Data Flow
    • Oracle WebMail Client Session Data Flow
    • IMAP and POP Server Instance Parameters
    • Managing IMAP and POP Servers
  • SMTP Server
    • Various SMTP Configurations
    • SMTP Message Flow
    • SMTP Inbound Server Architecture
    • SMTP Outbound Server Architecture
    • SMTP Address Rewriting Rules
    • SMTP Server Parameters
    • Managing SMTP Servers
    • SMTP Routing Control
• Housekeeper Server
  • Configuring Housekeeper Tasks
    • Process Control Message Cleanup
    • Oracle Text
    • Tertiary Storage
  • Housekeeper Server Parameters
  • Managing Housekeeper
• List Server
  • List Server Mail Interface
  • Archiving Distribution List Posts
  • External Distribution Lists
  • Distribution List Digests
  • Distribution List Bounce Processing
  • Multiple Language Responses
  • Mail Merge
  • List Server Parameters
  • Managing List Servers
• NNTP Server
  • About News Servers
  • Controlling News Storage
  • Article Caching for Performance
  • NNTP Processes
    • NNTP Inbound Server
    • NNTP Outbound Server
  • NNTP Server Parameters
  • Managing NNTP Servers

4 Oracle Collaboration Suite 10g WebMail Client

• Oracle WebMail Client Overview
• Oracle WebMail Tool Kit Default Settings
• Oracle WebMail Client Properties
  • Oracle WebMail oc4j.properties File Properties
  • Service Registry Dependency
  • Configuring SSL Between Oracle WebMail and Oracle Internet Directory
• Oracle WebMail Client Log Files Location
• Oracle Mail Portlet API

5 Directory Cache

• About Directory Cache
  • Directory Cache Search Behavior
  • Directory Cache Default Behavior
  • Location of Directory Cache Logs
• Enabling Directory Cache

6 Oracle Mail Security

• Oracle Mail Security Overview
  • E-mail System Component Security
    • Information Storage Database
    • Oracle Collaboration Suite Applications Tier
    • Identity Management Infrastructure
    • Mail Clients
  • Network Security
  • Firewalls
  • Nontechnical Considerations
• SSL and TLS
• Antispam Methods
  • Third-Party Antispam Filters
  • Routing Control for SMTP
  • Routing Control for NNTP
  • Wildcards
  • Routing Control Parameters for NNTP and SMTP
• Symantec AntiVirus Scan Engine
  • Editing SAVSE Filters
  • Applying SAVSE Filters
• Virus Scrubber
  • Configuring the Virus Scrubber with the Oracle Enterprise Manager 10g Application Server Control Console for Collaboration Suite
• Virus Scanning and Removal Using PL/SQL Scripts
  • Usage Examples

7 Monitoring Oracle Mail

• Monitoring Oracle Mail Using Oracle Enterprise Manager 10g Grid Control Console
  • Overview of Oracle Mail Target Types
  • Identifying Oracle Mail Hosts and Databases
    • Identifying the Oracle Mail Component Hosts
    • Identifying Locations of Oracle Collaboration Suite Databases
    • Identifying the Connection String for an Oracle Collaboration Suite Database
  • About Oracle Mail Service Targets
    • Creating Oracle Mail Service Targets
    • Creating an Oracle WebMail Web Application Target
    • Creating the Oracle Mail Oracle Collaboration Suite Database Target
    • Creating the Oracle Internet Directory Client Target
    • Creating the E-mail Group Target
• Purging Monitoring Data from the Oracle Collaboration Suite Database
• Using oesmon and oeschart
  • Using oesmon
  • Using oeschart
    • Setting the Statistics Collection Interval
    • Cleaning Up Mail Statistics
    • Mail Statistics Schema
    • Creating Graphs
    • Displaying Graphs in Oracle Enterprise Manager

8 Oracle Mail Policies

• Overview of Oracle Mail Policies
• Managing Oracle Mail Filters
  • Creating a Filter
  • Editing Filters
  • Reordering Filters
  • Applying Filters
  • Editing Applied Filters
• Oracle Mail Routing Control
  • Configuring Routing Control for Incoming Mail
    • Configuring General Routing Control Settings for Incoming Mail
    • Configuring Reject Routing Control Settings for Incoming Mail
    • Configuring Trust Routing Control Settings for Incoming Mail
    • Configuring Advanced Routing Control Settings for Incoming Mail
    • Saving and Copying Routing Control Settings for Incoming Mail
  • Configuring Routing Control for Outgoing Mail
  • Configuring Routing Control for Incoming News
    • Configuring General Routing Control Settings for Incoming News
    • Configuring Reject Routing Control Settings for Incoming News
    • Configuring Trust Routing Control Settings for Incoming News
• Oracle Mail Archive Policies
  • Creating an Archive Policy
  • Editing an Archive Policy
  • Associating Users with an Archive Policy
  • Enabling Message Archiving
• Message Recall

9 Oracle Mail Server-Side Rules

• What Is a Server-Side Rule?
• Managing Server-Side Rules
  • Creating Server-Side Rules
    • Displaying Existing Server-Side Rules with oesrl
    • Creating Server-Side Rules with oesrl
    • Editing Server-Side Rules
    • Deleting Server-Side Rules
    • Creating Server-Side Rules Using an E-mail Client
  • How Server-Side Rules Are Stored
  • Order in Which Server-Side Rules Are Executed
• Server-Side Rule Examples

10 Backing Up and Recovering Oracle Mail

• Overview of Oracle Mail Backup and Recovery
• Backing Up and Recovering the Oracle Collaboration Suite Database
• Backing Up and Restoring User Data with oesbkp
• Recovering Messages with LogMiner
• Recovering Messages with Oracle Flashback Query
  • Using Oracle Flashback Query to Recover Messages
  • MAIL_RECOVERY_FQ Package

A Troubleshooting Oracle Mail

• Becoming Aware of a Problem
• End-User Issues
  • Problems with Mail Clients
    • User Unable to Log In to Account
    • High Login Time Experienced
    • It Takes a Long Time to Download a Mail Message
    • Unable to Read a Particular Message
    • During Peak Periods, Valid Users Receive Invalid Username and Password Error
    • Cannot Send Mail
    • Server Says Password is Incorrect but Password Has Not Changed
    • It Takes a Long Time to Open the Inbox
    • Oracle WebMail Client Issues
  • Problems with Mail Delivery
    • User Says Mail Delivery to Internet Addresses Does Not Occur
    • User Did Not Receive a Mail Message That Was Certainly Sent
    • User Does Not Receive Mail for 4 to 5 Minutes, but There Is Little Database Load
    • User Receives Most Messages Quickly, but Some Are Delayed for Hours or Days
    • Users say They Received Mail from a Distribution List, While Others Say They Have Not
    • Message Is Caught in a Mail Loop
    • Messages Are Being Rejected
    • Message delivery is slow
  • Problems with a Single Message
    • Read E-mail Time Is Slow
    • Misconfigured Rules Cause Mishandling of Messages
• Oracle Mail Application Problems
  • Problems with Mail Protocols
    • Complete Failure of Protocol Servers
    • Too Many IMAP/POP Database Connections
    • Too Many SMTP Inbound Client Connect Rejections
    • Connect Time to SMTP Server Is Long
  • Problems with the Mail Queues
    • Queues Are Building Up and Not Emptying
    • Problems With the Local Queue
    • Problems With the Relay Queue
    • Problems With the Submit Queue
  • Problems with the Housekeeper Process
    • Housekeeper Cannot Keep Up with Cleaning Up Old Mail
    • Problems With the Collection Queue
    • Problems With the Pruning Queue
• Problems with Oracle Collaboration Suite Database
  • Oracle Collaboration Suite Database Connectivity Problems
    • Network Unavailable Causing Massive Problems
  • Oracle Collaboration Suite Database Performance Problems
    • SQL*Net Service Is Unavailable
    • Oracle Collaboration Suite Database Is Slow
    • Archive Log File Directory Partition Is Full
    • Oracle Mail Storage Tablespaces Are Full Due to Lack of Extents
• Debugging Oracle Mail
  • Checking the Health of the E-mail Protocol Server Listener
  • Checking Memory, PGA Memory, and Number of Processes Connecting from MTAs to an Oracle Collaboration Suite Database

B Oracle Mail Error Messages

• Overview of Oracle Mail Error Messages
• IMAP and POP Error Messages
• SMTP Error Messages
• Housekeeper Error Messages
• List Server Error Messages
• NNTP Error Messages
• Virus Scrubber Error Messages
• Oracle WebMail Error Messages

C Shared Folders

• Overview of Shared Folders
• Understanding Access Control Lists for Shared Folders
• Managing Public Folders
• Creating Public Folders

D Oracle Mail Command-Line Reference

• oesdl
• oesng
  • Creating a Simple Public Newsgroup
  • Creating a Public Moderated Newsgroup
  • Creating a Public Newsgroup
  • Deleting a Public Newsgroup
• oespr
  • Creating a Simple Peer
  • Creating a Peer Using Articles from Specific Newgroups
  • Deleting a Peer
• oesucr
  • Creating Oracle Mail Users
  • Creating Oracle Mail Users at the Command Line
  • Deleting Oracle Mail Users
  • Clearing Data from the Oracle Collaboration Suite Database
  • Listing Deleted Users Whose Data Has Not Been Cleared
  • Changing the E-mail Address of an Oracle Mail User
• oesctl and opmnctl
  • Listing Oracle Mail Servers
  • Creating a New Oracle Mail Server Instance
  • Deleting an Instance from an Oracle Mail Server
  • Listing Oracle Mail Server Instances
  • Enabling an Oracle Mail Server
  • Disabling an Oracle Mail Server
  • Synchronizing Oracle Mail Server Configuration in Oracle Internet Directory to opmn.xml
  • Starting All Instances of an Oracle Mail Server
  • Starting a Single Instance of an Oracle Mail Server
  • Restarting One or All Instances of an Oracle Mail Server
  • Refreshing One or All Instances of an Oracle Mail Server
  • Stopping All Instances of an Oracle Mail Server
  • Stopping a Single Instance of an Oracle Mail Server
  • Dynamically Starting and Stopping Housekeeper Tasks
  • Showing Status for All Instances of an Oracle Mail Server
• oesrl
  • Deleting Server-Side Rules
  • Blocking Messages Containing Suspicious Attachments
  • Rejecting Messages Based on Text Strings
  • Capturing Outbound Messages Regardless of Domain
  • Copying Outgoing Messages to a Specific Account
  • Discarding All Messages from One Sender
  • Copying Messages into a Folder
  • Rejecting Messages with Too Many Recipients
  • Tips for Managing Server-Side Rules
• oesmon
• oeschart
• oesbkp
• oeschk
  • Users
  • Distribution Lists
  • Aliases
  • Foreign Users
  • Processes
  • Newsgroups
  • News Peers
  • Shared Folders
  • Server-Side Rules
  • Policies and Filters
  • Private Address Books
• oesutil
• esd_logscan.pl
• esd_check_quota_usage.pl
• esd_queue_examine.sql
• esd_find_message.sql
• esd_show_message.sql
• esd_copy_messages.sql
• esd_mail_queue.sql
• esd_list_user_folders.sql
• esd_list_folder_messages.sql
• esd_list_unopened_inbox.sql
• esd_show_sessions.sql
• esd_show_session_usage.sql
• utllockt.sql

E Oracle Mail Supported RFCs

F Oracle Mail Server Parameters and Log Files

• Oracle Mail Server Parameter Definitions
  • Oracle Mail Housekeeper
    • Oracle Mail Housekeeper Instance Setting Parameters
    • Oracle Mail Housekeeper Debug Parameters
  • Oracle Mail IMAP Server
    • Oracle Mail IMAP Server Instance Setting Parameters
    • Oracle Mail IMAP Server Debug Parameters
    • Oracle Mail IMAP Oracle Collaboration Suite Database Connection Parameters
  • Oracle Mail NNTP Inbound Server
    • Oracle Mail NNTP Inbound Server Instance Setting Parameters
    • Oracle Mail NNTP Inbound Server Debug Parameters
    • Oracle Mail NNTP Inbound Oracle Collaboration Suite Database Connection Parameters
  • Oracle Mail NNTP Outbound Server
    • Oracle Mail NNTP Outbound Server Instance Setting Parameters
    • Oracle Mail NNTP Outbound Server Debug Parameters
    • Oracle Mail NNTP Outbound Oracle Collaboration Suite Database Connection Parameters
  • Oracle Mail POP Server
    • Oracle Mail POP Server Instance Setting Parameters
    • Oracle Mail POP Server Debug Parameters
    • Oracle Mail POP Server Oracle Collaboration Suite Database Connection Parameters
  • Oracle Mail Virus Scrubber
    • Oracle Mail Virus Scrubber Instance Settings
    • Oracle Mail Virus Scrubber Debug Parameters
    • Oracle Mail Virus Scrubber Oracle Collaboration Suite Database Connection Parameters
  • Oracle Mail List Server
    • Oracle Mail List Server Target-Level Settings
    • Oracle Mail List Server Instance Debug Parameters
    • Oracle Mail List Server Oracle Collaboration Suite Database Connection Parameters
  • Oracle Mail SMTP Inbound Server
    • Oracle Mail SMTP-Inbound Instance Settings
    • Oracle Mail SMTP-Inbound Instance Debug Parameters
    • Oracle Mail SMTP-Inbound Oracle Collaboration Suite Database Connection Parameters
  • Oracle Mail SMTP Outbound Server
    • Oracle Mail SMTP Outbound Instance Settings
    • Oracle Mail SMTP Outbound Instance Debug Parameters
    • Oracle Mail SMTP Outbound Oracle Collaboration Suite Database Connection Parameters

G Alias and Distribution List Lookup

• Enabling Alias Lookup from Standard Clients
• Enabling Distribution List Lookup from Standard Clients
  • Distribution List Synchronization Utility
  • Synchronizing One or Multiple Distribution Lists
  • Synchronizing All Distribution Lists from a Private E-mail Namespace

H Oracle Mail Server Metrics

• Metrics Common to All Oracle Mail Servers
• POP Server Metrics
• IMAP Server Metrics
• SMTP Inbound Server Metrics
• SMTP Outbound Server Metrics
• Housekeeper Server Metrics
• List Server Metrics
• NNTP Inbound Server Metrics
• NNTP Outbound Server Metrics
• Virus Scrubber Server Metrics

I Plug-in for Oracle Mail User Provisioning Customizations

• Generating a User ID Based on User's First and Last Names
• Assigning an Oracle Collaboration Suite Database Based on Country
• Establish Mail Quota Dynamically Based on Title
• Selectively Provision Users for Oracle Mail

Glossary

Index