Install one of the supported Oracle Database versions. To prevent future errors, the table below shows the recommended Oracle Database configuration values. Set these values before running the Inventory Management installer.
Parameter | Recommended Value | |
---|---|---|
Instance Name |
<CustomerName><Environment ID><EnvironmentPurpose P/S/T>INV For example, for customer ABC, environment ID 1, and environment purpose P for production: ABC01PINV |
|
db_block_size |
8192 |
|
open_cursors |
1000 |
|
db_recovery_file_dest_size |
Set as the amount of storage allocated to FRA and DATA. |
|
job_queue_processes |
64 |
|
aq_tm_processes |
1 |
|
session_cached_cursors |
100 |
|
optimizer_mode |
first_rows_10 |
|
optimizer_index_caching |
20 |
|
optimizer_index_cost_adj |
20 |
|
cusrsor_sharing |
exact |
|
processes |
1024 |
|
sga_max_size |
Set as 50% of database RAM, to be tuned by the DBA during the life of the environment. |
|
sga_target |
Set as the same value as sga_max_size. |
|
pga_target |
Set as 25% of sga_target. |
Parent topic: Prerequisites