Siebel Database Upgrade Guide > How to Perform a Siebel Database Upgrade >

Process of Upgrading a Siebel Development Environment


Upgrades from: All Supported Siebel releases.

Environments: Development environment only.

Platforms: Windows and UNIX only. This topic does not apply to IBM z/OS.

This process is part of a roadmap. See Roadmap for Performing a Siebel Database Upgrade.

This topic lists the steps required to upgrade a Siebel development environment to the current release. Print this topic and use it as a checklist for doing the upgrade.

The topic is divided into sections, each containing a list of numbered steps. Complete each section in the order shown.

CAUTION:  Do not use this topic to perform a development environment upgrade on IBM z/OS. Instead, refer to Siebel Database Upgrade Guide for DB2 UDB for z/OS.

Search for Bulletins and Alerts on OracleMetalink 3

  1. Check OracleMetalink 3 for recently published Bulletins and Alerts regarding the upgrade. For more information, see About Siebel Upgrade Planning Resources.

Upgrade the Servers

Verify you have identified all the maintenance releases, Fix Packs, and quick-fix patches required for the upgrade. These requirements are located in the applicable Siebel Maintenance Release Guide on OracleMetalink 3.

CAUTION:  Do not install a new Siebel Database as part of upgrading the Siebel Enterprise.

To perform the following steps, see the Siebel Installation Guide for the operating system you are using.

  1. Upgrade the Gateway Name Server, Siebel Servers, and Siebel Web Server Extension (SWSE).

    For information upgrading these Siebel Enterprise components, see Siebel Installation Guide for the operating system you are using.

  2. Install the Siebel Database Server files on the Siebel Server you will use to perform the upgrade. You only need to install the database server files for the database type that you are upgrading.
  3. Install language packs for your currently deployed languages and any new languages.
  4. If you have customized the configuration of Enterprise components, such as Siebel Servers, you can run a script to migrate configuration parameters to the upgraded Siebel Enterprise. See Going Live with Siebel Business Applications.

Upgrade Third-Party Software

  1. Upgrade third-party software as required due to dependencies on Oracle's Siebel software or other installed software. For example, you may need to upgrade the following software:
    • Actuate Server (Siebel Reports Server).
    • Operating system software. Some database upgrades require newer versions of AIX or Windows.

Upgrade the RDBMS

  1. If required, upgrade the RDBMS version. Refer to the vendor's documentation to perform the upgrade:
    • For information on supported RDBMS systems, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.
    • For information on how upgrading your RDBMS affects the upgrade process, see About Upgrading Your RDBMS in the Siebel Environment.

Pre-Upgrade Tasks for the Siebel Database

These steps apply to all database types.

  1. Review guidelines for configuring the RDBMS. See the Siebel Installation Guide for the operating system you are using.
  2. Verify that the Workflow Monitor and Workflow action agents have processed all pending requests.
  3. Stop Siebel Servers, but make sure the Siebel Gateway Name Server is running.

    NOTE:  The Database Configuration Wizard will not proceed unless the Gateway Name Server is running.

  4. Perform the tasks in Basic Database Preparations for a Siebel Upgrade.
  5. Migrating Siebel Repository Objects to the Standard UI.

Pre-Upgrade Tasks for IBM DB2

  1. Perform the tasks in Preparing an IBM DB2 Database for a Siebel Upgrade.
  2. Apply runstats to your Tools tables, reorganize any that are out of cluster, or that are clustered less than 90%, then execute runstats on those tables again. This will improve performance and reduce the number of tasks that will need to be done after the upgrade is complete.

Pre-Upgrade Tasks for Oracle Database

  1. Perform the tasks in Preparing an Oracle Database for a Siebel Upgrade.
  2. Run the Oracle Analyze command on the Siebel Database. Highly fragmented indexes can cause the upgrade to fail.

Pre-Upgrade Tasks for MS SQL Server

  1. Perform the tasks in Preparing a Microsoft SQL Server Database for a Siebel Upgrade.
  2. Run Microsoft SQL Server statistics. This will improve upgrade performance.

Pre-Upgrade Tasks for Application Data

  1. Perform the tasks in Bulletin 477519.1 (Doc ID) on OracleMetalink 3. This document was previously published as Siebel Technical Note 521. The following table shows the applicability of the tasks in the Bulletin.
Item
Environment

Location and amendment of S_VIEW_WTMPL_IT.ITEM_NUM records

Development, production test, production

Update multi-value group (MVG) and association list applets

Development only

Update unnamed controls in applet web template items

Development only

  1. Perform the tasks in the OracleMetalink 3 Bulletin listed in the following table.
Title
Environment

477254.1 (Doc ID). This document was previously published as Siebel Technical Note 481.1

Development only

  1. Perform the tasks in Preparing Siebel Application Data for Upgrade.

Preparing Developers for the Upgrade

  1. Back up the development database.
  2. Verify that all developers have checked in their projects and that all projects are unlocked.
  3. Verify that all developers have disconnected from the database. The only open account must be the account that is performing the upgrade.
  4. Install the new Siebel Tools and license keys on development workstations.

    NOTE:  Keep at least one copy of the previous version of Siebel Tools. You will need it to perform repository operations before the repository merge.

    Perform all remaining tasks with the new Siebel Tools, unless stated otherwise.

Copy the r752.dat Ancestor Repository File

  1. 7.5.2 upgrades only (HOR and SIA):

    After you install the Siebel Database Configuration Utilities software, but before you upgrade to the Siebel 8.0 release, you must copy the r752.dat ancestor repository file located in the tools\bin directory to one of the directories listed as follows:

    • Windows: Copy the r752.dat ancestor repository file from the tools\bin directory to the DBSRVR_ROOT\common directory.
    • UNIX: FTP the r752.dat ancestor repository file from the tools\bin directory on the Windows machine to the DBSRVR_ROOT/common directory on the UNIX machine.

Upgrade Siebel Database Schema (upgrep)

  1. Renaming the Siebel Repository.
  2. (Optional) Changing the Siebel Database Configuration Utilities Language.
  3. Run the Database Configuration Wizard:
  4. Edit generated SQL files as required by Bulletins or Alerts on OracleMetalink 3, and by the applicable version of Siebel Release Notes on OracleMetaLink 3.
  5. Resume the upgrade: Starting the Siebel Upgrade Wizard.
  6. Review the upgrade logs and resolve errors:
  7. If the upgrade contains unacceptable errors, do the following:
    1. Restore the backup of the database.
    2. Correct the errors.
    3. If errors occurred because you entered incorrect information in the Database Configuration Wizard, see Regenerating SQL Files for a Siebel Upgrade.
    4. Rerun the Database Configuration Wizard.
  8. Back up the upgraded database.

Prepare for Repository Merge

  1. Set the Upgrade Ancestor property for copied objects. See Configuring Siebel Repository Objects to Inherit Upgrade Behavior.
  2. See Configuring Siebel Tools for the Repository Merge.
  3. (IBM DB2 and Microsoft SQL Only) Run database statistics on the Siebel Database. If upgrading from Siebel 7.0.x or 7.5.x, run statistics specifically on S_SYM_STR and S_SYM_STR_INTL.

    Running statistics on the Siebel Database improves merge performance.

Perform Repository Merge

Use the upgraded version of Siebel Tools to perform these tasks.

  1. Performing a Siebel Repository Merge.
  2. Reviewing the Siebel Repository Merge Log Files.
  3. If the repository merge contains unacceptable errors, do the following:
    1. Restore the backup of the upgraded database.
    2. Correct the errors.
    3. Rerun the repository merge.
  4. Running the Siebel Postmerge Utilities.
  5. Generating Siebel EIM Temporary Columns.
  6. (Optional) Configure case insensitive queries in the New Customer Repository. See Running the Siebel Case Insensitivity Wizard.
  7. Reset Siebel Tools configuration. See Configuring Siebel Tools for the Repository Merge.
  8. Back up the Siebel Database.

