Difference between revisions of "Installation"

From zzat
Jump to: navigation, search
Line 41: Line 41:
 
# The schema name of the application user on TARGETS 
 
# The schema name of the application user on TARGETS 
 
# The schema name of the repository owner on the REPOSITORY
 
# The schema name of the repository owner on the REPOSITORY
# The database link user account.
+
# The database link user account
 
# The database link name to use
 
# The database link name to use
 
# Email configuration
 
# Email configuration
Line 48: Line 48:
 
# alter system configuration
 
# alter system configuration
 
# zztat sys-helper configuration
 
# zztat sys-helper configuration
 +
The first section in points 1 through 5 are the mandatory configuration. These determine how and where zztat will be setup by the installer.
 +
 +
The second section in points 6 through 10 are the optional configuration. These determine which zztat features will be available in your installation.
 +
 +
<u>Go through the setup.sql file in detail - it contains a lot of information. Failing to edit the file properly may result in a failing or broken installation.</u>

Revision as of 07:49, 12 August 2017

Installation prerequisites

The following requirements must be met in order for zztat to install and run successfully:

  • Oracle version 11.2.0.4, 12.1.0.1, 12.1.0.2, 12.2.0.1 or higher
  • Access to basic SYS packages (normally these are executable by PUBLIC):
    • dbms_aq
    • dbms_aqadm
    • dbms_crypto
    • dbms_db_version
    • dbms_utility
    • dbms_lob
    • dbms_lock
    • dbms_scheduler
    • dbms_session
    • dbms_sql
    • dbms_stats
    • utl_call_stack (Oracle 12.1+)
    • utl_mail (see details below)
    • utl_raw
  • job_queue_processes > 0
  • Your environment and policies should allow granting the following system privileges to the zztat users:
    • CREATE ANY CONTEXT
    • CREATE CLUSTER
    • CREATE JOB
    • CREATE PROCEDURE
    • CREATE SEQUENCE
    • CREATE SESSION
    • CREATE SYNONYM
    • CREATE TABLE
    • CREATE TRIGGER
    • CREATE TYPE
    • CREATE VIEW
    • DROP ANY CONTEXT
    • MANAGE SCHEDULER
    • Note that these privileges are mandatory for zztat to function. Granting them to zztat via roles is currently not supported - they must be direct grants.

Setting up your Installation

zztat is delivered as a tar-ball. To begin, you may want to distribute this to at least two servers hosting Oracle databases: One which will become the zztat repository and one which will become a target database monitored by zztat.

After you extract the tar-ball you will find a number of scripts. The first file to work with is setup.sql, which is grouped into several sections:

  1. Tablespace where we store our data
  2. The schema name of the application user on TARGETS 
  3. The schema name of the repository owner on the REPOSITORY
  4. The database link user account
  5. The database link name to use
  6. Email configuration
  7. dbms_system configuration
  8. alter session configuration
  9. alter system configuration
  10. zztat sys-helper configuration

The first section in points 1 through 5 are the mandatory configuration. These determine how and where zztat will be setup by the installer.

The second section in points 6 through 10 are the optional configuration. These determine which zztat features will be available in your installation.

Go through the setup.sql file in detail - it contains a lot of information. Failing to edit the file properly may result in a failing or broken installation.