Changes between Version 31 and Version 32 of OracleTestSetup

Timestamp:

Feb 25, 2019, 5:35:54 AM (5 years ago)

Author:

Johannes Maron

Comment:

Add Docker image instructions

OracleTestSetup

@@ -93 +93 @@
     Destroying test user...
     Destroying test database tables...
+
+Using the Oracle Docker image
+===============================================
+
+Oracle provides a `Docker image`_ for its Database via Docker Hub. Once you "purchased" (it's free of charge) the Docker image, you can start the server as followed::
+
+    docker run -d -it -p 1521:1521 store/oracle/database-enterprise:12.2.0.1
+
+Next you will need to create the django database user. This requires you to have ``sqlplus``. You simply follow the instructions above to install it.
+
+Connect to the database and execute the following SQL commands::
+
+    sqlplus sys/Oradoc_db1@localhost/ORCLCDB.localdomain as sysdba
+    SQL> ALTER SESSION SET CONTAINER=ORCLPDB1;
+    SQL> CREATE USER django IDENTIFIED BY django;
+    SQL> GRANT DBA TO django;
+    SQL> QUIT
+
+Next update your ``DATABASE`` setting as followed::
+
+    DATABASES = {
+        'default': {
+            'ENGINE': 'django.db.backends.oracle',
+            'NAME': 'localhost/ORCLPDB1.localdomain',
+            'USER': 'django',
+            'PASSWORD': 'django',
+            'TEST': {
+                'USER': 'default_test',
+                'TBLSPACE': 'default_test_tbls',
+                'TBLSPACE_TMP': 'default_test_tbls_tmp',
+            },
+        },
+        'other': {
+            'ENGINE': 'django.db.backends.oracle',
+            'NAME': 'localhost/ORCLPDB1.localdomain',
+            'USER': 'django',
+            'PASSWORD': 'django',
+            'TEST': {
+                'USER': 'other_test',
+                'TBLSPACE': 'other_test_tbls',
+                'TBLSPACE_TMP': 'other_test_tbls_tmp',
+            },
+        },
+    }
+
+.. _`Docker image`: https://hub.docker.com/_/oracle-database-enterprise-edition
+
 }}}