Skip Headers

Oracle Content Management Software Development Kit (Oracle CM SDK) Installation Guide
Release 9.0.3 for Windows NT/2000

Part Number B10053-01
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

A
Creating an Oracle Database

This appendix provides summary information for creating a new database instance to support Oracle Content Management SDK (Oracle CM SDK); it includes information about:

You can also follow these instructions to create an Oracle database instance to support the Oracle Internet Directory server.

Using the Oracle Database Configuration Assistant to Create a Database

These instructions presume that the Oracle software has been installed (using the Oracle Universal Installer) into an Oracle home. The instructions begin after the Oracle Database Configuration Assistant has been launched. The Oracle Database Configuration Assistant is located in:

ORACLE_HOME\assistants\dbca

  1. Select the General Purpose or Transaction Processing database template to ensure that initialization and other database sizing parameters meet or exceed all requirements listed in the Pre-installation requirements.

    The General Purpose or Transaction Processing template also creates the necessary password file for the database, which must be there during Oracle CM SDK configuration. The password file enables you to connect to the service name using SYS as SYSDBA.

  2. Enter a name for the database.

  3. Select Unicode (UTF8) as the database character set to enable full multi-language functionality in Oracle CM SDK. Specifying a different database character set may limit Oracle CM SDK functionality.

    When you finish selecting all the specifics of the database, the Oracle Database Configuration Assistant launches and creates the database, giving it the name entered in Step 2.

    After creating the database, you should logon to the database and change the system/manager and sys/change_on_install passwords (you can also do this during the Database Configuration Assistant process).

  4. Use the command-line version of SQL*Plus to logon to the database and change the default sys password:

    prompt>sqlplus /nolog
    connect sys/change_on_install as sysdba
    Connected.
    SQL>alter user sys identified by new-password;
    
    

Once the database is operational, you should create tablespaces for the various Oracle CM SDK schema objects, such as Oracle Text tables and indexes.

Creating Custom Tablespaces

During Oracle CM SDK configuration, you must select whether to store all schema objects in the USERS tablespace, or in custom tablespaces. For a production environment, the USERS tablespace is likely not optimal, so Oracle recommends creating custom tablespaces for the various tables and indexes that comprise the system (see Table A-1) before attempting to configure Oracle CM SDK.

To create custom tablespaces for Oracle CM SDK, Oracle recommends that you:

See Table A-1 for additional information about the various custom tablespaces and what they contain. Note the names and specifics of any custom tablespaces you create in the table, if you like.

For more information about creating tablespaces and about locally managed tablespaces, the Oracle9i Database Administrator's Guide, Volume 1, Chapter 11, "Managing Tablespaces."

Table A-1 Custom Tablespace Definitions for Oracle CM SDK
Tablespace Description Your Custom Tablespace Name

Primary

Stores metadata for documents, information about users and groups, and other Oracle CM SDK object data. (50 MB)

Non-Indexed Media

Stores LOB data for documents that are not indexed by Oracle Text, such as zip files. (50 MB)

Indexed Media

Stores LOB data for documents indexed by Oracle Text, such as text and word processing files. (50 MB)

interMedia Media

Stores LOB data for documents indexed by Oracle interMedia, such as image, audio, and video files. (50 MB)

Oracle Text Index

Stores the Oracle Text tokens table. (50 MB)

Oracle Text Keymap

Stores the index on the Oracle Text tokens table. (50 MB)

Oracle Text Data

Stores the Oracle Text tables (150 MB)


Go to previous page Go to next page
Oracle
Copyright © 1999, 2002 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents
Go To Index
Index