Configuring an Oracle repository
- Create a tablespace for with the following values:
- Create a FortiDB user for that has the following privileges:
Block Size (B) | Minimum 16K |
Total SGA size | Minimum 500MB |
Total PGA size | Minimum 100MB |
Segment Space Management | AUTO (Automatic) |
Extent Management | LOCAL |
- CREATE SESSION
- CREATE TABLE
- CREATE SEQUENCE
- UNLIMITED QUOTA for the FortiDB tablespace.
For example, put your database and log files on separate disks.
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