Creating an Oracle Tablespace and user

If using Oracle you will need to create the appropriate database before running the installer. Follow the instructions below for creating a valid Oracle Tablespace and User for:

Oracle 9i
Oracle 10g

These steps will need to be completed before the RMS installer is run

Oracle 9i

Follow the instructions below to complete the tasks in Oracle 9i:

Create a tablespace
Create a user

Creating a tablespace

To create a tablespace for your database:

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

Click OK

Creating a user

To create a database user:

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

Open the Role tab and assign the user the following roles:

CONNECT
CTXAPP (this will only be available if OracleText is installed)
RESOURCE

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 TABLE
UNLIMITED TABLESPACE

Click Create. A blank database is created

With the appropriate Oracle user and table space created you can now install the RMS. For further details, pleaser refer to Installing the RMS.

Oracle 10g

Follow the instructions below to complete the tasks in Oracle 10g:

Create a Tablespace
Create a user

Creating a Tablespace

To create a Tablespace for your database:

Open Enterprise Manager Console on your database server.
Log in to the database server you will be creating the new database on.
Open the Administration tab.
Under Storage, click Tablespaces
Click Create
Enter a name for the new Tablespace.
Under Datafiles, click Add

Enter the following information:

Enter a File Name for the datafile
Set the File Size to a larger number than the default 100mb for high-use systems.
Tick Automatically extend datafile when full (AUTOEXTEND) and specify a suitably high value in the Increment box.

Click Continue to return to the Create Tablespace page, and then click OK to create the Tablespace. The new table will appear in the list of Tablespaces.

Creating a user

To create a database user:

Open the Enterprise Manager Console
Log in to the database server you will be creating the new database on
Open the Administration tab
Under Security, click Users
Click Create

Enter the following information:

Enter a database user name and password
In the Default Tablespace box, enter the name of the Tablespace you created above
In the Temporary Tablespace box, enter the name of a temporary Tablespace. By default, this is TEMP

Open the Roles tab and click Modify

Assign the user the following roles:

CONNECT
CTXAPP (only available if OracleText is installed)
RESOURCE

Click OK
Open the System Privileges tab and click Modify

Select the following System Privileges and click OK:

CREATE TABLE
CREATE PROCEDURE
CREATE SEQUENCE
CREATE SYNONYM
CREATE TRIGGER
CREATE VIEW
CREATE SESSION
UNLIMITED TABLESPACE

Select the database user you created. Ensure that the Default Tablespace and Temporary Tablespace values are correct.

With the appropriate Oracle user and Tablespace created you can now install the RMS. For further details, please refer to Installing the RMS.