Upgrade Guide > Siebel Database and UI Upgrade Planning >
Best Practices for Doing Your Siebel Database Upgrade
Upgrades: All Siebel upgrades.
Environments: Development, production test, production.
This section provides an overview of best practices for planning upgrade resources, estimating the upgrade time line, and managing the data migration process.
Use the following steps to help plan your upgrade.
- Determine your upgrade path. First, refer to System Requirements and Supported Platforms on Siebel SupportWeb to determine supported upgrade paths for major releases. Verify whether you can upgrade directly to the currently shipping release or whether you must upgrade to a previous release first. Second, refer to the Maintenance Release Guides on Oracle's Siebel SupportWeb for the release to which you are upgrading. These Guides list the upgrade path from the major release to its most recent maintenance release. Maintenance releases roll up fixpacks and also include new features. Because fixes to the upgrade process may exist in fixpacks included in a maintenance release, you should install the most recent maintenance release before starting the upgrade.
- Evaluate the complexity of the upgrade. Determine the complexity of the upgrade effort based on Oracle's Siebel modules implemented, number of integration points, number of interfaces, total number of scripts, and number of user interface scripts.
- Assess the current Siebel environment and evaluate the existing implementation. Perform a detailed assessment of the current Siebel environment to determine how the implementation will be affected by the upgrade. Evaluate the current implementation in comparison with the architecture of the current release. The assessment will help you to identify areas where you can take advantage of new functionality to meet business requirements.
- Estimate the level of effort to upgrade. Determine the metrics and cost associated with each aspect of the upgrade. Determine the effort required to upgrade based on the results of your complexity evaluation, current environment assessment, and new functionality review. This will help you to estimate resources, time line, and costs.
- Establish the upgrade team. Assemble a cross-functional upgrade team that understands Siebel product architecture and performance best practices. Include IT professionals, executives, and users to ensure a broad base of experience in technical, business, and Siebel-specific skills.
- Review interface migration tasks. Determine the effort to migrate modified applets and views. This includes associating applets with Web template items and mapping them to Web template controls.
- Plan for upgrade tuning. Tuning your production upgrade scripts can significantly reduce downtime during the final stages of your upgrade. Examples of upgrade tuning include eliminating SQL statements that do not affect any data, executing long-running SQL statements in parallel, and executing table creation, table rebuilds, and index creation in parallel.
- Identify data migration tasks. After the upgrade, there may be data migration and repository configuration tasks that must be performed manually. These tasks frequently involve customizations made in prior releases.
- Plan for end-user training. Analyze the impact of change on the users, and develop a plan for end-user training and adoption.
The upgrade of your application requires several key things to be successful:
- A detailed understanding of customizations made to your current deployment
- Analysis and definition of the components within your enterprise
- Analysis of how to use new functionality provided by Oracle's Siebel software
- Strict adherence to industry best practices and best practices identified in this guide
The upgrade planning process will produce a road map for the entire upgrade project that outlines infrastructure, deployment, and training requirements.
Use the results of this process to develop a project plan that identifies required skills and resources for developing and deploying the upgraded application. This will help you with advance budgeting of resources, time, and training.
Upgrade Planning Best Practices
Here are important best practices to follow when planning an upgrade:
- Review System Requirements and Supported Platforms on Siebel SupportWeb, Release Notes, Maintenance Release Guide, and Alerts related to upgrades to verify your upgrade path. These documents are available on Oracle's Siebel SupportWeb at https://ebusiness.siebel.com/supportweb/.
- Gather all relevant documentation that describes the current implementation, for example requirements documents, design documents, and architecture context diagrams.
- Implement a change management program. For example, communicate rollout dates to users, schedule training, allow adequate time for users to adjust to the enhancements, and provide a process for end users to provide feedback to the project team.
- User adoption is critical to a successful upgrade. Provide access to a test environment that allows users to become familiar with the new version of the application, and provide end-user training on the upgraded application.
Database Planning Best Practices
Here are important best practices to follow when planning the upgrade of your database:
- Analyze the impact of the upgrade on table customizations that you have made. Determine if pre-upgrade data migration is required. Determine what postupgrade schema changes are required. For a list of tables that are affected by the upgrade, see Tables Modified or Seeded During a Siebel Upgrade.
- Consider database layout in your planning. Plan to tune the database and database server for the upgrade, because settings and parameters for upgrade differ from those required for OLTP.
- If you are migrating multiple languages from a prior version, plan extra time (one to two weeks) for the repository merge process. The expected merge time may increase with the number of languages in the repository. You also might need to plan for additional installation-related tasks.
- For IBM DB2 platforms, consider increasing the size of your tablespaces before going live. Make sure that your custom tablespaces are large enough for upgraded tables. See Analyzing IBM DB2 Custom Tablespace Requirements for a Siebel Upgrade.