Changes between Version 2 and Version 3 of OracleTestSetup


Ignore:
Timestamp:
Nov 8, 2010, 9:34:59 PM (14 years ago)
Author:
Ramiro Morales
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
Back to Top