Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/bestpractical/rt.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJim Brandt <jbrandt@bestpractical.com>2022-06-13 20:56:08 +0300
committerJim Brandt <jbrandt@bestpractical.com>2022-06-13 20:56:08 +0300
commit0b0789fff1a67edc60bf68e52ce7eaee12cdef0b (patch)
tree7ebf6c3c9956c17317845caa51d1c8b7e2dc869a /README.Oracle
parent8c00018ab32527460d51c1dcfc12c18fbfbec097 (diff)
Add notes on preferred DBD::Oracle versions
Diffstat (limited to 'README.Oracle')
-rw-r--r--README.Oracle25
1 files changed, 25 insertions, 0 deletions
diff --git a/README.Oracle b/README.Oracle
index e128f70968..a0c27b2640 100644
--- a/README.Oracle
+++ b/README.Oracle
@@ -1,3 +1,6 @@
+Installation Notes
+------------------
+
On RT 3.8.2 and later, RT deployment for Oracle databases is very
straightforward.
@@ -30,6 +33,28 @@ Example:
That should be enough to get you started on Oracle, but to complete
installation you must follow the general instructions in the README file.
+Client Drivers
+--------------
+
+When installing Oracle client drivers, run the same version as
+the database you are connecting to. If you are running RT on the same
+server as the Oracle database, this should happen automatically as the
+client drivers will be installed with the Oracle database software. If
+the Oracle database runs in a separate server and you are installing
+client libraries from the Oracle Instance Client, find and install
+the version that corresponds with the database you are connecting to.
+
+You will also need to install the DBD::Oracle perl module to allow
+RT to connect to the Oracle database. Some recent versions of DBD::Oracle
+have had problems with RT and should be avoided.
+
+DBD::Oracle version 1.74 is known to work well with RT. The next
+known version to work well is version 1.90. Versions in between
+those had an issue on disconnect that would cause a segfault.
+
+Updating Statistics
+-------------------
+
As with all databases it is important to analyze the schema and get
current statistics after every significant dataset change. Oracle's
cost-based optimizer can provide particularly bad performance when the