Siebel Database Upgrade Guide


What's New in This Release


Back to top


About Siebel Database Upgrade Topics

How the Siebel Database Upgrade Topics Are Organized

About Applicability of Siebel Database Upgrade Topics

About Terms Used in Siebel Database Upgrade Topics

About File Paths and Commands in Siebel Database Upgrade Topics


Back to top


Simplified Overview of Siebel Database Upgrade Process

About Database Environments

Simplified Overview of the Siebel Database Upgrade


Back to top


How to Perform a Siebel Database Upgrade

Roadmap for Performing a Siebel Database Upgrade

Process of Planning a Siebel Database Upgrade

Process of Upgrading a Siebel Development Environment

Process of Upgrading a Siebel Production Test Environment

Process of Tuning Siebel Upgrade Performance

Process of Upgrading a Siebel Production Environment


Back to top


How the Siebel Database Upgrade Works

Upgrade Flow Orientation

About Supported Siebel Upgrade Paths

About Siebel Upgrade Environments

About the Siebel Database Upgrade Process

About the Siebel Database Configuration Utilities

About the Siebel Upgrade Wizard and Driver Files

About Siebel Additive Schema Changes Mode

About the Siebel Database Upgrade Log Files

About the Siebel Case Insensitivity Wizard

Example of a Siebel Development Upgrade Flow

About the Siebel Repository Merge

About Inheriting Upgrade Behavior in a Siebel Upgrade

About the Siebel Postmerge Utilities

About the Siebel Incorporate Custom Layout (ICL) Upgrade Option

About the Database Configuration Utilities

About Tuning Siebel Production Upgrade Files


Back to top


Siebel Database and UI Upgrade Planning

Upgrade Flow Orientation

About Siebel Upgrade Planning Resources

About Best Practices for Doing Your Siebel Database Upgrade

About New Siebel Upgrade Features and Requirements

About Upgrading Your RDBMS in the Siebel Environment

About Siebel User Interface Changes

About Database Sort Order in the Siebel Environment

About the Siebel Party Model

About Migrating Siebel HTML Attachments to Base Tables

Upgrade Planning for Multilingual Siebel Deployments

Upgrade Planning for Siebel Unicode Support

Upgrade Planning for Siebel RC2 or AES Encryption

Upgrade Planning for Siebel Web Template Files and Style Sheet

Upgrade Planning for Siebel Access Control


Back to top


Application Planning for a Siebel Upgrade

Upgrade Flow Orientation

Determining Your Siebel 7.5.x Release Level

Upgrade Planning for Migrating Siebel Address Data

Upgrade Planning for Siebel Employee Relationship Management (ERM)

Upgrade Planning for Siebel Marketing

Upgrade Planning for Siebel Workflow Designer

Upgrade Planning for Handheld Devices in the Siebel Environment

Upgrade Planning for Resonate Central Dispatch in the Siebel Environment

Upgrade Planning for Siebel String Translation

Upgrade Planning for Siebel Configurator

Upgrade Planning for Siebel Personalization

Upgrade Planning for Siebel Pricer and Order Management

Upgrade Planning: Additional Siebel Application Changes


Back to top


Basic Database Preparations for a Siebel Upgrade

Upgrade Flow Orientation

Verifying Siebel Database Connectivity

Preparing Siebel Tables and Views for Upgrade

Preparing Siebel Custom Indexes for Upgrade

Exporting Siebel Interface Table Data

Archiving Unneeded Siebel Repositories

Preserving Siebel Dock Objects and Visibility Rules

Securing AIX Memory Allocation Segment Space for the Siebel Database

Preparing for a Multilingual Upgrade


Back to top


Preparing an IBM DB2 Database for a Siebel Upgrade

Verifying the IBM DB2 Client for a Siebel Upgrade

Verifying IBM DB2 Sort Order for a Siebel Upgrade

Setting IBM DB2 Parameters for a Siebel Upgrade

