Contents

Title and Copyright Information

Preface

• Audience
• Related Documents
• Documentation Accessibility

1 Introduction

• Managing MetaSolv Solution Administration
• Introducing the Architecture
• Introducing the Accessory Applications

2 Securing the Application

• Planning Application Authorization
  • Learning How the Application Works
    • Pre-Implementation Checklist
  • Designing the Security Model
    • Identifying MetaSolv Solution Users
    • Understanding Groups and Permissions
    • Identifying Logical Groups of Users
    • Associating Users with Groups
• Implementing Application Security
  • Adding New Users and Groups
  • Authorizing System Administrators
  • Validating API Logons
    • Adding Registered Users to MSSRole for Accessing EJB Methods Externally
    • Adding Registered Users to MSSJMSRole for Accessing External JMS Queues
  • Tracking Logons
  • Managing Application Passwords
    • Setting the Password Preference
    • Specifying a Password Expiration Date
    • Maintaining User Passwords
  • Creating Additional Security Administrators
  • Assigning MetaSolv Solution Permissions
    • Understanding Permissions
    • Window Permissions
    • Control Permissions
    • Pop-Up Menu Permissions
    • Check Point Permissions
  • Scanning Windows and Controls Into the Database
• Creating MetaSolv Solution Security Reports
• Managing Utilities Security
• Managing File Permissions
• Changing Role Passwords

3 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
  • Enabling Users to Access Accessory Products
  • Using the Zero Admin Client (ZAC) to Deliver Changes

4 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

5 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
    • 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
    • mdl_cmp.txt and mdl_upd.com.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
• Sample Database Reports
  • Sample mdl_cur.txt or mdl_upd_cur.txt reports
  • Sample mdl_cmp.txt or mdl_upd_cmp.txt reports

6 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

7 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

8 Troubleshooting and FAQs

A Gateway.ini File Parameters

• 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