Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for UNIX > Upgrading the Siebel eBusiness Application >
Upgrading the Custom Database Schema
The configuration utility that you ran in Upgrading the Siebel Database Schema updated the Siebel Database Schema. You must now use the Database Server Configuration Wizard to apply these changes to the custom database schema to upgrade it to the new version.
If you are upgrading a development environment, the repository on which you run the Custom Database Schema upgrade must be the same repository that you prepared for the merge in Generating EIM Temporary Columns.
Before upgrading the custom database schema, take a backup of your Siebel database.
NOTE: The custom database schema upgrade may complete in less than one hour.
To upgrade the custom database schema on supported UNIX platforms
- Verify that all servers are stopped:
- Depending on your shell, source environment variables from
$SIEBSRVR_ROOT
/bin
by typing:- Set the following environment variables:
SIEBEL_ROOT
should be the path of your Siebel eBusiness Application installation directory.LANGUAGE
should be set to the language in which the Configuration Wizard prompts appear; for example,enu
for U.S. English.If either of these values is incorrect or empty, reset them using one of the following commands for the shell you are using:
- Navigate to
$
SIEBSRVR_ROOT
/bin
and enter:- Review the values of the following environment variables and confirm whether the settings are correct by entering either
Y
orN
.
- At the Siebel Server Directory prompt, enter the path of your Siebel Server root directory, or accept the default by pressing Enter.
- At the Siebel Database Server Directory prompt, enter the path of your database server root directory, or accept the default by pressing Enter.
- At the RDBMS Platform prompt, enter the number that corresponds to your database platform.
- At the Siebel Database Operation prompt, choose Upgrade Database (
2
).- At the Upgrade Options prompt, choose Upgrade Custom Database Schema
(2)
.- At the Environment Type prompt, enter the number that corresponds to the environment that you are upgrading:
Which prompt appears next depends on the application that you are upgrading:
- If you are upgrading a Siebel Industry Application or Siebel Financial Services Application, choose the application from which you are upgrading. Carefully read the descriptions of the available applications. The choices available to you are constrained by the database platform you selected. The following applications may appear:
NOTE: Before choosing your application, see Siebel System Requirements and Supported Platforms to verify the supported upgrade paths for your deployment.
- Siebel Automotive. Choose this if you are upgrading from Release 6.x of Siebel Automotive.
- Siebel Communication Media Energy. Choose this if you are upgrading from Release 6.x of Siebel Communications, Media, and Energy.
- Siebel Consumer Sector. Choose this if you are upgrading from Release 6.x of Siebel Consumer Sector.
- Siebel Life Sciences. Choose this if you are upgrading from Release 6.x of Siebel Life Sciences.
- Siebel Industry Solutions. Choose this if you are upgrading from Release 7.0.3 or 7.0.4 of any of the following applications: Siebel Consumer Sector, Siebel Life Sciences, Siebel Communications, Media, and Energy, Siebel Automotive.
- Siebel Financial Services. Choose this if you are upgrading from Release 6.x or 7.x of Siebel Financial Services.
- At the Current Siebel Version prompt, select the version of Siebel you are upgrading from.
- At the Language Selection prompt, enter the number that corresponds to the appropriate language.
NOTE: The language selection screen will not appear if you have only one language installed, because that language is automatically defined as the primary language. Therefore, you will skip the next step and continue with Step 15.
- At the ODBC Data Source Name prompt, enter the ODBC datasource name; for example,
siebsrvr_siebel.
The data source is created automatically by the Siebel Server installation, using the format $
SIEBSRVR
_
EnterpriseName
. To find the name of your ODBC data source, type:vi $ODBCINI
- At the Database User Name prompt, enter the database user name and password for your database:
- At the Database Table Owner Name prompt, enter the database tableowner name (this is the account that will own the Siebel objects):
Database Tableowner. User name of the tableowner, for example,
siebel
.Database Tableowner Password. Password for the tableowner, for example,
db2
.- At the Database Server OS prompt, enter the number that corresponds to the platform of your database server operating system:
- The prompts that appear next may vary, depending on which database platform you use. See the following table for the prompts that you may receive next. Enter the values that you recorded on your Upgrade Planning Worksheet.
NOTE: Use underscores rather than spaces; these values are case-sensitive.
- At the Log Output Directory prompt, enter the directory within $
SIEBEL_ROOT
/siebsrvr/log
where you want the log files to be generated.The default value for the log output directory is
UPGRADEOPTION
_
ENVIRONMENT
_
VERSION
; for example, the default log output directory for a development environment upgrade of the Siebel database schema from Release 6.0.1 would be $SIEBEL_ROOT
/siebsrvr/log/upgrep_dev_601
.NOTE: If you are upgrading to a Release prior to 7.5.3, you will not see the Log Output Directory prompt. Your log files are located under
$
SIEBEL_ROOT
/siebsrvr/log
.The utility displays the values that you entered in the preceeding steps.
- Review the values for accuracy against the values that you recorded in your copy of Upgrade Planning Worksheet.
- If the values are correct, launch the Siebel Upgrade Wizard (
srvrupgwiz
) by enteringY
. The Siebel Upgrade Wizard is explained in Reviewing the Upgrade Log Files.NOTE: If a program or system error occurs and you need to rerun the Siebel Upgrade Wizard, you can do so, starting at the point at which the wizard failed, by navigating to $
SIEBEL_ROOT
/siebsrvr/bin
and typing:
srvrupgwiz /mmaster_UPGRADEOPTION
_
ENVIRONMENT
_
VERSION
.ucf
For example, to restart a development environment upgrade from Release 6.0.1 to Release 7.x, type:
srvrupgwiz /m master_upgphys_dev_601.ucf- If you need to change the values you previously entered, rerun the Configuration Wizard by entering
dbsrvr_config.ksh
. Rerunning the Configuration Wizard will allow you to reconfigure with different values.The Siebel Upgrade Wizard displays a message when the upgrade is complete.
CAUTION: The upgrade process executes in a UNIX shell. Do not click inside this shell while the upgrade is running. If you accidentally click inside the UNIX shell, the process will stop executing and you will need to restart the upgrade.
Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for UNIX Published: 20 October 2003 |