Userspace Oracle XE

We needed to run Oracle XE in a “developer hostile” environment for testing. That meant running Oracle with no access to root or the dba group.

Now that might sound impossible, but we seem to have found a way to make it happen, provided you can do some preparatory work on a separate machine (eg a VM) where you do have those rights.

Here’s what you do:

I hope that was clear enough!

In summary, the basic idea is:

That’s basically all that is needed - Oracle will run wherever it is installed if the paths are consistent (so you can install in a user’s directories) and you can avoid the need for the dba group by using a password file entry.

Andrew


Related Posts

blog comments powered by