- Install and configure the database server.
The documentation provided with the Oracle Database Server products provides complete instructions on installing Oracle Server. Refer to the following for detailed installation instructions:
- Installing Oracle Enterprise: http://www.oracle.com
Perform one of the following two options to create the databases:
- Create two blank databases – one for Collaboration and one for uPerform.
- Create one blank database with two schemas – one for Collaboration and one for uPerform.
Account and Database Information for Oracle
Three accounts are needed for the uPerform databases and are described in the following table. The installer will prompt for names and passwords at the appropriate times.
|
Account Information
|
Description
|
|
Oracle DBA Account
|
The installation requires an account with DBA privileges. The Oracle DBA Account is used only during the installation, and can be a different account than the one used by the Oracle DBA for normal database administration. If you do not wish to create a special Installation Account, you can allow the installer to use the Oracle Server system account for this purpose. If you create an Oracle DBA Account for use with the installation, it must have the DBA role.
NOTE: During installation, the Oracle database system account is used to create a role called INTRASPECT_USER inside the Collaboration database and assigns it to the Collaboration User Account with the following role privileges:
CONNECT
SELECT_CATALOG_ROLE
And grants these privileges:
CREATE TABLE
The Oracle DBA Account grants the following role to the Collaboration User Account:
INTRASPECT_USER
And it grants this privilege:
UNLIMITED TABLESPACE
IMP_FULL_DATABASE
|
|
Collaboration User Account
|
Although the application is multi-user, during normal operation it uses one Oracle account called the Collaboration User Account to communicate with the Collaboration database. The application maintains all information about its users and access policies internally and does not rely on Oracle for managing individual user accounts. The Collaboration User Account is created as part of its installation, and your administrator chooses the user name and password at that time. All Collaboration database tables and indexes used are owned by this account.
|
|
Database User Account
|
Although the application is multi-user, during normal operation it uses one Oracle account called the Database User Account to communicate with the database. The application maintains all information about its users and access policies internally and does not rely on Oracle for managing individual user accounts. The Database User Account is created as part of the installation, and your administrator chooses the user name and password at that time. All publishing database tables and indexes used are owned by this account.
|
Confirm Database Information for Oracle Databases
Verify the following database properties before proceeding.
|
Database Information
|
Description
|
|
Character Sets and Encodings
|
Requires that you use the Oracle UTF8 database character set in order to localize your environment to support languages with characters beyond the basic Latin alphabet.
|
|
Table Space
|
Create metadata and content table spaces in the Collaboration database. The content table space should be at least 500 MB and the metadata table space should be at least 50 MB.
Set the Content and Default table spaces to Users.
|
|
Other
|
Set open_cursors between 1000 and 1500, depending on the memory available.
Set Processes to 165.
|