1/14

Contents

Title and Copyright Information

Preface

• Audience
• Related Documents
• Documentation Accessibility

1 Introduction

• Managing MetaSolv Solution Administration
• Introducing the Architecture
• Introducing the Accessory Applications
• Securing the MSS Application

2 Maintaining Configuration

• Understanding Configuration Files
• MetaSolv Solution Application Components
  • Communicating with the Oracle WebLogic Server
  • Using a tbs_db.ini File
  • Changing INI Files
  • Pre-Migration Analysis Tool Configuration
• Setting Oracle WebLogic Server Performance Parameters
  • Setting gateway.ini Oracle WebLogic Server Performance Settings
  • Copying Encrypted Passwords to gateway.ini
  • Setting loggingconfig.xml Oracle WebLogic Server Performance Settings
• Setting Up API Servers
  • Updating Configuration Files
  • Changing Configuration Files When the Environment Changes
• Changing System Preferences
• Delivering File Changes
  • Delivering Configuration Changes You Make
• Gateway Events Through Integration Server
  • Creating a Gateway Event
  • Outbound Events
  • Locating Help Information On Gateway Events

3 Running the Oracle WebLogic Server

• Starting and Stopping the MetaSolv Solution Application Server
• Managing the Oracle WebLogic Server
  • Getting Started with the Administration Console
  • Getting Oracle WebLogic Server Runtime Information
    • Server Details
    • Links to Administrative Tools
• Managing MetaSolv Solution Log Files
  • Using the Log Viewer
  • Archiving the Log Files
  • Changing the Log File Location
  • Setting the loggingconfig.xml Parameters
    • Editable Logging File Specifications
  • Resolving a Sample Problem Using Log File Messages

4 Managing the MetaSolv Solution Database

• MetaSolv Solution DBA Requirements
  • Installing, Upgrading, and Configuring the Database
• Maintaining the Database
  • Managing Specific MetaSolv Solution Issues
    • Adding Database Administrators for MetaSolv Solution
    • Handling Import and Export Requirements
    • Handling Locally Managed Tablespaces
    • Maintaining Job Type Table Data
    • Handling International Data
• Managing Scalability
• Managing Database Performance
  • DBA Tasks
  • Identifying Structure and Performance Problems with Scripts
    • o_config.sql
    • o_cfggen.sql
    • o_cfgrpt.txt
    • o_analyz.sql
    • o_granta, o_grante, o_grantb, o_grantj.sql
    • mdl_cmp.sql and mdl_upg_cmp.sql
    • mdl_cmp.txt and mdl_upd_cmp.txt
    • mdl_cur.sql and mdl_upd_cur.sql
    • mdl_cur.txt and mdl_upd_cur.txt
  • Tuning the Init.ora File
    • Major Contributors to Performance
  • Tuning with Non-init.ora Files
• Backing Up and Restoring the System

5 Customizing the Application

• Customizing the Desktop
  • Configuring Portlets
    • Adding Portlets
    • Managing Logons within Portlets
  • Customizing the Navbar
• Producing Custom Reports
  • Creating a Customized Report
  • Retaining Customized Reports After an Upgrade
• Using Stored Procedure Exits
  • Retaining User Exits After an Upgrade
  • Coding User Exits
    • Generate a Circuit ID
    • Generate a Custom Customer Account Number
    • Perform Custom Validation on Network Locations
    • PSR Custom Pre-Validation
    • Perform Custom Validation on a PSR Order
    • Perform Custom Validation at Task Completion
    • Populate the Internet Dial Up User ID
    • Populate the Internet Dial Up Password
    • Populate the PSR Email Password
    • Populate the Web Hosting User ID
    • Populate the Web Hosting Password
    • Populate the URL
    • Validate an Email Address
    • Validate a User ID
    • Validate a Password
    • Generate an MSAG Validation Audit Trail

6 Running Utilities, Local Exchange Routing Gateway, and Background Processor

• Running Background Processor
  • Understanding the Background Processor
    • Job Manager
    • Job Master
    • Job Worker
  • Configuring the Background Processor
    • Setting Up the Background Processor
    • Locating EXE and INI Files
    • Configuring Jmaster.ini
    • Setting Preferences
    • Meeting Performance Requirements
    • Configuring Multiple Background Processors
    • Managing Performance and Tuning
  • Maintaining the Background Processor
    • Environment Responsibilities
    • Online Job Queue Responsibilities
    • Responsibilities for End Users
    • Log Files
    • Restarting Background Processor Jobs
    • Scheduling Automatic Job Submissions
• Importing Local Exchange Routing Information
  • Starting the Location and Routing Gateway
  • Setting Up the Gateway
    • Application Setup Fields
    • Importing the Data
    • Restarting a Canceled Import
  • Creating a Location and Routing Gateway Report
• Using the MetaSolv Solution Utilities
  • Starting the Application
    • Primary Toolbar Utilities
    • Options Menu Utilities
  • Using the Purge Utility
    • Setting the Purge Preferences
    • Purging Tasks from Service Requests
    • Purging Employees
    • Purging Orders
    • Purging Worksheets
    • Purging DLR Issues
    • Purging Expired Reservations
    • Purging Server Logs
    • Producing a Purge Error Report
  • Using the DB Health Utility
    • Checking Database Health
    • Repairing Database Errors
    • Generating the DB Status Report
  • Using the Migration Utility
  • Using the Custom Attributes Utility
  • Using the Geographical Area Types Utility
  • Using the Structured Formats Utility
  • Using the Address Correction Utility
• NPA Split Utility

7 Troubleshooting and FAQs

A Parameters for gateway.ini File

• Using gateway.ini
  • Changing Parameters
  • Restarting the Oracle WebLogic Server
  • Understanding the gateway.ini File Structure
  • Sample installed gateway.ini File
• Servers Parameters
  • Sample Servers Parameters
  • Server Parameter Descriptions
• ThreadProcs Parameters
  • Sample ThreadProcs Section
  • ThreadProcs Parameter Descriptions
• OrbProperties Parameter
  • Sample OrbProperties Parameter
  • OrbProperties Parameter Description
• Session Parameters
  • Sample Session Section
  • Session Parameter Descriptions
• System Parameters
  • Sample System Section
  • System Parameter Descriptions
• Gateway Parameters
  • Sample Gateway Parameters
  • Gateway Parameter Descriptions
• Events Parameters
  • Sample Events Parameters
  • Events Parameter Descriptions
• Event2 Parameters
  • Sample Event2 Parameters
  • Event2 Parameter Descriptions
• WorkManagement Parameters
  • Sample Work Management Section
  • Work Management Parameter Descriptions
• JNDI Parameters
  • Sample JNDI Parameters
  • JNDI Parameter Descriptions
• Custom Attribute (CA) Parameters
  • Sample CA Parameters
  • CA Parameter Descriptions
• Portal Parameters
  • Sample Portal Parameter
  • Portal Parameter Description
• Custom Parameters
  • Sample Custom Parameter
  • Custom Parameter Description

B Annotated loggingconfig.xml

C Oracle WebLogic Server Configuration Settings

• Small Deployment Administration Server
• Small Deployment Clustered Administration Server
• Medium Deployment Administration Server
  • Medium Deployment Clustered Server
  • Medium Deployment Clustered Server Configuration
• Large Deployment Administration Server
  • Large Deployment Clustered Server
  • Large Deployment Clustered Server Configuration

Glossary