Code

Changes between Version 2 and Version 3 of OracleTestSetup


Ignore:
Timestamp:
11/08/10 19:34:59 (3 years ago)
Author:
ramiro
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • OracleTestSetup

    v2 v3  
    1212  * Providing a step by step setup guide to achieve that. 
    1313  * 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 
     16Chosen is GNU/Debian Linux, things should also work with Ubuntu Linux. 
    1517 
    1618The system isn't going to be dedicated exclusively to run Oracle so we will 
     
    5860       $ sudo /etc/init.d/oracle-xe configure 
    5961 
    60    It will ask you a serie of questions, namely: 
     62   It will ask you a number of questions, namely: 
    6163 
    6264   * A TCP port for the Oracle Database XE graphical user interface (default: 8080) 
     
    6971   it won't be possible to start it manually because that flag is stored 
    7072   (among others) in the ``/etc/default/oracle-xe`` configuration file and we 
    71    would be using the same script as the one excuted when the system boots 
     73   would be using the same script as the one executed when the system boots 
    7274   (``/etc/init.d/oracle-xe``) that always examines these values. 
    7375 
     
    127129   ``sudo service xe start``) 
    128130 
    129 #. Make sure the needed Oracle environment vars are set for the client 
    130    libraries (Bash shell):: 
     131#. Make sure the needed Oracle environment vars needed by its client libraries 
     132   are set (Bash shell):: 
    131133 
    132134    $ echo "source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" >> ~/.bashrc 
     
    137139 
    138140#. Create an user to be used for running the tests. (e.g. ``djangotest``) -- Go to *Home > Administration > Database Users > CREATE* 
    139    assing it a password (e.g. ``foo``) 
     141   assign it a password (e.g. ``foo``) 
    140142 
    141143#. Give the user the needed privileges. 
     
    143145   * Roles: ``CONNECT``, ``RESOURCE`` and ``DBA`` 
    144146   * *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. 
    145149 
    146150.. _Oracle installation documentation: http://www.oracle.com/pls/xe102/to_toc?pathname=install.102%2Fb25144%2Ftoc.htm&remark=portal+%28Getting+Started%29 
    147151.. _places: http://blog.schmehl.info/Debian/oracle-xe 
    148152.. _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. 
    151153 
    152154Install cx_Oracle 
     
    209211 
    210212In 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 RAM 
     213(host system is a workstation running Debian unstable *Sid*). The VM got two CPUs, 1 GiB of RAM 
    212214and a 30 GiB hard disk. Platform is GNU/Debian Linux 5.0 aka *Lenny* (stable as of Nov 2010) 
    213215because it still is in its support period and as a bonus contains Python 2.4 in pre-packaged 
     
    216218Things to review: 
    217219 
    218 * How muchdoes 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. 
     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. 
    219221* 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. 
    220222