Changes between Version 7 and Version 8 of OracleTestSetup
- Timestamp:
- Nov 11, 2010, 4:08:35 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
OracleTestSetup
v7 v8 17 17 18 18 * Oracle XE (10g) 19 * GNU/Debian Linux . Things should also work with Ubuntu Linux without too much tweaking.19 * GNU/Debian Linux x86. Things should also work with Ubuntu Linux without too much tweaking. 20 20 21 21 The system isn't going to be dedicated exclusively to run Oracle so we will … … 31 31 http://www.oracle.com/technetwork/database/express-edition/downloads/index.html 32 32 (*Oracle Database 10g Express Edition for Linux x86*). You need to have an 33 *Oracle Developer Network* account. 34 Contrarily to what is suggested in some places_ I've found the newer `.deb` package 35 you can get here_ and installable by using high level Debian/Ubuntu package management 33 *Oracle Developer Network* account and to accept the licence agreement. 34 35 Contrarily to what is suggested in some places_ I've found the newer **oracle-xe-universal_10.2.0.1-1.1_i386.deb** package 36 you can get here_ (as of Nov 2010) and installable by using high level Debian/Ubuntu package management 36 37 tools (APT, Aptitude, ...) didn't install things like the ``/etc/init.d/oracle-xe`` init 37 38 script and some files under the ``/usr/lib/oracle`` hierarchy so I went with the older … … 145 146 * Run the Django tests 146 147 147 from the same system as the DB engineor from another system through the network. If you chose the148 first option we are done, if you chose the second option for any of the two kinds of access then you148 from the same system where the DB engine is running or from another system through the network. If you chose the 149 first option you can skit to the next step, if you chose the second option for any of the two kinds of access then you 149 150 need to solve the following two issues first (see the `Oracle installation documentation`_ for 150 151 detailed instructions): 151 152 152 * You will need to install the Oracle client stack .153 * You will need to install the Oracle client stack on your remote system. 153 154 * By default no access of any type (SQL sessions, admin web app) is allowed through the network to the DB engine, you need to change that by using the administrative web interface or possibly using the `sqlplus` tool. 154 155 155 #. Access the DB engine administration web app by pointing our Web browser to ``http://localhost:8080/apex`` 156 #. Access the DB engine administration web app by pointing our Web browser to ``http://localhost:8080/apex`` (or ``http://server:8080/apex``) 156 157 and using the ``SYSTEM`` user plus the password you chose above. 157 158 158 159 #. Create an user to be used to connect to the DB when running the tests. (e.g. ``djangotest``) 159 -- Go to *Home > Administration > Database Users > CREATE* assign it a password (e.g. `` foo``)160 -- Go to *Home > Administration > Database Users > CREATE* assign it a password (e.g. ``tehsekret``) 160 161 161 162 #. Give the user the needed privileges. … … 169 170 Install cx_Oracle 170 171 ================= 171 ::172 Do this in the system where youwill run your tests:: 172 173 173 174 $ sudo apt-get install python-dev … … 187 188 :: 188 189 189 $ cat oracle .py190 $ cat oracle_settings.py 190 191 191 192 DATABASES = { … … 211 212 } 212 213 213 The key is that NAME should be the same ('xe') for both entries, since you're really establishing two connections to the same database. The TEST_USER, TEST_TBLSPACE, and TEST_TBLSPACE_TMP entries must be different, however. Thanks Ian Kelly for providing the correct settings file. 214 The key is that ``NAME`` should be the same (``'xe'``) for both entries, since you're really establishing two connections to the same database. The ``TEST_USER``, ``TEST_TBLSPACE``, and ``TEST_TBLSPACE_TMP`` entries must be different, however. 215 216 Thanks Ian Kelly for providing the correct settings file. 214 217 215 218 Test things … … 219 222 $ sudo /etc/init.d/xe start 220 223 221 $ ./runtests --settings=oracle.py basic224 $ ./runtests.py --settings=oracle_settings.py basic 222 225 223 226 Creating test database 'default'...