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.14 -r1.15 --- openacs-4/packages/acs-core-docs/www/xml/install-guide/oracle.xml 26 Jan 2004 15:39:44 -0000 1.14 +++ openacs-4/packages/acs-core-docs/www/xml/install-guide/oracle.xml 14 May 2004 12:52:54 -0000 1.15 @@ -16,6 +16,10 @@ Skip this section if you're not interested in Oracle. + + Oracle is a very complex system ....to be continued by Joel + + OpenACS &version; will install with Oracle 9i but has not been extensively tested so may still have bugs or tuning issues. @@ -29,88 +33,118 @@ url="http://openacs.org/new-file-storage/one-file?file_id=273">document. - - - Acquire Oracle 8.1.7 Enterprise Edition - - You can obtain the software through a variety of methods (You'll need - to become a member of technet.oracle.com, which is - free): + 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 + - - + - Order a CD from the Oracle - Store. The cost is currently $39.95 for a 30-day - evaluation copy with delivery estimated between 3-4 business - days. + + 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. + - + + 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. + - Download the software from the - Oracle Downloads page. - + + 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: - + + Oracle 8i + Release Documentation + - Oracle 8.1.7 now comes with a Java RunTime - Environment built-in to the distribution, so you no longer - have to download and install it separately. - - - - - - See these - instructions to download the 8.1.7.4 patchset. Note - that you can't back out of an Oracle patchset once it's - installed. You have to reinstall the whole thing from scratch. - - + + Oracle 9i Release Documentation + - - - After the download is complete, untar the file - to a convenient location. To do this, you will need to login - and cd to the directory where the archive is. - - - -$ cd /directory/where/oracle/is -$ tar xvf oracle81701.tar + Oracle + 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. + - It used to be possible to get a free CD by mail, but - I can no longer find the link for that option. + + 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 + 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. + + + + 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. + + + + Throughout these instructions, we will refer to a number of configurable settings and advise certain defaults. With the exception of passwords, we advise you to follow these defaults unless you know @@ -121,6 +155,28 @@ + + 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 +export PATH=$PATH:$ORACLE_HOME/bin +export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib +export ORACLE_SID=ora8 +export ORACLE_TERM=vt100 +export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data + +umask 022 + + +open_cursors = 500 + + +nls_date_format = "YYYY-MM-DD" + + For additional resources/documentation, please see this + + 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