The wiki will be unavailable from 7am until 9am on Thursday, 24 August, 2017.
Skip to end of metadata
Go to start of metadata

It's useful to be able to use Oracle Express locally as we don't then have to ask for test instances of databases to be setup elsewhere for development.

  1. Get the install package for Oracle Express
  2. Run the install package as administrator, make sure you remember or note down the system password you use
  3. As yourself start a command window and run sqlplus
    • username: system
    • password: (the password you chose)
  4. Run the following command (assuming 8081 is a free port on your PC and you already run tomcat under 8080):
    exec dbms_xdb.sethttpport(8081);
  5. Edit Database_homepage.url. If you installed Oracle Express in the default location this can be found under:
    C:\oraclexe\app\oracle\product\10.2.0\server\Database_homepage.url
    • Change the following line in the script to account for the port number change:
      • Use runas to run a command prompt as administrator, cd to the directory and run notepad Database_homepage.url
      • URL=http://127.0.0.1:8081/apex
  6. Your database is called XE, so a connection string will be like:
    jdbc:oracle:thin:@localhost.bath.ac.uk:1521:XE

If you cannot access the database homepage then check you browser proxy settings. Don't use the proxy script, instead set the proxy manually but bypass proxies for 127.0.0.1, localhost, bath.ac.uk

  • No labels