Changes between Version 2 and Version 3 of OracleTestSetup
- Timestamp:
- Nov 8, 2010, 9:34:59 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
OracleTestSetup
v2 v3 12 12 * Providing a step by step setup guide to achieve that. 13 13 * Hopefully collecting information (best practices, tuning tips) to do that 14 as efficiently as possible. chosen is GNU/Debian Linux, things should also work with Ubuntu Linux. 14 as efficiently as possible. 15 16 Chosen is GNU/Debian Linux, things should also work with Ubuntu Linux. 15 17 16 18 The system isn't going to be dedicated exclusively to run Oracle so we will … … 58 60 $ sudo /etc/init.d/oracle-xe configure 59 61 60 It will ask you a serieof questions, namely:62 It will ask you a number of questions, namely: 61 63 62 64 * A TCP port for the Oracle Database XE graphical user interface (default: 8080) … … 69 71 it won't be possible to start it manually because that flag is stored 70 72 (among others) in the ``/etc/default/oracle-xe`` configuration file and we 71 would be using the same script as the one ex cuted when the system boots73 would be using the same script as the one executed when the system boots 72 74 (``/etc/init.d/oracle-xe``) that always examines these values. 73 75 … … 127 129 ``sudo service xe start``) 128 130 129 #. Make sure the needed Oracle environment vars are set for the client130 libraries(Bash shell)::131 #. Make sure the needed Oracle environment vars needed by its client libraries 132 are set (Bash shell):: 131 133 132 134 $ echo "source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" >> ~/.bashrc … … 137 139 138 140 #. Create an user to be used for running the tests. (e.g. ``djangotest``) -- Go to *Home > Administration > Database Users > CREATE* 139 assi ngit a password (e.g. ``foo``)141 assign it a password (e.g. ``foo``) 140 142 141 143 #. Give the user the needed privileges. … … 143 145 * Roles: ``CONNECT``, ``RESOURCE`` and ``DBA`` 144 146 * *Directly Granted System Privileges*: ``CREATE TABLE``, ``CREATE PROCEDURE``, ``CREATE SEQUENCE`` and ``CREATE TARIGGER`` 147 148 #. We don't need to install the Oracle client stack because we are going to run the Django tests in the same system. 145 149 146 150 .. _Oracle installation documentation: http://www.oracle.com/pls/xe102/to_toc?pathname=install.102%2Fb25144%2Ftoc.htm&remark=portal+%28Getting+Started%29 147 151 .. _places: http://blog.schmehl.info/Debian/oracle-xe 148 152 .. _here: http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/ 149 150 #. We don't need to install the Oracle client stack because we are going to run the Django tests in the same system.151 153 152 154 Install cx_Oracle … … 209 211 210 212 In my particular case I've implemented this setup by using a KVM virtual machine 211 (host syste ,is a workstation running Debian unstable *Sid*). The VM got two CPUs, 1 GiB of RAM213 (host system is a workstation running Debian unstable *Sid*). The VM got two CPUs, 1 GiB of RAM 212 214 and a 30 GiB hard disk. Platform is GNU/Debian Linux 5.0 aka *Lenny* (stable as of Nov 2010) 213 215 because it still is in its support period and as a bonus contains Python 2.4 in pre-packaged … … 216 218 Things to review: 217 219 218 * How much doesthe 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.220 * 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. 219 221 * 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. 220 222