Changes between Version 16 and Version 17 of OracleTestSetup

Timestamp:

Aug 23, 2011, 5:29:39 AM (13 years ago)

Author:

Aymeric Augustin

Comment:

Added instructions for version 11g

OracleTestSetup

@@ -5 +5 @@
 ==============================
 
-This document attempts to ease the task of running Django's (or your own app's) test
-suite against Oracle by:
+This document attempts to ease the task of running Django's (or your own app's) test suite against Oracle by:
 
 * Providing a step by step setup guide to achieve that.
-* Hopefully collecting information (best practices, tuning tips) to do that
-  as efficiently as possible.
+* Hopefully collecting information (best practices, tuning tips) to do that as efficiently as possible.
 
 Contributions from seasoned Oracle users are welcome!
@@ -16 +14 @@
 Chosen components are:
 
-* Oracle XE 10g. This is a free version of Oracle targeted at developers.
-* GNU/Debian Linux x86 — not amd64, because there's no 64bit free version of Oracle (XE). Things should also work with Ubuntu Linux without too much tweaking. 
-
-The system isn't going to be dedicated exclusively to run Oracle so we will
-leave things set up so it is necessary to start it manually before a test-debug
-session.
-
-Obtain and install Oracle XE
+* Oracle XE. This is a free version of Oracle targeted at developers.
+* Debian GNU/Linux or Ubuntu.
+
+Oracle provides 32 bit binaries of Oracle 10g and 64 bit binaries of Oracle 11g. If you're using an x86 kernel, you have to install Oracle 10g, and Oracle 11g if you're using an amd64 kernel. There are no other free versions available. The 64 bit version is currently in beta and only available as a RPM packages; this document describes how to convert them to Debian packages.
+
+This procedure was tested with Debian 6 i686 + Oracle 10g, and with Ubuntu 11.04 x86_64 + Oracle 11g. There were no difference between Debian and Ubuntu.
+
+In case the system isn't going to be dedicated exclusively to run Oracle, we will describe how to set things up so it doesn't start automatically. In this case, it will be necessary to start it manually before a test-debug session.
+
+How to install Oracle XE 10g
 ============================
+
+As explained in the introduction, this will only work on a 32 bit distro.
 
 We will be roughly following the `Oracle installation documentation`_.
@@ -137 +139 @@
 .. _here: http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/
 
