|Oracle® Fusion Middleware WebCenter Sites: Installing and Configuring Supporting Software
11g Release 1 (188.8.131.52.0)
Part Number E29751-02
|PDF · Mobi · ePub|
Use this chapter to set up an Oracle 11g database for your WebCenter Sites installation.
This chapter contains the following sections:
Launch the Oracle Database Configuration Assistant by executing the following command:
In the "Welcome" screen (Figure 1-1), click Next.
Figure 1-1 Database Configuration Assistant: Welcome
In the "Operations" screen (Figure 1-2), select Create a Database and click Next.
Figure 1-2 Operations
In the "Database Templates" screen (Figure 1-3), select General Purpose or Transaction Processing and click Next.
Figure 1-3 Database Templates
In the "Database Identification" screen (Figure 1-4), enter the global database name and the SID. (Oracle recommends using the same value for both; in our example, we are using
contentDB.) When you are finished, click Next.
Figure 1-4 Database Identification
In the "Management Options" screen (Figure 1-5), select the Configure Enterprise Manager check box. Select other options as desired. When you are finished, click Next.
Figure 1-5 Management Options
In the "Database Credentials" screen (Figure 1-6), do one of the following:
If you are installing a production system, select Use Different Administrative Passwords, enter a unique password for each database user shown in the table, and click Next.
If you are installing a non-production system, select Use the Same Administrative Password for All Accounts, enter and re-enter a password, and click Next.
Figure 1-6 Database Credentials
In the "Storage Options" screen (Figure 1-7), select File System and click Next.
Figure 1-7 Storage Options
In the "Database File Locations" screen (Figure 1-8), select Use Database File Locations from Template (unless you want to use custom file names and locations) and click Next.
Figure 1-8 Database Configuration Assistant: Database File Locations
In the "Recovery Configuration" screen (Figure 1-9), leave the default values and click Next.
Figure 1-9 Recovery Configuration
In the "Database Content" screen (Figure 1-10), click Next.
Figure 1-10 Database Content
In the "Initialization Parameters" screen, do the following:
In the Memory tab (Figure 1-11), set the preferred memory size for your database:
For the development system, set the preferred memory size to 512MB.
For the production system, the value you enter depends on the size and contents of your database.
Figure 1-11 Initialization Parameters - Memory
In the Character Sets tab (Figure 1-12), do the following:
Select the Use Unicode (AL32UTF8) radio button.
In the "National Character Set" drop-down list, select UTF-8 - Unicode 3.0 UTF-8 Universal Character Set.
Figure 1-12 Initialization Parameters - Character Sets
In the "Security Settings" screen (Figure 1-13), click Next.
Figure 1-13 Security Settings
In the "Automatic Maintenance Tasks" screen (Figure 1-14), click Next.
Figure 1-14 Automatic Maintenance
In the "Database Storage" screen (Figure 1-15), review the selected file locations. (If you need to make changes, click File Location Variables.) Click Next.
Figure 1-15 Database Storage
In the "Creation Options" screen (Figure 1-16), click Finish.
Figure 1-16 Creation Options
In the "Confirmation" screen (Figure 1-17), review the selected options, then click OK.
Figure 1-17 Confirmation Screen
Allow the database creation tasks to complete (Figure 1-18). If any one of the tasks fails, remedy the problem before continuing.
Figure 1-18 Database Configuration Assistant
At the summary screen (Figure 1-19), make a record of the database SID and the database control URL, then click Exit.
Figure 1-19 Database Creation Complete
Before you begin, determine the Console Server port:
emoms.properties file in a text editor. The file is located in:
Find the line,
and make a record of the port number value at the end of the line.
Log in to the Oracle Enterprise Manager console:
Execute the following command:
emctl status dbconsole
The command should return an output similar to the following:
Oracle Enterprise Manager 11g Database Control Release 184.108.40.206.0 Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved. https://localhost.localdomain:1158/em/console/aboutApplication Oracle Enterprise Manager 11g is running. ------------------------------------------------------------------ Logs are generated in directory /u01/software/DB/Oracle/oracledb/product/11.1.0/db_1/localhost.localdomain_vmorcldb/sysman/log
Open a browser and go to the URL highlighted in bold in step a above. If you see a "Security Mismatch" error, ignore it (the error appears if you are using a self-signed certificate).
Figure 1-20 Enterprise Manager - Login
In the tab bar (Figure 1-21), click Server.
Figure 1-21 Enterprise Manager Tabs
Create the new user (Figure 1-22). Do the following:
In the "Security" section of the page, click Users.
Figure 1-22 Server Tab
Click Create near the top right corner of the user list (Figure 1-23).
Figure 1-23 Users
In the "Create User" form (Figure 1-24), fill in all required fields (marked with an asterisk). Fill in all other fields as necessary.
Figure 1-24 General Tab
Select the default and temporary tablespaces for the new user (Figure 1-25). Do the following:
The actual tablespace may differ depending on your installation. For more information about the tablespace for your installation, see your database administrator.
Select the default tablespace:
In the "Create User" form, click the flashlight button next to the Default Tablespace field.
In the form that appears, select the USERS radio button.
Figure 1-25 Search and Select: Tablespace
Select the temporary tablespace:
In the "Create User" form, click the flashlight button next to the Temporary Tablespace field.
In the form that appears, select the TEMP radio button.
Assign roles to the new user (Figure 1-26), as required.
In the tab bar, click Roles.
Figure 1-26 Roles Tab
Click Edit List at the top right corner of the list of roles.
In the "Available Roles" list, select the required roles and click Move.
The roles appear in the "Selected Roles" list.
Assign system privileges to the new user. Do the following:
In the tab bar (Figure 1-27), click System Privileges.
Figure 1-27 System Privileges Tab
Click Edit List at the top right corner of the list of privileges.
In the "Available System Privileges" list, select CREATE SESSION, CREATE TABLE, CREATE VIEW, and UNLIMITED TABLESPACE, then click Move.
The privileges are moved to the "Selected System Privileges" list.
Figure 1-28 System Privileges - Unlimited Tabspace
Click OK (Figure 1-28).
A message confirming the creation of the new user is displayed (Figure 1-29). The user appears in the list of users.
Figure 1-29 Users
You are now ready to create and configure the data source. For instructions, refer to the Oracle Fusion Middleware WebCenter Sites Installation Guide.