Index: openacs-4/packages/acs-core-docs/www/xml/install-guide/maintenance.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/xml/install-guide/maintenance.xml,v diff -u -r1.13 -r1.14 --- openacs-4/packages/acs-core-docs/www/xml/install-guide/maintenance.xml 22 Mar 2004 12:38:12 -0000 1.13 +++ openacs-4/packages/acs-core-docs/www/xml/install-guide/maintenance.xml 14 May 2004 13:28:11 -0000 1.14 @@ -684,6 +684,49 @@ + + + Creating an appropriate tuning and monitoring environment + + The first task is to create an appropriate environment for finding out + what is going on inside Oracle. Oracle provides Statspack, a package to + monitor and save the state of the v$ performance views. These reports + help finding severe problems by exposing summary data about the Oracle + wait interface, executed queries. You'll find the installation + instructions in $ORACLE_HOME/rdbms/admin/spdoc.txt. Follow the + instructions carefully and take periodic snapshots, this way you'll be + able to look at historical performance data. + + + + Also turn on the timed_statistics in your init.ora file, so that + Statspack reports (and all other Oracle reports) are timed, which makes + them a lot more meaningful. The overhead of timing data is about 1% per + Oracle Support information. + + + + + To be able to get a overview of how Oracle executes a particular query, + install "autotrace". I usually follow the instructions here http://asktom.oracle.com/~tkyte/article1/autotrace.html. + + + Make sure, that the Oracle CBO works with adequate statistics + + + The Oracle Cost Based optimizer is a piece of software that tries to find + the "optimal" execution plan for a given SQL statement. For that it + estimates the costs of running a SQL query in a particular way (by default + up to 80.000 permutations are being tested in a Oracle 8i). To get an + adequate cost estimate, the CBO needs to have adequate statistics. For + that Oracle supplies the dbms_stats + package. + + + + ($Id$) Index: openacs-4/packages/acs-core-docs/www/xml/install-guide/oracle.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/xml/install-guide/oracle.xml,v diff -u -r1.15 -r1.16 --- openacs-4/packages/acs-core-docs/www/xml/install-guide/oracle.xml 14 May 2004 12:52:54 -0000 1.15 +++ openacs-4/packages/acs-core-docs/www/xml/install-guide/oracle.xml 14 May 2004 13:28:11 -0000 1.16 @@ -1,146 +1,141 @@ - %myvars; ]> - + Install Oracle 8.1.7 By Vinod Kurup - - - Skip this section if you're not interested in Oracle. - - - - Oracle is a very complex system ....to be continued by Joel + + If you are installing PostGreSQL instead of Oracle, skip this section. + + + OpenACS &version; will install with Oracle 9i but has not been extensively tested so may still have bugs or tuning issues. + + + + This installation guide attempts to present all of the information necessary to complete an OpenACS installation. We try hard to make all of the steps possible in one pass, rather than having a step which amounts to "go away and develop a profound understanding of software X and then come back and, in 99% of all cases, type these two lines." The exception to our rule is Oracle production systems. This page describes a set of steps to get a working Oracle development server, but it is unsuitable for production systems. If you will be using OpenACS on Oracle in a production environment, you will experience many problems unless you develop a basic understanding of Oracle which is outside the scope of this document. T - - - OpenACS &version; will install with Oracle 9i but has not been extensively tested so may still have bugs or tuning issues. - - - - - This document assumes that you'll be installing Oracle on the same - box as AOLserver. For more details on a remote Oracle installation, - see Daryl Biberdorf's document. - - - - - - Useful links to find help on how to set up Oracle under Linux are: - -Dizwell - Howard - Roger's company - on Oracle on Linux - -Werner Puschitz - Oracle on Red Hat Linux - -SuSE/Oracle Support matrix - - - - - + + + This document assumes that you'll be installing Oracle on the same + box as AOLserver. For more details on a remote Oracle installation, + see Daryl Biberdorf's document. + + + + + Useful links to find help on how to set up Oracle under Linux are: + + + + + Dizwell - Howard + Roger's company - on Oracle on Linux + + + Werner Puschitz - Oracle on Red Hat Linux + + + + SuSE/Oracle Support matrix + + Acquire Oracle - If you plan to use Oracle or you are already using alredy, you need to - decide on the operating system platform which you are going to - use. Follow the metalink - note 223718.1to find certified platforms. You need an support - contract to have a metalink account - the bottom line of the - certification matrix is that free or inexpensive Linuxes are not - certified. + Production Oracle systems should run on certified platforms. Follow the metalink + note 223718.1to find certified platforms. You need an support + contract to have a metalink account. In summary, free and inexpensive Linux distributions are not certified. - If you don't have an account at OTN + If you don't have an account at OTN get one: you can download the Oracle software from the Oracle Downloads page. It is also get the CDs shipped to you for - a nominal fee from the Oracle - Store. + a nominal fee from the Oracle + Store. Each Oracle release comes with extensive and usually quite well-written documentation. Your first step should be to thoroughly read the release notes for your operating system and your Oracle version. Find the docs - here: + here: + Oracle 8i - Release Documentation + Release Documentation - + Oracle 9i Release Documentation + - + Oracle - 10g Release Documentation + 10g Release Documentation - + It is generally useful to run a particular Oracle version with its latest patchset. At the time of writing these were 8.1.7.4 and 9.2.0.5, both of which are considered to be very stable. - To be able to download a patchset, you need a (to-pay-for) account on Metalink. You may find the appropriate - patchset by following Andrew's - suggestion. + To be able to download a patchset, you need a (to-pay-for) account on Metalink. You may find the appropriate + patchset by following Andrew's + suggestion. - - Things to Keep in Mind - Oracle is very well-documented software, the online documentation comes with + Oracle is very well-documented software, the online documentation comes with printable PDFs and full-text search. Altogether there is more than 20.000 pages of documentation, so do not expect to understand Oracle within in a few hours. The best starting pointing into Oracle is the - Concepts book. Here's the 8i - version and the 9.2 - version. + Concepts book. Here's the 8i + version and the 9.2 + version. To give you an idea of how configurable Oracle is and how much thought you may need to put into buying the proper hardware and creating a sane - setup, you should thoroughly read Cary Millsap's Configuring - Oracle Server for VLDB and the Optimal - Flexible Architecture standard. + setup, you should thoroughly read Cary Millsap's Configuring + Oracle Server for VLDB and the Optimal + Flexible Architecture standard. @@ -158,7 +153,7 @@ In order for OpenACS to work properly you need to set the environment appropriately. - + export ORACLE_BASE=/ora8/m01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/8.1.7 @@ -172,7 +167,6 @@ open_cursors = 500 - nls_date_format = "YYYY-MM-DD" @@ -183,53 +177,12 @@ url="http://openacs.org/forums/message-view?message_id=28829">thread and Andrew - Piskorski's mini-guide.. + Piskorski's mini-guide. - - Creating an appropriate tuning and monitoring environment - - The first task is to create an appropriate environment for finding out - what is going on inside Oracle. Oracle provides Statspack, a package to - monitor and save the state of the v$ performance views. These reports - help finding severe problems by exposing summary data about the Oracle - wait interface, executed queries. You'll find the installation - instructions in $ORACLE_HOME/rdbms/admin/spdoc.txt. Follow the - instructions carefully and take periodic snapshots, this way you'll be - able to look at historical performance data. - - - Also turn on the timed_statistics in your init.ora file, so that - Statspack reports (and all other Oracle reports) are timed, which makes - them a lot more meaningful. The overhead of timing data is about 1% per - Oracle Support information. - - - - - To be able to get a overview of how Oracle executes a particular query, - install "autotrace". I usually follow the instructions here http://asktom.oracle.com/~tkyte/article1/autotrace.html. - - - - Make sure, that the Oracle CBO works with adequate statistics - - - The Oracle Cost Based optimizer is a piece of software that tries to find - the "optimal" execution plan for a given SQL statement. For that it - estimates the costs of running a SQL query in a particular way (by default - up to 80.000 permutations are being tested in a Oracle 8i). To get an - adequate cost estimate, the CBO needs to have adequate statistics. For - that Oracle supplies the dbms_stats - package. - - - Pre-Installation Tasks @@ -2116,6 +2069,10 @@ + + Oracle Next Steps + + Defaults