1. Installation Guide
  2. Install or Upgrade Oracle Argus Safety Database Tier
  3. Install Oracle Argus Safety Database
  4. Create Oracle Argus Safety Database Schema

Create Oracle Argus Safety Database Schema

  1. For Windows—To use the interactive user interface, execute the dbinstallerUI.bat file.

    For silent installation—execute the dbinstaller.bat file.

  2. Create the tablespaces and schemas using the dbinstallerUI. bat or dbinstaller.bat file available at Argus Release Media\Database\Argus Safety.
    • Oracle Argus Safety database schemas:
      • Argus Schema
      • Oracle Argus Interchange Service Schema
      • ESM Query Schema
      • DLP Schema
      • DLP ESM Query Schema

      Note:

      The mapping SQLs for ESM Generation and Import can be executed only through restricted database user account that have access only to Oracle Argus Safety and ESM Schemas (ESM Query Schema and DLP ESM Query Schema).

      These DB users does not have access to create or execute anything that would result in change or alteration of the schema or database.

      DLP Schema and DLP ESM Query Schema are part of Oracle Argus Safety Database, but DLP setup can be enabled or disabled by executing separate batch files shipped with the software.

      Besides, features like Factory Data, DB Upgrade, and Oracle Text are merged with the Create Schema option.

    • Oracle Business Intelligence Publisher Schema—This schema holds the Flexible Aggregate Reporting (FAR) objects and the Japanese PMDA R3 Paper Reports related objects. This schema must always be created.

    Note:

    When creating new users in Oracle, the password can only contain any ASCII Character, 0-9, or any of the following special characters _ # $.

  3. Create Axway B2Bi or Oracle B2B Database Instance (Optional)—Required only for respective gateway being integrated with Oracle Argus Safety.

For more information, see:

Parent topic: Install Oracle Argus Safety Database