Changes between Version 3 and Version 4 of OracleTestSetup

Timestamp:

Nov 11, 2010, 8:15:03 AM (14 years ago)

Author:

Ramiro Morales

Comment:

--

OracleTestSetup

@@ -33 +33 @@
    tools (APT, Aptitude, ...) didn't install things like the ``/etc/init.d/oracle-xe`` init
    script and some files under the ``/usr/lib/oracle`` hierarchy so I went with the older
-   package plus dpkg and taking care of  dependencies manually.
+   package plus the los -level `dpkg` package manager and taking care of dependencies manually
+   (see next step).
 
 #. Install the prerequisite packages, if you fail to do so the installation won't be successful
@@ -72 +73 @@
    (among others) in the ``/etc/default/oracle-xe`` configuration file and we
    would be using the same script as the one executed when the system boots
-   (``/etc/init.d/oracle-xe``) that always examines these values.
+   (the SyV ``/etc/init.d/oracle-xe`` script) that always examines these values.
 
    What we can do is to create a slightly modified ``/etc/init.d/xe`` script
@@ -83 +84 @@
    This is the ``oracle-xe-script.diff`` patch file (you can also download it)::
 
-    --- oracle-xe   2006-02-24 17:23:15.000000000 -0300
-    +++ xe  2010-11-03 07:58:43.000000000 -0300
+    --- xe   2006-02-24 17:23:15.000000000 -0300
+    +++ xe.new  2010-11-03 07:58:43.000000000 -0300
     @@ -596,13 +596,8 @@
      # See how we were called
@@ -129 +130 @@
    ``sudo service xe start``)
 
-#. Make sure the needed Oracle environment vars needed by its client libraries
+#. Make sure the Oracle environment vars needed by its client libraries
    are set (Bash shell)::
 
@@ -135 +136 @@
     $ source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
 
+
+#. Decide if you will run the following tasks
+
+   * Access the administrative web app
+   * Run the Django tests
+
+from same system as the DB engine or from another system through the network. If you chose the first option we are done, if you chose the second option for any of the two kinds of access you need to solve the following two issues first (see the `Oracle installation documentation`_ for 
+detailed instructions):
+
+   * You will need to install the Oracle client stack.
+   * By default no access of any type (SQL sessions, admin web app) is allowed through the network to the DB engine, you need to change that by using the administrative web interface or possibly using the `sqlplus` tool.
+
 #. Access the DB engine administration web app by pointing our Web browser to ``http://localhost:8080/apex``
-   and using the ``SYSTEM`` user and the password you chose above.
-
-#. Create an user to be used for running the tests. (e.g. ``djangotest``) -- Go to *Home > Administration > Database Users > CREATE*
-   assign it a password (e.g. ``foo``)
+   and using the ``SYSTEM`` user plus the password you chose above.
+
+#. Create an user to be used to connect to the DB when running the tests. (e.g. ``djangotest``)
+   -- Go to *Home > Administration > Database Users > CREATE* assign it a password (e.g. ``foo``)
 
 #. Give the user the needed privileges.
@@ -146 +159 @@
    * *Directly Granted System Privileges*: ``CREATE TABLE``, ``CREATE PROCEDURE``, ``CREATE SEQUENCE`` and ``CREATE TARIGGER``
 
-#. We don't need to install the Oracle client stack because we are going to run the Django tests in the same system.
-
-.. _Oracle installation documentation: http://www.oracle.com/pls/xe102/to_toc?pathname=install.102%2Fb25144%2Ftoc.htm&remark=portal+%28Getting+Started%29
+.. _Oracle installation documentation: http://download.oracle.com/docs/cd/B25329_01/doc/install.102/b25144/toc.htm
 .. _places: http://blog.schmehl.info/Debian/oracle-xe
 .. _here: http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/
@@ -157 +168 @@
 
     $ sudo apt-get install python-dev
-    $ ...
+
+::
+
+    $ sudo pip install cx_Oracle
+
+or::
+
+    $ sudo easy_install cx_Oracle
+
+etc.
 
 Create the Django settings file
@@ -170 +190 @@
             'NAME': 'xe',
             'USER': 'djangotest',
-            'PASSWORD': 'foo',
+            'PASSWORD': 'tehsekret',
+            'TEST_USER': 'django_test_default',
+            'TEST_TBLSPACE': 'django_test_default',
+            'TEST_TBLSPACE_TMP': 'django_test_default_temp',
         },
+
         'other': {
             'ENGINE': 'django.db.backends.oracle',
-            'NAME': 'xeother',
-            'USER': 'djangotest2',
-            'PASSWORD': 'bar',
-            #'TEST_USER_CREATE': False,
-            'TEST_TBLSPACE': 'tblspace_other',
-            'TEST_TBLSPACE_TMP': 'tblspace_tmp_other',
+            'NAME': 'xe',
+            'USER': 'djangotest',
+            'PASSWORD': 'tehsekret',
+            'TEST_USER': 'django_test_other',
+            'TEST_TBLSPACE': 'django_test_other',
+            'TEST_TBLSPACE_TMP': 'django_test_other_temp',
         },
     }
+
+The key is that NAME should be the same ('xe') for both entries, since you're really establishing two connections to the same database. The TEST_USER, TEST_TBLSPACE, and TEST_TBLSPACE_TMP entries must be different, however. Thanks Ian Kelly for providing the correct settings file.
 
 Test things
@@ -214 +240 @@
 and a 30 GiB hard disk. Platform is GNU/Debian Linux 5.0 aka *Lenny* (stable as of Nov 2010)
 because it still is in its support period and as a bonus contains Python 2.4 in pre-packaged
-form. Things should also work with Ubuntu Linux.
+form. Things should also work with Ubuntu Linux without too much tweaking.
 
 Things to review:
@@ -220 +246 @@
 * 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.
 * System resource (CPU, RAM usage while running the full test suite). Maybe I can reduce the RAM assigned to the VM to 512 MiB and the virtual CPU count from two to one.
-
-To do
-=====
-
-Finish the multi-db setup by crafting a correct Django settings file (``oracle.py`` above) that allows us to run the entire suite with errors.
 }}}