Installation
The following instructions assume that all requirements mentioned in the Requirements section of this documentation are met. Especially: an Oracle Database Server up and running.
If you have not yet installed the StatsPack (as delivered by Oracle) into your database - no problem: We make this easy for you providing a script doing all the needed work, including the installation of the OSPRep extensions you wish to use. To do so, the following steps are required:
  1. Change to the install/ directory (below the place where you unpacked OSPRep into)
  2. Open the file spcreate.sh with your favorite editor
  3. In the configuration section, adjust the settings to reflect your needs
  4. Save and execute the script
To verify the successfully execution, a few logfiles will be created: One explicitely by spcreate.sh, and a few more implicitely by the Oracle scripts called.
If you already had the StatsPack installed, you may want to add some of the extensions manually. Please obey the order of execution in those places, where multiple scripts are to be run for one extension:
  1. File Statistics: install/database/fileobj.sql and install/database/getfilestat.sql
  2. Session Statistics: install/database/get_sesstat.sql
  3. Wait Statistics: install/database/waitobj.sql and install/database/getwaits.sql
Furthermore, make sure the needed data are collected after each snapshot is taken (again, the spcreate.sh will set this up for you if you used it). In the database job creating your snapshot, you need to add the appropriate lines after the call to statspack.snap:
  1. File Statistics: get_fileinfo
  2. Session Statistics: get_sesstat
  3. Wait Statistics: get_waitevents
Now we can go to setup OSPRep itself:
  1. Create a directory where the generated reports shall be stored in. This directory should be somewhere below your web servers DOCUMENT_ROOT, if you intend to serve the reports using an IntraNet or InterNet web site.
  2. Create the directories for the Web-Includes. They must be located directly below (i.e. "in") the one created in step 1 and must be named help (for the Online Help pages) and inc for the code snippets.
  3. Create a directory for the scripts. This directory must NOT be below your web servers document root but in a somehow safe place, only accessible by authorized users. This directory is referenced to as "~/scripts" from now on.
  4. Unpack the archive into the ~/scripts directory. Make sure to retain the directory structure inside the archive. A safe way to do so is to copy the osprep*.tgz file to the target directory, change into this directory and run the command tar xzf osprep*.tgz.
  5. Edit the configuration file to reflect your systems settings. The default configuration file is named config and to be found within the ~/scripts directory. For details on this step, see the chapter on configuration.
  6. Create the Web-Includes. To do so, change to the ~/scripts/install directory and run the mkhelp.sh script located there. This will process the template (*.tpl) files and generate the HTML help pages out of them, which will be placed into the help/ directory created in step 2. Other files needed there (as e.g. the help icon) will be copied to their location as well as the code snippets. Optionally set up the Collector Plugins from this directory.
  7. In six days G*d created the heavens and the earth (see Gen 1+2) - the seventh day is Shabbat, and He rested. So get yourself a cup of coffee, tea, or whatever drink you like, and relax for a moment - your (installation) work is done!
And finally: The AddOns. Starting with v0.4.x, the AddOns are already converted from "anonymous blocks" to "stored procedures" - which means, in order to use them, you need to install the osprep package into the database. If you did not install them with the spcreate.sh script described above, this can be done as follows:
  1. Change to the install/database/ subdirectory of your OSPRep installation
  2. Invoke Sql*Plus and connect as the statspack user (perfstat)
  3. Run the following command:
    @pkg_osprep.sql
Now that you succeeded up to this point, continue with the usage page to read important things about how to call the ~/scripts/sreport.sh, ~scripts/charts.sh and ~/scripts/fts_plans.sh scripts. Maybe after a while you want to fine-tune your setup: read more about that on the configuration page.
w3cOSPRep © 2003-2007 by Itzchak Rehberg & IzzySoftIzzySoft