Verifying IBM DB2 Permissions for a Siebel Upgrade

Verifying IBM DB2 Instance Owner Permissions for a Siebel Upgrade

Creating IBM DB2 Temporary Tablespaces and Bufferpools for a Siebel Upgrade

Analyzing IBM DB2 Custom Tablespace Requirements for a Siebel Upgrade

Verifying the DB2 Application Development Client for a Siebel Upgrade

Identifying IBM DB2 Long Columns for Truncation in a Siebel Upgrade


Back to top


Preparing an Oracle Database for a Siebel Upgrade

Verifying Oracle Database Sort Order for a Siebel Upgrade

Setting Oracle Database Configuration Parameters for a Siebel Upgrade

Verifying Oracle Database Parameters for Multiple CPUs in a Siebel Upgrade

Verifying the Oracle Database ODBC Definition for a Siebel Upgrade


Back to top


Preparing a Microsoft SQL Server Database for a Siebel Upgrade

Verifying Microsoft SQL Server Sort Order for a Siebel Upgrade

Setting Microsoft SQL Server Temporary Space Size for a Siebel Upgrade

Setting Microsoft SQL Server Configuration Parameters for a Siebel Upgrade

Rebuilding Microsoft SQL Server Clustered Indexes for a Siebel Upgrade


Back to top


Preparing Siebel Application Data for Upgrade

Upgrade Flow Orientation

Preparing Siebel Workflow Processes for Upgrade

Preparing Siebel Customized Seed Data for Upgrade

Migrating Siebel Household Data

Setting Up Campaign Status Values for Siebel Marketing

Preserving Siebel Marketing Segment Descriptions

Preparing Siebel Mobile User Data for Upgrade

Setting the Value of Siebel S_SRC_PAYMENT.TYPE_CD for Upgrade

Preparing Siebel Address Data for Upgrade

Migrating Siebel Address Data from Custom Extension Columns

Preparing Siebel Territory Management Rules for Upgrade

Preparing Siebel Customizable Product Data for Upgrade


Back to top


Upgrading the Siebel Database

Upgrade Flow Orientation

Renaming the Siebel Repository

Changing the Siebel Database Configuration Utilities Language

Preparing to Run the Siebel Database Configuration Wizard

Running the Siebel Database Configuration Wizard Under Windows

Running the Siebel Database Configuration Wizard Under UNIX

Starting the Siebel Upgrade Wizard

Moving the Siebel Repository Files

Running the Siebel Case Insensitivity Wizard

Applying Siebel Additive Schema Changes

Regenerating SQL Files for a Siebel Upgrade

Identifying and Dropping Obsolete Indexes for a Siebel Upgrade

Preparing for a No-Development-Environment Siebel Upgrade

Installing New Siebel License Keys During an Upgrade


Back to top


Reviewing the Siebel Upgrade Log Files

Upgrade Flow Orientation

Summarizing Siebel Log Files Using the Logparse Utility

Reviewing Siebel Upgrade Log Files for Errors

Manually Archiving Siebel Upgrade Log Files


Back to top


Performing the Siebel Repository Merge

Upgrade Flow Orientation

Preparing for the Repository Merge

Configuring Siebel Repository Objects to Inherit Upgrade Behavior

Configuring Siebel Tools for the Repository Merge

Performing a Siebel Repository Merge

Reviewing the Siebel Repository Merge Log Files

Generating Siebel EIM Temporary Columns

Reviewing Siebel Repository Object Property Conflicts

Regenerating the Siebel Repository Definition Files

Setting Label Alignment for Siebel Text Fields

Copying UI Files to a New Siebel Environment

Deleting Unneeded Siebel Repository Files

Migrating Siebel Repository Objects to the Standard UI

Running the Siebel Postmerge Utilities


Back to top


Reviewing the Siebel User Interface

Upgrade Flow Orientation

Troubleshooting Postmerge Siebel UI Problems

Verifying Siebel Business Address Applet Configuration

