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