Go to main content
1/21
Contents
Title and Copyright Information
Preface
Audience
Accessing Oracle Communications Documentation
Documentation Accessibility
Document Revision History
1
OSM System Administration Overview
OSM System Administration Tasks
About OSM Security
About OSM System Administration Programs
Directory Placeholders Used in This Guide
2
Starting and Stopping OSM
About Starting and Stopping OSM
Starting the OSM Server
Verifying that OSM Has Started
Stopping OSM
Verifying that OSM Has Stopped
3
Changing GUI Application Appearance and Functionality
About Configuring the User Experience
About Behaviors
Changing Web Client Appearance and Functionality
Changing the Default Timeout Setting
Setting Table Height
Configuring the Data View Performance in the Order Management Web Client
Configuring the Display Size of Text Fields
Setting Default Action on Orders and Tasks in the Task Web Client
Customizing the Appearance of Read-Only Text Fields
4
Setting Up OSM Security
About OSM Security
Secure Solution Data Storage
Adding Users to OSM
Adding Users to Groups in the WebLogic Server Administration Console
Creating Workgroups as Roles in Design Studio
Assigning Users to Workgroups
Adding Users to WebLogic Server Security Realms
Using Secure Sockets Layer
Changing Secure Sockets Layer Configuration in OSM
Using WebLogic Server Authenticators with OSM
User-Level Authenticator Support
Group-Level Authenticator Support
Authenticator User and Group Assignment Considerations
Setting Up a Caching Realm
Secure Credential Management
Using the EncryptPasswords Utility
About the EncryptPasswords Utility
Running the EncryptPasswords Utility
Removing an Encrypted Password
Using the CreateEncryptPasswords Utility
Before Running the CreateEncryptPasswords Utility
Running the CreateEncryptPasswords Utility
Using the Credential Store
About the Credential Store
How OSM Retrieves Credentials from the Credential Store
Configuring the Java Security Policy for the OSM Credential Store
Configuring the Java Security Policy Using the credStoreAdmin Command
Setting Up Email Notifications Using the credStoreAdmin Command
Managing Credentials in the Credential Store
Developing Cartridges to Use the Credential Store
Developing Automation Plug-ins to Use the Credential Store
Defining Data Providers in OSM Cartridges to Use the Credential Store
Using the Credential Store with Custom Data Providers
Using the Credential Store with Built-In Data Providers
Upgrading Existing Cartridge Code to Use the Credential Store
Using Built-in SOAP Adapter as a Data Provider Class
Using the XML Import/Export Application to Administer Users and Workgroups
5
Configuring OSM with oms-config.xml
Working with oms-config.xml
oms-config.xml Parameters
Configuring Operational Order Jeopardies with Configuration Files
6
Configuring the Task Processor
About Configuring the Task Processor
Configuring the Task Processor for Performance
7
Managing the OSM Database Schema
Implementing a Strategy for OSM Information Lifecycle Management
Creating Tablespaces
Using Partitioning
Benefits of Partitioning
Improved Manageability
Increased Availability
Increased Concurrency
Support for Active-Active Oracle RAC
Increased Query Performance
Pitfalls of Partitioning
Order Search Performance
Purge Performance
Shared Pool
Development and Testing Environments
Order Purge Strategies
Partition-Based Order Purge Strategy
Partition Purge Example
Advantages and Disadvantages of Partition-Based Purge
Row-Based Order Purge Strategy
Row-Based Order Purge Example
Advantages and Disadvantages of Row-Based Order Purge
Hybrid Purge Strategy
Partitioning Realms
Partitioning Realms Configuration
Mapping Orders to Partitioning Realms
Enabling and Disabling Partitioning Realms
Renaming a Partitioning Realm
Refreshing Partitioning Realms Configuration
Adding Partitions for New Partitioning Realms
partition_auto_creation Disabled
partition_auto_creation Enabled
Purge Strategy for Partitioning Realms
Default Partitioning Realm
Non-Partitioned Schemas
Order ID Blocks
Cartridge Management Strategy
Sizing Partitions
Sizing Hash Sub-Partitions
Sizing Range Partitions for Partition-Based Order Purge
Purge Performance
Estimating Storage
"All-In" Order Volume
Partition Size Restrictions
Retention Policy
Time-to-Close Wait
Oracle RAC
Purge Frequency
Sizing Range Partitions for Row-Based Order Purge
Sizing Range Partitions for Zero Downtime
Sizing Range Partitions for Infrequent Maintenance
Online vs. Offline Maintenance
Managing Order Data
Adding Partitions (Online or Offline)
Using Row-Based Order Purge
Purging a Single Order by Order ID
Purging Orders that Satisfy Given Criteria
Scheduling Order Purge
Stopping and Resuming an Order Purge
Using Partition-Based Order Purge
Differences Between Purging and Dropping Partitions
Purging Partitions (Online or Offline)
Purging Entire Partitions That Do Not Contain Open Orders (Online or Offline)
Purging Partitions Partially (Offline Only)
Dropping Partitions (Offline Only)
Dropping Empty Partitions (Online or Offline)
Reclaiming Unused Space in Volatile Tables
Order Purge Policies
Purging Related Orders Independently
Auditing and Monitoring Order Purges
Audit Tables
Managing Exchange Tables for Partition-Based Order Purge
About OSM Purge Tables
About OSM Backup Tables
Creating Exchange Tables (Online or Offline)
Purging Exchange Tables (Online or Offline)
Dropping Exchange Tables (Online or Offline)
Estimating Partition Disk Space (Online or Offline)
Managing Cartridges
Using Fast Undeploy
Purging Metadata of Undeployed Cartridges
Configuration Parameters
range_partition_size
subpartitions_number
default_xchg_capacity
xchg_retained_orders_thres
degree_of_parallelism
degree_of_parallelism_rebuild_indexes
degree_of_parallelism_rebuild_xchg_indexes
purge_job_class
parallel_execute_chunk_size
partition_auto_creation
purge_policy_rebuild_unusable_indexes
purge_policy_purge_related_orders_independently
purge_policy_consolidate_partitions
purge_policy_time_to_close_wait
purge_audit_retention_days
deferred_segment_creation
purge_commit_count
About PL/SQL API
DBMS Output
Specifying Purge Criteria
Parallel Execution
Concurrency Restrictions
PL/SQL API Reference
Setup and Tuning Procedures
om_part_maintain.setup_xchg_tables (Online or Offline)
om_part_maintain.drop_xchg_tables (Online or Offline)
om_part_maintain.set_dop (Online or Offline)
om_part_maintain.set_dop_rebuild_indexes (Online or Offline)
om_part_maintain.set_dop_rebuild_xchg_indexes (Online or Offline)
Maintenance Procedures and Functions
om_part_maintain.add_partition (Offline Only)
om_part_maintain.add_partitions (Offline Only)
om_part_maintain.drop_partitions (Offline only)
om_part_maintain.drop_empty_partitions (Online or Offline)
om_part_maintain.purge_partitions (Online or Offline)
om_part_maintain.purge_entire_partition (Online or Offline)
om_part_maintain.estimate_ptn_purged_space (Online or Offline)
om_part_maintain.purge_xchg_bck_tables (Online or Offline)
om_part_maintain.purge_xchg_prg_tables (Online or Offline)
om_new_purge_pkg.delete_order (Online or Offline)
om_new_purge_pkg.purge_orders (Online or Offline)
om_new_purge_pkg.schedule_order_purge_job (Online or Offline)
om_new_purge_pkg.select_orders (Online or Offline)
om_new_purge_pkg.purge_selected_orders (Online or Offline)
om_new_purge_pkg.stop_purge (Online or Offline)
om_new_purge_pkg.resume_purge (Online or Offline)
Advanced Procedures
om_part_maintain.backup_selected_ords (Offline)
om_part_maintain.restore_orders (Offline)
Troubleshooting Functions
om_part_maintain.get_partitions (Online or Offline)
om_part_maintain.is_equipartitioned (Online or Offline)
Recovery Procedures
om_part_maintain.equipartition (Offline only)
om_part_maintain.purge_orphan_order_data (Online or Offline)
om_part_maintain.rebuild_unusable_indexes (Online or Offline)
om_part_maintain.rebuild_index (Online or Offline)
om_part_maintain.sys$undo_restore_table (Offline)
om_part_maintain.sys$undo_restore_orders (Offline)
Database Reference
Database Views
OM_AUDIT_PURGE_ALL
OM_AUDIT_PURGE_LATEST
Database Tables
OM_AUDIT_PURGE
OM_AUDIT_PURGE_ORDER
OM_AUDIT_PURGE_PARAM
Troubleshooting and Error Handling
Error Handling for add_partitions
Error Handling for drop_partitions
Error Handling for purge_partitions
Troubleshooting
Error Handling
Error Handling for rebuild_unusable_indexes
Error Handing for setup_xchg_tables
Performance Tuning
Tuning degree_of_parallelism
Tuning degree_of_parallelism_rebuild_indexes
Tuning degree_of_parallelism_rebuild_xchg_indexes
Tuning Parallel Job Execution
Tuning parallel_execute_chunk_size
Tuning Row-Based Purge
Database Terms
8
Managing Optimizer Statistics
About Optimizer Statistics
Gathering Optimizer Statistics
Gathering Statistics Online
Automated Optimizer Statistics Collection
Gathering Fixed Object Statistics
Gathering System Statistics
Gathering Cartridge Metamodel Statistics
Gathering Order Statistics
High Volatility Order Tables
Low Volatility Order Tables
Medium Volatility Order Tables
Enabling Incremental Statistics
Gathering High-Volatility-Table Statistics
Gathering Low-Volatility-Table Statistics
Preparing a New Partition
Populating New Partition Statistics
Using Statistics from Another Partition
Using Statistics from a Statistics Table
Using Statistics from Another System
Locking Partition Statistics
Configuring a Partition When It Is No Longer the Active Partition
Optimizer Statistics Error Handling Using Datapump
Optimizer Statistics Management Performance Tuning
Using Parallel Collection for Gathering Statistics
Cursor Invalidations
Optimizer Statistics Management PL/SQL API Reference
Setup and Tuning Procedures
om_db_stats_pkg.lock_volatile_order_stats
om_db_stats_pkg.unlock_volatile_order_stats
om_db_stats_pkg.set_table_prefs_incremental
om_db_stats_pkg.set_table_volatility
Maintenance Procedures
om_db_stats_pkg.gather_cartridge_stats
om_db_stats_pkg.gather_order_stats
om_db_stats_pkg.gather_volatile_order_stats
om_db_stats_pkg.copy_order_ptn_stats
om_db_stats_pkg.lock_order_ptn_stats
om_db_stats_pkg.unlock_order_ptn_stats
Advanced Procedures
om_db_stats_pkg.export_order_ptn_stats
om_db_stats_pkg.import_order_ptn_stats
om_db_stats_pkg.expdp_order_ptn_stats
om_db_stats_pkg.impdp_order_ptn_stats
Troubleshooting Procedures
om_db_stats_pkg.lstj_copy_order_ptn_stats
om_db_stats_pkg.get_order_ptn_stats
om_db_stats_pkg.list_order_ptn_stats
om_db_stats_pkg.check_order_ptn_stats
Recovery Procedures
om_db_stats_pkg.remj_copy_order_ptn_stats
9
Backing Up and Restoring OSM Files and Data
About Backing Up and Restoring OSM Files and Data
Backup and Restore Overview
Backup and Restore Schedule
OSM Home Directory
Oracle Database
WebLogic Server Files
Backup and Restore Considerations
Backing Up and Restoring the OSM Files
Backing Up the OSM Files
Restoring the OSM Files
Oracle Database Backup Considerations
RMAN Considerations
Oracle Flashback Technology Considerations
Mirroring Technology Considerations
Backing Up and Restoring the WebLogic Server Configuration
Backing Up the WebLogic Server Configuration
Before You Back Up the WebLogic Server
Setting OSM to Pause Processing of JMS Messages
WebLogic Server Domain Directory
WebLogic Persistent Store
OSM Attachment Directory
External Deployments
Remote Managed Servers (Clustered Server Only)
Restoring the WebLogic Server Configuration
Restoring the WebLogic Server Files
Setting OSM to Resume Processing of JMS Messages
10
Monitoring and Managing OSM
About Monitoring and Managing OSM
About Monitoring OSM Using WebLogic Server Administration Console
Accessing the WebLogic Server Administration Console
Using the WebLogic Console to Determine the Status of the OSM Application
Using the WebLogic Scripting Tool
Refreshing OSM Metadata
Monitoring and Analyzing Performance
Monitoring Performance Using WebLogic Server Administration Console
Monitoring the Managed Server
Analyzing Garbage Collection
Analyzing Class Loading
Coherence Datagram Testing
Monitoring WebLogic Server
Monitoring the Operating System
Gathering OSM Execution Statistics
Analyzing Heap Dumps
Analyzing Thread Dumps
Monitoring the Database
Updating Database Schema Statistics
Managing Log Files
Managing Log Files Using Enterprise Manager Fusion Middleware Control
Viewing Log Files and Messages Using Fusion Middleware Control
Configuring Logs Using Fusion Middleware Control
Managing Log Files Using WebLogic Server Administration Console
Viewing Log Files
Configuring the Log View
Log Size and Rotation
About Log Severity Levels
Configuring Log Levels Using the logging.xml File
Managing Logs Using WLST
Configuring Log Levels Using WLST
Secure vs Non-Secure Log Filtering
Managing Database Connections
Using JMS Queues to Send Messages
Monitoring the Event Queue
Sending Data to External Systems Using Plug-Ins
About OSM and XA Support
Using Work Managers to Prioritize Work
Creating and Configuring Work Managers
Overriding the Internet Explorer Language in the OMS Web Clients
About Metrics Data
Viewing Metrics Data
About DMS Metrics Tables
About WebLogic Metrics Tables
About Non-J2EE Metrics Tables
About Aggregated Metrics Tables
About Metric Rules Files
Analyzing Metric Data
Discovering a Cluster Database Target
11
Exporting and Importing OSM Schema Data
About Exporting and Importing OSM Schema Data
Exporting and Importing the OSM Model Data Only
Exporting OSM Model Data
Preparing the Target OSM Schema Before Import
Creating the Target OSM Schema
Adding Partitions
Importing OSM Model Data
Exporting and Importing the OSM Model and a Single Order
Exporting OSM Order Data
Preparing to Export Order Tables for a Single Order
Exporting Order Tables That Define an Order Sequence ID
Exporting the OSM Model Data
Importing the OSM Model and Order Data
Exporting and Importing a Range of Orders and the OSM Model
Exporting the OSM Order Data Range
Preparing to Export Order Tables for a Range of Orders
Exporting Order Tables That Define an Order Sequence ID
Exporting the OSM Model Data
Importing OSM Model and Order Data
Exporting and Importing a Range of OSM Orders Only
Exporting an Additional Range of Orders
Preparing to Export Order Tables for a Range of Orders
Exporting a Range of Orders from Order Tables That Define an Order Sequence ID
Importing an Additional Range of Orders
About Order Export Queries
Changing PAR File Parameters
About Import Parameters
Troubleshooting Export/Import
12
Configuring Time Zone Settings
Configuring Time Zone Settings
13
Troubleshooting OSM
Information You Need for Troubleshooting
General Checklist for Resolving Problems
Diagnosing Some Common Problems with OSM
Cannot Log in or Access Certain Functionality
System Appears Slow
Error: "Java.lang.StackOverflowError" when Using Task Web Client
Coherence Configuration Error: [STUCK] ExecuteThread
Unexpected Logout from Web Client
Error: "Login failed. Please try again."
Automation Plug-ins Are Not Getting Called
Delayed JMS Messages
Error Message For Events From a JMS Topic in a Cluster
JMS Message Delivery Failure
Unexpected Values for JMS Properties
Too Many Open Files
Problems When Running Multiple WebLogic Domains on One Host
Proxy Fails on a Clustered System
Unable to Bring Up Managed Server After Database Failure
Orders Are Not Being Created on a Clustered System
JBoss Cache Timeouts
OSM Fails to Process Orders Because of Metadata Errors
Error: "No Backend Servers Available"
DataDictionary Expansion Level
Quick Fix Button Active During Order Template Conflicts in Design Studio
Cannot Create New Orders on a New Cartridge Version
Error: "exact fetch returns more than requested number of rows"
Error: "unique constraint violated"
Exceptions When Purging is in Progress
Error: "Ignoring partition"
Getting Help with OSM Problems
Before You Contact Support
Reporting Problems
14
OSM Log Messages
OSM Catalog Messages
Automation Catalog Messages
15
Using the XML Import/Export Application
About the XML Import/Export Application
About Using the XML Import/Export Application
About XML Import/Export Batch Scripts and Ant Commands
About XML Import/Export Ant Commands and Syntax
About XML Import/Export Batch Scripts and Syntax
Configuring the XML Import/Export Environment Files
Configuring the build.properties File for Ant Commands
Configuring the config.bat Script for Batch Scripts
Configuring the config.xml File XML Import/Export Nodes and Elements
Using SSL Connections
About Importing and Exporting Metadata
About Exporting Metadata
About the Order of Exported Metadata
About Export Layout Options
Keeping the ID Integrity in SQL Rules
Configuring and Running an Export
About Importing Metadata
Configuring and Running an Import
Sample Procedure for Adding a New Workgroup Definition (Role)
Sample Procedure for Adding a Task to a Workgroup (Role)
About Purging MetaData and Data
Undeploying Cartridges and Purging the Database Schema
About Purging Orders
Purging Orders with the orderPurge.bat Script on Windows
Running Ant with the orderPurge.xml file On UNIX or Linux to Purge Orders
About Migrating Orders
Configuring and Running an Order Migration
About Validating the Metadata Model and Data
Configuring and Running an XML Document Validation
Validating an XML Document During the Import or Export Process
About Creating a Graphical Representation of the Metadata Model
Configuring and Creating a Graphical Representation of a Metadata Model
Viewing the Graphical Representation
A
OSM Credential Store API Command Reference
OSM User Security and Credential Store Commands
userAdmin Command
credStoreAdmin Command
OSM User Security and Credential Store API Reference Material
CredStore
PasswordCredStore
CredStoreException
SoapAdapter
ObjectelHTTPAdapter
ViewRuleContext
AutomationContext
B
Tools for Performance Testing, Tuning, and Troubleshooting
WebLogic Server Administration Console
Java VisualVM
JMap
JStack
OSM Task Web Client
Enterprise Manager
SoapUI
Compliance Tool
Design Studio
Software Load Balancer
GCViewer
ThreadLogic
OSW Black Box
Remote Diagnostics Agent
Operating System RDA Report
WebLogic RDA Report
Database RDA Report
Oracle RAC Cluster RDA Report
OSM RDA Report
C
OSM Installed Components
OSM Directory Structure
Productized Cartridges
WebLogic Installed Components
WebLogic Deployments
WebLogic Configuration
Coherence Clusters
Work Managers
JMS Servers
JMS Module
Queues and Topics
Quotas
Connection Factories
Destination Key
JMS Template
File T3
Data Sources
Users and Groups
Database Configuration
Scripting on this page enhances content navigation, but does not change the content in any way.