======================================================================
            Halcyon PrimeAlert (R) Enterprise Reporter
                         Version 1.1.0

                         README.oracle
======================================================================

PrimeAlert Enterprise Reporter stores report data in its own database. 
Both PostgreSQL Database and Oracle Database are supported.

During the installation of PrimeAlert Enterprise Reporter, you will be
given the option to select either PostgreSQL Database or Oracle Database.
If you choose to use PostgreSQL Database, PrimeAlert Enterprise 
Reporter will install PostgreSQL Database and set it up automatically.

If you choose to use Oracle Database, you need to create a database
and a user dedicated for PrimeAlert Enterprise Reporter BEFORE the 
installation. You will need to provide the database and user information 
when you install PrimeAlert Enterprise Reporter.

The following are suggestions and requirements for using Oracle Database
with PrimeAlert Enterprise Reporter:

1.  Suggested database instance name: HALER
    Suggested database instance service name: HALEReporter
    Suggested database user name: halerdbu

2.  Make sure that the tablespace datafile size for the database user  
    is at least 100MB and is auto-extensible with an unlimited maximum 
    size. Also, the user should have unlimited quota on the tablespace.

3.  The database user should have unlimited resources on CPU/Session,
    CPU/Call, Connect Time, Idle Time, Concurrent Sessions,
    Reads/Session, Reads/Call, Private SGA, Composite Limit (Service
    Units).  

4.  The database user's password should never expire.

5.  The database user has the following system privileges:

        - create session 
        - create table
        - create sequence

6.  The minimum requirements for the following database initialization
    parameters:

        "db_block_size" is 8192
        "db_files" is at least 80 
        "db_file_multiblock_read_count" is at least 8 
        "db_block_buffers" is at least 200
        "shared_pool_size" is at least 75M
        "processes" is at least 50

7.  Make sure the database instance is running, and run the SQL script
    "create_all_tables_for_oracle.sql" to create the database tables that
    are needed by PrimeAlert Enterprise Reporter:

        - Become the root user on the system where the Oracle database
          is running:
          # su -

        - Set the ORACLE_HOME environment variable:
          # export ORACLE_HOME=[Oracle Home Location]
         
        - Make sure PATH contains ORACLE_HOME/bin directory:
          # export PATH=$ORACLE_HOME/bin:$PATH

        - Run the SQL script:
          # sqlplus database_user/password@//host:port/service_name \
            @script_path/create_all_tables_for_oracle.sql    

          where

            port         is the listener port number of the Oracle database
                         instance that you have created for PrimeAlert 
                         Enterprise Reporter;
            service_name is the service name of the Oracle database instance;
            script_path  is the location of the create_all_tables_for_oracle.sql 
                         script. You should be able to find the script in the 
                         same directory as this README.oracle file. 

8.  You can also install some basic report templates by running the provided
    SQL script "insert_report_templates_for_oracle.sql". See above on how to execute an
    SQL script for Oracle. 

9.  During the installation of PrimeAlert Enterprise Reporter, you'll be
    asked to provide the following information:

        - Oracle database host name
        - Database instance service name
        - Database instance listener port
        - Database user name and password 

---//---