Upgrade Custom Database Schema (upgphys)

  1. Run the Database Configuration Wizard:
  2. Run the Upgrade Wizard: Starting the Siebel Upgrade Wizard.
  3. Review the upgrade log files and resolve errors:
  4. If the upgrade contains unacceptable errors, do the following:
    1. Restore the backup of the database you made after the repository merge.
    2. Correct the errors.
    3. Repeat the steps beginning after the backup.
  5. Manually Archiving Siebel Upgrade Log Files.
  6. Back up the upgraded database.

Initialize and Extract Developers' Local Databases

  1. Install the new release of Siebel Tools on developers' machines.
  2. Initialize and extract the local database on development machines. For more information, see Developing and Deploying Siebel Business Applications.

Review the User Interface

  1. Reviewing Siebel Repository Object Property Conflicts
  2. Review the following topics on UI upgrade before proceeding:
  3. If you performed an ICL upgrade and chose Label on Top, revise the cascading style sheet. See Setting Label Alignment for Siebel Text Fields.
  4. Create a new SRF file to assist in UI testing. For information on creating an SRF file, see Developing and Deploying Siebel Business Applications.
  5. If you customized style sheet or Web template files in the previous release, reimplement those customizations in the new release as desired.

    Carefully review the UI in the new release before reimplementing customizations to these files.

  6. Perform the tasks in Reviewing the Siebel User Interface.
  7. The postmerge utilities do not convert certain types of flow-based applets to grid-based applets. For example, they do not convert custom form applets to grid-based applets. See the "Editing Applet Layout" portion of Configuring Siebel Business Applications and convert remaining flow-based applets as desired.

Postmerge Development Tasks

  1. Perform the tasks in Siebel Postmerge Development Tasks.
  2. Resolve any business component and join conflicts.
  3. Deleting Unneeded Siebel Repository Files.

Postupgrade Tasks for Database and File System

  1. Perform the tasks in Postupgrade Tasks for the Siebel Database and File System.
  2. Reset upgrade-specific database and database server parameters back to their recommended settings for production. See Siebel Installation Guide for the operating system you are using for recommended parameter settings.
  3. If you exported data from interface tables before the upgrade, review the database and import the data as desired. See Siebel Enterprise Integration Manager Administration Guide.
  4. Upgrade Planning for Siebel RC2 or AES Encryption.
  5. Generate a Siebel Remote database template file. See Siebel Remote and Replication Manager Administration Guide.
  6. Run database statistics.

NOTE:  The upgrade is complete. The remaining topics deal with configuration and validation tasks.

Postupgrade Tasks for Applications Configuration

  1. Installing New Siebel License Keys During an Upgrade.
  2. If applicable, review the results of the Person and Organization merge. Make configuration changes as required. To determine applicability or obtain more information, see About the Siebel Party Model.
  3. Perform the tasks in Postupgrade Tasks for Siebel Applications.
  4. Verify the function of interfaces in integrated applications.
  5. Activate and deploy workflows.
  6. If you have set up integrations for transferring data to or from third-party applications using Siebel EAI, verify the integrations are configured correctly. For information on EAI, see Overview: Siebel Enterprise Application Integration.
  7. If you have used EIM to set up batch processing jobs, verify EIM is configured correctly. For information on EIM, see Siebel Enterprise Integration Manager Administration Guide.

System Tests

  1. Use available test data to perform unit testing. Validate the operation of the application in the following areas:
    • User interface
    • Data interfaces
    • Integrity of migrated data
    • Workflow function

Prepare for Transition to Production Test Environment

  1. Create a new SRF file. For information on creating an SRF file, see Developing and Deploying Siebel Business Applications.
  2. If you revised the repository after running upgphys, you must regenerate the repository definition files. See Regenerating the Siebel Repository Definition Files.
Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.