+How to install Oracle XE 11g
+============================
+
+As explained in the introduction, this will only work on a 64 bit distro.
+
+This is a simplified version of the installation procedure described at:
+http://forums.oracle.com/forums/thread.jspa?threadID=2227554
+
+The procedure is very similar to Oracle 10g, we focus on the differences, please read the previous section for more information.
+
+#. Create a Debian / Ubuntu package.
+
+   This can be done on another machine, you just need the resulting files, ``oracle-xe_11.2.0-1.5_amd64.deb`` and ``oracle-instantclient11.2-basiclite_11.2.0.2.0-2_amd64.deb``.
+
+   Download Oracle XE and Oracle InstantClient for Red Hat from Oracle's website. Oracle XE is delivered as a zip file that contains the RPM file we will use.
+
+   You need to have an *Oracle Developer Network* account and to accept the license agreement. (free but registration required).
+
+   Run these commands::
+
+    $ sudo apt-get install alien
+    $ alien --scripts oracle-xe-11.2.0-0.5.x86_64.rpm
+    $ alien --scripts oracle-instantclient11.2-basiclite-11.2.0.2.0.x86_64.rpm
+
+
+#. Install dependencies
+
+   Run this command::
+
+    $ sudo apt-get install bc libaio1
+
+   The RPM contains install scripts that use ``chkconfig`` to add Oracle to the services started at boot. Debian and Ubuntu use ``update-rc.d``. In order to avoid modifying the install scripts, we create a fake ``chkconfig``. Create a file called ``/sbin/chkconfig`` with this content::
+
+
+    #!/bin/sh
+    if [ "$1" = '--add' ]; then
+        update-rc.d "$2" defaults
+    elif [ "$1" = '--del' ]; then
+        update-rc.d -f "$2" remove
+    fi
+
+   Make it executable::
+
+   $ sudo chmod +x /sbin/chkconfig
+
+   With this hack, there's a harmless warning during installation because the init script isn't tailored for Debian / Ubuntu::
+
+    update-rc.d: warning: /etc/init.d/oracle-xe missing LSB information
+    update-rc.d: see <http://wiki.debian.org/LSBInitScripts>
+
+#. Install the package you generated::
+
+    $ sudo dpkg -i oracle-xe_11.2.0-1.5_amd64.deb
+
+#. Configure the DB engine::
+
+    $ sudo /etc/init.d/oracle-xe configure
+
+#. Make sure the Oracle environment vars needed by its client libraries are set at least for the Oracle user::
+
+    $ sudo su oracle
+    $ echo '. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh' >> ~/.bashrc
+    $ exit
+
+#. Remove the fake ``chkconfig`` script::
+
+    $ sudo rm /sbin/chkconfig
+
+#. Test the server::
+
+    $ sudo su oracle
+    $ sqlplus / as sysdba
+    SQL> quit
+    $ exit
+
+   APEX is reachable at http://localhost:8080/ but I can't figure out how to login.
+   Since we don't need it for the purposes of running Django's test suite, we disable it::
+
+    SQL> EXEC DBMS_XDB.SETHTTPPORT(0);
+    SQL> COMMIT;
+
+   If we wanted to enable it again::
+
+    SQL> EXEC DBMS_XDB.SETHTTPPORT(8080);
+    SQL> COMMIT;
+
+#. Create a user and give the needed privileges::
+
+    $ sudo su oracle
+    $ sqlplus / as sysdba
+    SQL> CREATE USER djangotest IDENTIFIED BY djangotest;
+    SQL> GRANT DBA TO djangotest;
+    SQL> quit
+    $ exit
+
+
+#. Install the client libraries
+
+   This is necessary to compile ``cx_Oracle``::
+
+    # dpkg -i oracle-instantclient11.2-basiclite_11.2.0.2.0-2_amd64.deb
+
+   Since the libraries are installed in a non-standard directory, declare it::
+
+    # echo /usr/lib/oracle/11.2/client64/lib > /etc/ld.so.conf.d/oracle-instantclient.conf
+    # ldconfig
+
+
+Uninstall Oracle 11g
+====================
+
+To uninstall the server::
+
+    # /etc/init.d/oracle-xe stop
+    # dpkg -P oracle-xe
+
+The ``prerm`` script doesn't work on Debian / Ubuntu; here's how to clean up your system entirely::
+
+    # rm -r /u01
+    # update-rc.d oracle-xe remove
+    # rm /etc/default/oracle-xe /etc/oratab /var/lib/update-rc.d/oracle-xe 
+    # rm -r /etc/kde/xdg/menus/OracleXE
+    # rmdir -p /etc/kde/xdg/menus
+
+To uninstall the client::
+
+    # dpkg -P oracle-instantclient11.2-basiclite
+    # rm /etc/ld.so.conf.d/oracle-instantclient.conf
+    # ldconfig
+
+
 Install cx_Oracle
 =================
+
+Before compiling ``cx_Oracle`` make sure Oracle's environment variables are set (``. path/to/oracle_env.sh``, the path depends on the version you intalled). You need Python's headers too.
+
 Do this in the system where you will run your tests::
 
     $ sudo apt-get install python-dev
-
-::
-
     $ sudo pip install cx_Oracle
 
-or::
-
-    $ sudo easy_install cx_Oracle
-
-etc.
+To test the installation (as usual, you need the environment variables)::
+
+    $ python
+    >>> import cx_Oracle
 
 Create the Django settings file
@@ -247 +379 @@
 
 .. _relevant Oracle documentation: http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/intro.htm#i60798
-
-Notes
-=====
-
-In my particular case I implemented this setup by using a KVM virtual machine 
-(host system is a workstation running Debian unstable *Sid*). The VM got:
-
-* One CPU (Oracle XE won't use any additional CPU).
-* 512 MiB of RAM (initially it was 1GiB but the Django test suite execution doesn't push memory usage above that at all).
-* 30 GiB hard disk.
-
-Platform is GNU/Debian Linux 5.0 aka *Lenny* because it still is in
-its support period. As a bonus it includes Python 2.4 in pre-packaged form.
-
-Things to review:
-
-* How much does the Oracle installation pollutes the system?. If it result to be confined and easy to undo/cleanup, maybe this setup doesn't need to be done inside a VM.
 }}}