Install and Configure an Oracle Mart › How to Install and Configure an Oracle Mart › Review the Prerequisites for an Oracle Mart

Review the Prerequisites for an Oracle Mart

Before you install the Mart components, help ensure that the minimum system requirements that are outlined in this topic are met.

System requirements for Mart server

Hardware requirements (based on physical hardware performance, not a virtual environment):

• 2 GHZ or higher dual core processor
• 4 GB RAM (8 GB or more for large marts)
• 4 GB of disk space or more as required to support your specific mart

Operating system:

• Microsoft Windows Vista
• Microsoft Windows 2008 Server SP2
• Microsoft Windows 2003 Server SP2
• Microsoft Windows XP SP3
• Microsoft Windows 7

  Notes:

  • CA ERwin Data Modeler has only been certified on the 32-bit versions of the Windows operating systems described in the preceding list. CA ERwin Data Modeler is a 32-bit application. You may experience problems running CA ERwin Data Modeler on a 64-bit operating system.
  • CA ERwin Data Modeler is compatible with Microsoft Windows 8 Release Preview. You may experience problems with shortcuts and CA ERwin DM third-party components.
• Microsoft .NET Framework 3.5 or higher
• All current Microsoft Windows critical updates are applied

Database:

• The Mart Server can use a standalone or can share an existing database server for an Oracle 10g or 11g database.
• To create the Mart, you must be the database schema owner user and you must have the DBA role in the target database on the Oracle server.
• (Optional) You have modified the following parameters in the initialization file (InitSID.ora):

  Remote_OS_Authent=””
  

  OS_Authent_Prefix=TRUE
  

CA ERwin Mart Administrator web client:

• Supported browsers:
  • Microsoft Internet Explorer 8^® or newer
  • Mozilla Firefox^® v.9.0 or newer
  • Google Chrome 14 or newer
  • Apple Safari 5 or newer
• Adobe Flash plug-in version 8 or newer for the respective browser

Other requirements

Help ensure that the following additional requirements are met:

• If you want to use Microsoft IIS as the web server, you have configured it.
• The DBMS is installed and prepared for creating the Mart Database.
• The Mart database is created. At least one user with administrator privileges is present. You have run the initial queries on the Oracle database. For more information about the initial queries, see the Implementation Guide.
• If you want to add Windows Group users as Mart users, you have the Active Directory Server details.

  Note: You can add Windows Group users as normal Mart users, but not the Mart administrator. A Mart administrator must be a database-authenticated user.

Important disclaimer notice on all requirements

1. The requirements that are mentioned previously define the minimum requirements which permit the application to run with reasonable performance based on a small business use case scenario. The actual requirements for an enterprise-wide use case based on larger models and configurations require significantly greater resources to obtain acceptable performance.
2. These requirements are based on actual physical hardware (no virtual environment) and the following assumptions:
   • Minimal to no network overhead (both the database and application servers are locally installed)
   • Vendor's default install of the current version of their software (with all current service or fix packs)
   • No other applications sharing the defined hardware configuration (for example, a “clean” machine)

   Any other hardware/software configurations are acceptable as long as they provide the same (or better) performance characteristics identified.

Back to Top