This section provides instructions for installing and configuring Oracle MICROS Reporting and Analytics on one server.
Important:
Review all the information in this section before starting the software installation.Portal WebLogic AdminServer and Reporting and Analytics
Admin Server (optional if needed)
Aggregation and Adjustment Service
InfoDelivery Service
Alert Engine Service
Simphony Mobile Aggregation
Before installing Portal WebLogic AdminServer and Reporting and Analytics on the same server:
Parent topic: Enterprise Back Office on One Server
Oracle MICROS recommends setting the following Oracle Database configurations when creating the database instance and before running an Enterprise Back Office product installer. While some configurations can be changed after the installation, preparing the database instance prior to schema installation can prevent unexpected errors and problems.
Oracle Database Configuration for Enterprise Back Office Database
Parameter | Recommended Value | |
---|---|---|
db_block_size |
16384 |
|
open_cursors |
20000 |
|
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. |
Oracle Database Tablespaces for Enterprise Back Office Database
COREDB
PORTALDB
LOCDB
LOC_INDX
RTA
PENTAHO or SMALLFILE
Not applicable for 9.1 New Tech Stack
CEDB
TEMP
Parent topic: Enterprise Back Office on One Server
Parent topic: Enterprise Back Office on One Server
Parent topic: Enterprise Back Office on One Server
Parent topic: Installing Admin Server
Parent topic: Enterprise Back Office on One Server
C:\temp\
folder during installation, and to the installation path after completing installation.Parent topic: Installing Aggregation and Adjustment
Parent topic: Enterprise Back Office on One Server