Oracle 10g/11g

Step 1: Download the Cascade Server database

Download the Cascade Server database.

We strongly recommend using an existing database with a UTF-8 enabled character set. This is necessary to take advantage of Cascade Server's multi-lingual support.

Also, we recommend creating a separate tablespace for the Cascade Server database. See below for more information on creating the tablespace.

Step 2: Create new Tablespace

Using Oracle Enterprise Manager:

• Go to Administration -> Tablespaces, then click Create.
• For the Name field, enter CASCADE_DEFAULT
• Under Datafiles,click Add (As an alternative, one can avoid adding a datafile by checking the Use bigfile tablespace check box. However, creating a separate file is highly recommended)
• At the Add Datafile screen, type CASCADE_DEFAULT.DBF in the File Name field
• Point the File Directory field to the desired location
• For the File Size field, type 30 MB
• Under Storage, check the option to "Automatically extend datafile when full (AUTOEXTEND)"
• For the Increment field, type 2 MB. Click Continue
• Click OK to create the tablespace. The generated SQL should look like this:

  CREATE SMALLFILE TABLESPACE "CASCADE_DEFAULT" DATAFILE
  
  '/u01/app/oracle/oracle/product/10.2.0/db_1/oradata/orcl/CASCADE_DEFAULT.DBF'
  
  SIZE 30M AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED
  
  LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE
  
  MANAGEMENT AUTO
  

Step 3: Import the Cascade Server database

Using Oracle Enterprise Manager:

• Click Maintenance -> Import from Export Files
• For the Directory Object field, select the directory where the Cascade Server import script resides. For the File Name field, type CASCADE_DEFAULT.DMP
• Under Import Type select Entire Files
• Under Host Credentials fill in the OS Username and Password for the Oracle account, then click Continue
• On the next screen (Import: Re-Mapping) - unless a tablespace and/or user other than CASCADE_DEFAULT has been created, simply click Next
• Under Import: Options it is recommended to create a log file of the import. Select a Directory Object and under Log File type the name of the file (e.g. CASCADE_DEFAULT.LOG) and click Next
• For the Job Name field, type the desired name (e.g. cascade_import - note that the name has to be unique). Type an optional description in the Description field and click Next
• Under Import: Review, review the import information and verify that everything is correct. Click Submit Job

Your Oracle database is now configured and ready to be used by Cascade Server.