Reviewing Siebel Grid-Based Applets

Reviewing Siebel UI Navigation

Reviewing Siebel Multi-Value Group (MVG) Shuttle Applets

Revising Siebel UI Rich Text Controls

Reviewing New Siebel UI Aggregate Categories

Revising Siebel Visibility Filters to Display Correctly

Assigning a Category and Type to Siebel Chart Views

Assigning a Category and Type to Siebel Explorer Views

Setting Up Navigation to Inaccessible Siebel Detail Views

Eliminating Obsolete Siebel UI Fields

Reviewing Siebel UI Objects Affected by Incorporate Custom Layout

Reviewing Required Fields in the Siebel UI

Assigning an Item Identifier to Siebel Web Template Items


Back to top


Siebel Postmerge Development Tasks

Upgrade Flow Orientation

Reviewing Objects Deleted from the Siebel Repository

Reviewing Obsolete Objects in the Siebel Repository

Upgrading to the Siebel Symbolic String Model

Dropping IBM DB2 8-KB Tablespaces and Buffers After a Siebel Merge

Updating Siebel Enterprise Application Integration (EAI)


Back to top


Postupgrade Tasks for the Siebel Database and File System

Upgrade Flow Orientation

Reapplying Schema Customizations in the Siebel Database

Checking for Inactivated EIM Table Columns in the Siebel Database

Validating Dock Objects and Rule Definitions in the Siebel Database

Verifying an Upgraded Oracle RDBMS After a Siebel Upgrade

Setting Oracle Database Parameters After a Siebel Upgrade

Updating Siebel File System Attachments


Back to top


Postupgrade Tasks for Siebel Applications

Upgrade Flow Orientation

Generating Siebel Reporting Relationships

Setting Up Siebel Global Time Zone Support

Upgrading Siebel ERM Approval Business Process Workflows

Upgrading Siebel ERM Customized Microsite and Group News Pages

Migrating Course Duration Information for Siebel Training

Upgrading the Launch Field in Siebel Training LOV

Upgrading the Test Status in Siebel Training

Verifying Class and Session Times in Siebel Training

Upgrading Responsibilities in Siebel Marketing

Reviewing Siebel Marketing Campaign Data

Reviewing Renamed Fields in Siebel Marketing

Displaying Regions in Siebel Marketing

Revising Program Flowchart Icons in Siebel Marketing

Setting Default Campaign Execution Options in Siebel Marketing

Upgrading Activity Plans for Programs and Campaigns in Siebel Marketing

Upgrading the Newsletter Offer Type in Siebel Marketing

Configuring Universal Inbox in Siebel Marketing

Configuring Siebel Marketing Purchase Orders for Display

Upgrading Siebel Purchase Orders

Configuring Siebel Asset-Based Ordering

Reviewing Siebel Address Data

Upgrading Siebel Attribute Pricing

Verifying Aggregate Discounts in Siebel Pricer

Upgrading Inbound Siebel Workflows

Migrating Data to the Bankruptcy Status Field in Siebel Financial Services

Universal Customer Master (UCM) Upgrade Steps After Repository Merge

Migrating Clinical Trip Report Data in Siebel Pharma


Back to top


Tuning the Siebel Upgrade Files

Upgrade Flow Orientation

Starting and Stopping Siebel Upgrade Tuner

Managing Parallel Threads Using Siebel Upgrade Tuner

Managing Zero-Row SQL Commands Using Siebel Upgrade Tuner

Transferring UNIX Files for Use by Siebel Upgrade Tuner

Rolling Back Siebel Upgrade Tuner Changes


Back to top


Siebel Marketing Upgrade Reference

Obsolete Siebel Marketing Data

Obsolete Business Objects in Siebel Marketing

Obsolete or Replaced Views in Siebel Marketing


Back to top


Tables Modified or Seeded During a Siebel Upgrade

Important Schema Changes at Siebel 7.8

Back to top

Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.