|
Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Installing the Siebel Database Server and Configuring the Siebel Database > Configuring the Siebel Database on the RDBMS >
Installing the Siebel Database Components
When you choose Install Database from the Siebel Database Operation screen in the Database Server Configuration Wizard, the utility performs several tasks within the database instance you created in Configuring the RDBMS.
- Creates the Siebel schema (tables and indexes) in a specified table space.
- Inserts Siebel seed data specific to your database, and installs views, packages, and procedures for your database.
- Sets system preferences.
Some steps in the procedure in this topic pertain to adding a language to an existing Siebel Database, also using the Database Server Configuration Wizard. Adding a language to an existing Siebel Database installs seed data to support that language. In order to add a new language to previously installed Siebel applications, you must have installed its Language Pack on the Siebel Server using the Siebel Enterprise Server installer. After you have added a language to the Siebel Database, your seed data is multilingual. You must enable the multilingual list of values (MLOV) capability for Siebel Business Applications. For more information, see Configuring Siebel Business Applications and the Global Deployment Guide. See also any applicable documents on this issue on Siebel SupportWeb. For a list of languages supported by Siebel Business Applications in this release, see System Requirements and Supported Platforms on Siebel SupportWeb. To install Siebel Database components
- Launch the Database Server Configuration Wizard, using any method described in Launching the Siebel Software Configuration Wizard.
The Gateway Name Server Address screen appears.
- Type the following values as you recorded them in your copy of the worksheet in Deployment Planning Worksheet and click Next.
Gateway Name Server Address. The domain name and alias of the host on which you installed the Siebel Gateway Name Server.
Enterprise Server Name. The name you gave to your Siebel Enterprise Server, for example, Sieb78.
The Siebel Server Directory screen appears.
- On the Siebel Server Directory screen, do one of the following and click Next:
- On the Siebel Database Server Directory screen, do one of the following and click Next:
- Select the appropriate RDBMS platform and click Next.
IBM DB2 UDB for Windows and UNIX
IBM DB2 UDB for z/OS
Microsoft SQL Server
Oracle Database Enterprise Edition
The Siebel Database Operation screen appears.
- Select Install Database and click Next.
The Siebel User/Role Creation screen appears, prompting you to execute the grantusr.sql script to create table owner and administrator accounts, if you have not already done so.
- Indicate whether or not you have already run the
grantusr.sql script to set up table owner and administrator accounts.
NOTE: These accounts must be in place or you will not be able to complete installation of your tables, indexes, and seed data.
- If you already ran
grantusr.sql, click the top radio button, and then click Next. Proceed to Step 8.
- If you did not already run
grantusr.sql, click the lower radio button, and then click Next. The Configuration Wizard quits. Run the grantusr.sql script, as necessary, and then relaunch the Database Server Configuration Wizard. Go back to Step 1.
- On the Select Installation Operation screen, click Install Siebel Database, and then click Next.
The Install Siebel Database option creates the Siebel schema and inserts seed data at the end of the configuration session.
(If you instead selected Add a language to an existing Siebel Database, proceed to Step 10, and specify the base language for the Siebel Database.)
- On the Database Encoding screen, identify the appropriate database encoding method:
UNICODE
Non-UNICODE
CAUTION: Choose the correct option for your database to prevent installation of the wrong data types. The database will not be able to create Unicode data types on a non-Unicode page setting, so check this setting carefully before choosing the option.
If you are installing a new Siebel Database, proceed to Step 11.
- On the Base Language screen, specify which language is as the primary (base) language for the Siebel Database, and click Next.
The primary (base) language is the language in which you already installed the Siebel Database (the first installed language). This screen appears only if you are adding a language to an existing Siebel Database. However, the screen does not appear if the existing database has only one language.
The languages listed in this screen are those you previously installed on the Siebel Server.
- On the Language Selection screen, choose the language in which you want to run your database (for an install database operation), or choose the language you want to add (for an add language operation). Click Next.
For an install database operation, the language you select will be the primary (base) language for your database (the first language installed).
The languages listed in this screen are those you previously installed on the Siebel Server.
The ODBC Data Source Name screen appears.
- Indicate the name for the ODBC data source, such as
SiebSrvr_Sieb78, and then click Next.
For more information about the ODBC data source, see Planning RDBMS Installation and Configuration.
- On the Database User Name screen, indicate the following about your database and click Next:
Database User Name. Type the user name of the Siebel administrator; for example, sadmin.
Database Password. Type the password for the Siebel administrator.
Database Password (confirm). Retype the password to confirm it.
- On the Database Table Owner screen, indicate the following about your database, and then click Next:
Database Table Owner. Type the name of the Siebel Database table owner, or the account that will own the Siebel objects; for example, ora*** for Oracle and siebel for DB2 UDB and MS SQL Server.
Database Table Owner Password. Type the password for the Siebel Database table owner.
Database Table Owner Password (confirm). Retype the password to confirm it.
- (DB2 UDB only) On the Database Server OS screen, select the platform on which your database server runs, and click Next.
AIX
HP-UX
Solaris
Windows
Linux
- (DB2 UDB only) On the Index Table Space Name screen, indicate the following values, and click Next to continue:
Index Table Space Name. Type the name for your index table space; for example, SBL_INDX.
4K Table Space Name. Type the name for your 4-KB table space; for example, TBS_4K.
NOTE: Table space names should not contain spaces; use underscores, if needed.
- (DB2 UDB only) On the 16K Table Space Name screen, indicate the following values, and click Next to continue:
16K Table Space Name. Type the name for your 16-KB table space; for example, TBS_16K.
32K Table Space Name. Type the name for your 32-KB table space; for example, TBS_32K.
NOTE: Table space names should not contain spaces; use underscores, if needed.
- (Oracle only) On the Index Table Space Name screen, indicate the following values, and click Next to continue:
Index Table Space Name. Type the name for your index table space; for example, DATA01.
Table Space Name. Type the name for your table space; for example, DATA02.
NOTE: Table space names should not contain spaces; use underscores, if needed.
- (Oracle only) In the Oracle Parallel Index screen, specify the appropriate environment for your installation, and click Next to continue:
- I am not running with Parallel Indexing On
- I am running with Parallel Indexing On
If you have a single-CPU environment, choose the first option. If you have a multiple-CPU environment, choose the first or second option, depending on whether you are running with parallel indexing on.
- In the Log Output Directory screen, accept the default log directory, or enter a new directory name, and click OK.
By default, logging will occur in the SIEBSRVR_ROOT\log\operation\output directory, where operation corresponds to the operation you are performing, such as install for Install Database or install_lang for Add language.
A message box appears with the prompt:
To apply the configuration now, press OK.
To apply the configuration later, press Cancel.
The command line to apply the configuration later is
SIEBEL_ROOT\siebsrvr\bin\siebupg.exe /m master_operation.ucf
where, for this procedure, operation may be install or install_lang.
- Respond to the above prompt in one of the following ways:
- Click Cancel if you do not want generated SQL to be executed in the Siebel Upgrade Wizard when configuration is complete. The SQL is generated, but not executed, after you click Finish in Step 22. In this case, you will need to run the Upgrade Wizard manually at a later time in order to execute the generated SQL.
- Click OK if you want generated SQL to be executed in the Siebel Upgrade Wizard when configuration is complete. The SQL is generated, and then executed, after you click Finish in Step 22.
CAUTION: It is strongly recommended to click Cancel, rather than OK. If you click OK, the Siebel Upgrade Wizard starts after you click Finish in Step 22, displaying the items to be executed. Both new customers and upgrade customers must run this wizard to apply the configuration, whether you run it now or run it later using the siebupg.exe command shown in the prompt. Before running the Upgrade Wizard, check the Release Notes on Siebel SupportWeb for the current release. If this document describes any tasks you must perform to modify the generated SQL files, modify the generated SQL as necessary after you click Finish in Step 22. Then run the Upgrade Wizard using the siebupg.exe command shown previously.
NOTE: If you ran the Database Server Configuration Wizard previously, SQL files may already have been generated by the sqlgen.exe program. In this case, this program will not run again in the current session. Whether sqlgen.exe runs depends on the existence of the file DBSRVR_ROOT\COMMON\sqlgen.usg. If this file does not exist, sqlgen.exe will run and SQL files will be regenerated. If you need to force sqlgen.exe to run, you can manually delete sqlgen.usg.
The Configuration Parameter Review screen appears.
- Review the configuration values you entered on the previous screens in the Database Server Configuration Wizard:
- If you need to change any values, use the Previous and Next buttons to access the screens on which to change entries, and then to return to this screen.
- Alternatively, you can click Cancel to cancel the Database Server Configuration Wizard session, then relaunch the wizard and reconfigure with different values.
- When you have verified the configuration values, click Finish. Doing so generates SQL files that you will then apply to the database. When all SQL has been generated, a message appears, stating "The configuration changes were applied successfully." Click OK.
If you clicked Cancel at the prompt in Step 21, the Siebel Upgrade Wizard does not appear. You must run it manually, after reviewing the generated SQL.
If you clicked OK at the prompt in Step 21, the Siebel Upgrade Wizard appears.
NOTE: When you run the Upgrade Wizard, if a program or system error occurs, you can rerun the wizard, starting at the point at which the wizard failed. For details, see the Upgrade Guide.
When the Siebel Upgrade Wizard finishes running, the Siebel Upgrade Wizard Complete screen appears. You have now finished installing the database server components.
|
