Goals To install the Siebel database Time 75 – 90 minutes
Instructions:
In this practice, you will run the Siebel Database Server Configuration Tool to configure the Siebel database. An empty Oracle database named siebeldb has already been created for you, containing two tablespaces: siebelts to contain the Siebel data tables, and siebelindexts to contain the Siebel indexes. Before running the Configuration Tool, you need to run a SQL script to create the necessary Siebel users and roles in this database. A sample script named grantusr.sql was installed as part of the Database Configuration Utilities installation. You first need to edit grantusr.sql to match your installation before running it.
1. Edit grantusr.sql to set the correct parameters. This is typically performed by the DBA.
a. Use Windows Explorer to create a backup copy of D:\OUses\dbsrvr\Oracle\grantusr.sql by copying it and pasting it in the same directory.
b. Use Notepad to open D:\OUses\dbsrvr\Oracle\grantusr.sql.
c. Scroll down to the section on creating db accounts for Siebel users.
d. Copy, paste, and edit the four lines which create SADMIN and create two new users:
GUESTERM with password GUESTERM and GUESTCST with password GUESTCST.
These are the HI and SI anonymous users, respectively.
Oracle Internal & Or acle Academy Use Only
e. Add two additional lines:
alter user SADMIN quota unlimited on &&siebel_indexspace;
alter user SIEBEL quota unlimited on &&siebel_indexspace;
These lines ask for a siebel_indexspace, and then grant SADMIN and SIEBEL permission to access that tablespace. Verify that your grantusr.sql looks like the screen shot below:
Course Note: An edited version of grantusr.sql is available in
D:\labs\8.1_Install\Solutions\DB. Consider comparing your edited version with this version before running it.
f. Save and close grantusr.sql.
2. Run grantusr.sql against the database. A database named siebeldb has been created for you with two tablespaces: siebelts for Siebel data, and siebelindexts for Siebel indexes.
a. Select Start > Programs > Oracle - OraDb10g_home1 > Application Development > SQL Plus.
b. Enter the following parameters:
User Name system Password oracle Host String SIEBELDB
c. Click OK. You should receive a SQL> prompt.
d. At the SQL> prompt, enter:
@D:\OUses\dbsrvr\Oracle\grantusr.sql
Oracle Internal & Or acle Academy Use Only
Lesson 3: Installing the Siebel Database
Course Note: All of the text commands used in this course are contained in text files,
allowing you to copy and paste the commands instead of having to type them manually. The above command is contained in D:\labs\8.1_Install\Solutions\DB\SQLCommands.txt.
e. Enter siebelts as the value for siebel_tablespace.
f. Enter temp as the value for temp_tablespace.
g. Enter siebelindexts as the value for siebel_indexspace.
h. All grants should succeed.
i. Minimize SQLPlus.
3. Examine some of the DDL and SQL files used to populate the database:
a. Using Windows Explorer, navigate to D:\OUses\dbsrvr\ORACLE.
b. Right-click applet.ddl and select Send To > Notepad.
c. Examine the contents of applet.ddl. Notice that this data definition defines the database tables and indexes used to support applets.
d. Close applet.ddl, not saving any changes.
e. Right-click ddlview.sql and select Send To > Notepad.
f. Examine the contents of ddlview.sql. This is the SQL code used to create database views (sets of columns from tables) used by the Siebel application when accessing the database.
Database views are not the same as Siebel application views.
g. Close ddlview.sql, not saving any changes.
h. Right-click ddl.ctl and select Send To > Notepad.
i. Examine the contents of ddl.ctl. This is a data definition file defining a large number of the tables and indexes of the Siebel database schema.
j. Close ddl.ctl, not saving any changes.
4. Double-click D:\labs\8.1_Install\SIAkeys.txt and carefully copy the first license key to the clipboard; that is, copy the first line of the text file. There are multiple keys listed in the file.
Minimize Notepad once you have copied the key.
5. Generate the Siebel database:
a. Select Start > Programs > Siebel Enterprise Server Configuration 8.1 > Database Server Configuration to launch the Database Configuration Wizard.
Oracle Internal & Or acle Academy Use Only
b. Enter the parameters below, being careful not to switch SIEBEL with SADMIN, and clicking Next each time to proceed through the configuration:
Note: Throughout this course, tables such as the one below are used to provide parameters for multiple installation screens. If you are trying to enter a parameter from the table and do not see it on the screen, please click Next to advance to the next screen. Similarly, in later practices the final confirmation steps (such as clicking Next in the Summary screen) may be omitted.
Parameter Value Purpose
Siebel Server
Directory D:\OUses\siebsrvr Used to access Siebel Server executables and template files.
Siebel Database
Server Directory D:\OUses\dbsrvr Used to access Siebel Database Server executables and template files.
Database
Platform Oracle Database Enterprise Edition
Determines which SQL scripts to run to populate the schema and seed data.
Action Install Database Used to create the schema and seed data.
Option Install Siebel Database Install a database or add a language.
Option Yes, I wish to install a new Siebel Database
Verify database installation.
GRANTUSR.SQL GRANTUSR.SQL has been run by the DBA to create Siebel users and roles
Specify that GRANTUSR.sql has been run.
UNICODE UNICODE Database Determines available character sets.
ODBC Data
Source Name OUEnt_DSN Used to connect to database. Enterprise name suffixed by _DSN. This connection was created when you configured the Siebel Enterprise.
Database User
Name SADMIN Used to populate seed data.
Database Password - and confirm
SADMIN Used to populate seed data.
Database Table
Owner SIEBEL Used to generate schema.
Database Table Owner Password - and confirm
SIEBEL Used to generate schema.
Index Table
Space Name siebelindexts Contains Siebel indexes. This tablespace was created for you by your DBA.
Table Space
Name siebelts Contains Siebel data tables. This tablespace was created for you by your DBA.
Enter license
key? Yes, I would like to enter it now
Enter the license key to allow initial login; license keys may be added later, if desired. However, if you do not enter a license key, you will need to use the Siebel Developer Web client to enter one later.
License Key <Copy and paste first line from
D:\labs\8.1_Install\SIAkeys
License keys are available from Oracle at http://licensecodes.oracle.com.
Oracle Internal & Or acle Academy Use Only
Lesson 3: Installing the Siebel Database
.txt >
Parallel Indexing Does not use the Oracle Parallel Indexing option
For database servers with multiple CPUs, using multiple indexing threads can improve
performance. It is not enabled in the classroom.
Security Group
ID/Grantee SSE_ROLE Default database role for Siebel users; created by GRANTUSR.SQL.
Log Output
Directory install Where to store installer log information.
c. Select “Yes apply configuration changes now” and click Next.
d. Review the summary and click Next.
e. Click Yes to execute the configuration.
f. Click OK to begin the database installation. The database installation should take approximately 60-75 minutes.
Note: Notify your instructor once you have started the database installation. Once all students have started the database installation, it is a good time for either a lunch break or the next lecture.
g. Once installation completes, click OK to close the Upgrade Wizard.
h. Switch to the Oracle Installer application and click OK in the Execution Successful dialog box.
i. Click Cancel to exit the configuration tool.
j. Click Yes to confirm the cancellation.
6. Verify the database installation:
a. In SQLPlus, enter:
connect SIEBEL/SIEBEL;
This connects you as the Siebel database owner. Do not forget the semicolon.
b. Enter
select count (*)from S_ZIPCODE;
This returns the number of records in the Zip Code table. It should be a number in the thousands. If it is 0, contact your instructor.
c. Enter exit
to exit SQLPlus.
Oracle Internal & Or acle Academy Use Only
Oracle Internal & Or acle Academy Use Only
Lesson 4: Installing a Siebel Server