Setting Up the Database (Oracle)
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.