Changes between Version 19 and Version 20 of OracleTestSetup

Timestamp:

Aug 17, 2013, 1:56:28 PM (11 years ago)

Author:

Tim Graham

Comment:

Oracle VM on Ubuntu

OracleTestSetup

@@ -398 +398 @@
    As for other credentials on the virtual machine, if you want to login as a regular user, just use ``oracle``/``oracle``, the root password is ``oracle`` as well. However, in order to run the test suite, you just need to boot the machine up, you don't need to start anything manually.
 
-#. Install *instantclient* on your host system (the one where you'll be running the test suite). On Gentoo there is an ebuild, which means it is just a matter of ``emerge -av oracle-instantclient-basic`` and fetching the appropriate zip archives from the Oracle download site as instructed, on Debian or Ubuntu you can download the RPM package, convert it to a DEB package using alien as outlined above and install that using ``dpkg -i``.
+#. Install *instantclient* on your host system (the one where you'll be running the test suite). On Gentoo there is an ebuild, which means it is just a matter of ``emerge -av oracle-instantclient-basic`` and fetching the appropriate zip archives from the Oracle download site as instructed.
+
+  On Debian or Ubuntu you can download the RPM package ("Instant Client Package - Basic"), convert it to a DEB package and install using alien::
+
+   $ sudo alien -i oracle-instantclient-basic*.rpm
+
+  After installing the client, you will need to install the "Instant Client Package - SDK". After downloading, unzip and copy it to the client install directory::
+     
+    $ unzip instantclient-sdk-linux.x64-*.zip
+    $ sudo cp -R instantclient_11_2/* /usr/lib/oracle/11.2/client64/*
 
 #. Start a new shell and install cx_Oracle in your testing virtualenv::
@@ -404 +413 @@
     pip install cx_Oracle
 
-   The new shell is necessary because the *instantclient* package sets various environment variables required to build the adapter.
+   The new shell is necessary because the *instantclient* package sets various environment variables required to build the adapter. On Debian/Ubuntu, you'll need to set the variables manually::
+
+    $ export ORACLE_HOME=/usr/lib/oracle/11.2/client64/
 
 #. Create a settings file, the following example seems to work for me::
@@ -411 +422 @@
         'default': {
             'ENGINE': 'django.db.backends.oracle',
+            'HOST': '127.0.0.1',
+            'PORT': '1521',
             'NAME': 'orcl',
             'USER': 'system',
             'PASSWORD': 'oracle',
-            'HOST': 'localhost',
-            'PORT': '1521',
+            'TEST_USER': 'django',
+            'TEST_TBLSPACE': 'django_test',
+            'TEST_TBLSPACE_TMP': 'django_test_tmp',
         },
         'other': {
-            'ENGINE': 'django.db.backends.sqlite3',
+            'ENGINE': 'django.db.backends.oracle',
+            'HOST': '127.0.0.1',
+            'PORT': '1521',
+            'NAME': 'orcl',
+            'USER': 'system',
+            'PASSWORD': 'oracle',
+            'TEST_USER': 'other',
+            'TEST_TBLSPACE': 'other_test',
+            'TEST_TBLSPACE_TMP': 'other_test_tmp',
         }
     }
@@ -427 +449 @@
 
 #. Profit::
+
+     $ # may be need on Debian/Ubuntu
+     $ export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
 
     (env)johnny64@equus ~/GSoC/2011/koniiiik-django/tests $  ./runtests.py --settings=test_oracle