Installation (software-only) : Configuring the FortiDB repository database : Configuring an Oracle repository
 
Configuring an Oracle repository
1. Create a tablespace for FortiDB with the following values:
Block Size (B)
Minimum 16K
Total SGA size
Minimum 500MB
Total PGA size
Minimum 100MB
Segment Space Management
AUTO (Automatic)
Extent Management
LOCAL
2. Create a user for FortiDB that has the following privileges:
CREATE SESSION
CREATE TABLE
CREATE SEQUENCE
UNLIMITED QUOTA for the FortiDB tablespace.
3. Make any changes to your configuration that can reduce the risk of competition for input/output resources (I/O contention).
For example, put your database and log files on separate disks.
4. Create a datafile for the FortiDB tablespace. For example:
File Name
FORTIDB.DBF
File Directory
C:\oralce\product\10.2.0\oradata\orcl\
Tablespace
FORTIDB
File Size
500M
AUTOEXTEND
ON (automatically extends datafile when it is full)
Here is an example of the parameters in init.ora (for Oracle 10g):
*.db_name='fortidb'
*.db_block_size=8192
*.sga_target=584M
*.pga_aggregate_target=194M
*.db_create_file_dest='/home/oracle/product/10.2.0/db_1/oradata/fdb'
*.db_recovery_file_dest='/home/oracle/product/10.2.0/db_1/flash_recovery_area'
*.db_recovery_file_dest_size=2G
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.audit_file_dest='/home/oracle/product/10.2.0/db_1/admin/fdb/adump'
*.user_dump_dest='/home/oracle/product/10.2.0/db_1/admin/fdb/udump'
*.core_dump_dest='/home/oracle/product/10.2.0/db_1/admin/fdb/cdump'
*.background_dump_dest='/home/oracle/product/10.2.0/db_1/admin/fdb/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/home/oracle/product/10.2.0/db_1/oradata/fdb/control01.ctl'
*.db_file_multiblock_read_count=16
*.job_queue_processes=10
*.open_cursors=300
*.processes=150