Installing Enterprise Back Office on Oracle Database

This chapter describes the prerequisites, instructions, and verification steps for installing the Enterprise Back Office databases on Oracle Database:

Enterprise Back Office Database Configurations

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

Use the following table for a set of guidelines for setting up the Oracle Database instance for Enterprise Back Office:
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

Make sure to create the following tablespaces in the Enterprise Back Office database. Each tablespace requires Transparent Data Encryption (TDE) encryption.
  • COREDB

  • PORTALDB

  • LOCDB

  • LOC_INDX

  • RTA

  • PENTAHO or SMALLFILE

    • Not applicable for 9.1 New Tech Stack

  • CEDB

  • TEMP

Installing the Enterprise Back Office Database

  1. Make sure Oracle Database is installed and running.
  2. Extract the following from the installation file archive in the same file structure. Do not extract the files to a folder structure that contains spaces.

    DBInstall.exe

  3. Double-click DBInstall.exe to launch the database installation wizard.
  4. On the Choose Installation or Upgrade page, select whether you are upgrading an existing database or installing a new shell database.

    If you are installing a new shell database, install a clean Oracle Database server with no Reporting and Analytics objects.

  5. On the Choose Install Set page, select myMicros.
  6. On the MyMicros Database Information page:
    1. To set up the Enterprise Back Office database, select Oracle, enter the network port used by the database server, and then enter the database service name. By default, Oracle Database uses port 1521.
    2. Fill out the rest of the form. For new installations, the form allows you to create passwords for the database users. For upgrades, you must enter the existing passwords.
  7. On the Oracle Agg DB Config page, set up the Enterprise Back Office database:
    1. Enter the hostname, port, and SID of the Enterprise Back Office database server.
    2. For new installations, create a password for the Enterprise Back Office database. For upgrades, enter the existing database password.
  8. For new installations:
    1. On the Additional Users page, create passwords for the database users.
    2. On the Sys Admin Password page, create a password for the sys admin account for the M super organization.
    3. On the Tablespace Locations page, enter the path to the folder for storing the database tablespace files.
  9. On the MyMicros Database Information - Master page, enter the database administrator (DBA) login credentials for the Enterprise Back Office database.
  10. On the MyMicros Database Information - Aggregation Master page, enter the database administrator (DBA) login credentials for the Enterprise Back Office database.
  11. For new installations:
    1. On the Get 6.2 Oracle Tokens page, create a password for an Online Analytical Processing (OLAP) user account.
    2. On the Aggregation Users page, create passwords for the Aggregate_DB users.

      If you are installing the Aggregate_DB schema with the Enterprise Back Office database, enter the same password for the SA, RPT, and UTIL users.

    3. On the Get Oracle Aggregation tokens page, enter the path to the folder for storing the Enterprise Back Office database tablespace and the Enterprise Back Office database index tablespace.
  12. On the Pre-Installation Summary page, click Install and allow the database installation or upgrade to complete.
  13. After installation completes, increase the OPEN_CURSORS parameter for Oracle Database to at least 30,000.

Verifying the Database Installation

  1. Verify that there is a versionnum entry for the Enterprise Back Office database version to which you upgraded in the following databases:
    • AGGREGATE_DB.AGG_VERSION_DB

    • BIREPOS.BIREPOS_VERSION_DB

      • Not applicable for 9.1 New Tech Stack

    • CEDB.CE_VERSION_DB

    • COREDB.CORE_VERSION_DB

    • LOCATION_ACTIVITY_DB.VERSION_DB

    • PORTALDB.PORTAL_VERSION_DB

    • QUARTZ.QUARTZ_VERSION_DB

      • Not applicable for 9.1 New Tech Stack

    • RTA.RTA_VERSION_DB

  2. Check the following logs for errors and exceptions:
    • root\temp\DBinstaller.log

    • root\temp\Logs\eBusiness_DatabaseUpgrade_Install_dateandtime.log