Creating an Oracle 9i Release 2 database

Applies to the following products: 
Questionmark Perception
Applies to the following Perception versions: 
Perception 5.2
Perception 5.1

To create an Oracle database for use with Perception, you need to:

How you perform these steps will depend on which version of Oracle you are using. The instructions given below assume that you are using Oracle 9i Release 2. If you are using 10g or 11g , please refer to Creating an Oracle 10g or 11g database.

We assume that your Oracle installation is already in place and that you are familiar with administering Oracle databases. We also assume that you are able to log on to Oracle under an account with Oracle DBA privileges and that you have created a table space using the correct Character Sets. For further information on the correct Character Sets to use in a table space please refer to Supported databases in the System Requirements section.

If you will be using Japanese characters with an Oracle database on an English operating system, you will need to set the NLS_Characterset to WE8MSWIN1252 when you install your Oracle server. Otherwise you will need to set the NLS_Characterset to AL32UTF8. Refer to Oracle Help for more information.

Creating a Tablespace

To create a Tablespace for your database:

  1. Open Enterprise Manager Console
  2. Log in to the database server you will be creating the new database on
  3. Expand the database server folder and expand the Storage sub-folder
  4. Right-click Tablespaces and click Create
  5. Enter a name and double-click the entry in the Size field to open the Create Datafile dialog
  6. Set the File Size to 50 megabytes. You should set this to a larger number for high-use systems
  7. Open the Storage tab and tick Automatically extend datafile when full (AUTOEXTEND)

  8. Click OK

Creating a database user

To create a database user:

  1. Open the Enterprise Manager Console.
  2. Log in to the database server you will be creating the new database on.
  3. Expand the Security folder.
  4. Right-click Users and click Create... The Create User dialog is displayed.
  5. Enter a name for the new database user and under Tablespaces, select the Tablespace you just created from the Default drop-down list.

  6. Open the Role tab and assign the user the following roles:
    • CONNECT
    • CTXAPP (this will only be available if OracleText is installed)
    • RESOURCE

  7. Open the System Privileges tab and assign the user the following System Privileges. While these system privileges are part of the Roles set previously (CONNECT and RESOURCE) they need to be added independently due to the way that Perception is configured to use Oracle
    • CREATE SESSION
    • CREATE ANY TABLE
    • CREATE TABLE
    • DROP ANY TABLE
    • UNLIMITED TABLESPACE
  8. Click Create. A blank database is created
To be able to change security settings for administrators using Authoring Manager, you will also need to assign the CREATE TABLE system privilege to the individual user who will be changing the security settings

Next, you will need to configure the Local Service Name and then create an ODBC data source. This process is the same for Oracle 10g or 11g databases as it is for Oracle 9i Release 2 databases. Therefore, please refer to the following sections in the Creating an Oracle 10g or 11g database section for instructions: