is it possible to run oracle server as non-root, non-system process?

From: <>
Date: Mon, 22 Sep 2014 16:43:06 -0700 (PDT)
Message-ID: <>

I'm trying to setup a small oracle server as part of my java junit test process, because the commonly-used hsqldb lacks many oracle features, and it's very hard to mock out all those little operations in my ORM library.

I downloaded the Oracle package, untarred to local, changed a bunch of settings in the .ora, .sh scripts to point to my local dir.

I started the server by

bash -x ./etc/init.d/oracle-xe configure when it tries to run the startdb.sql , it gave me some errors:

/home/myuser/oracle/install//u01/app/oracle/product/11.2.0/xe/bin/sqlplus -s /nolog _at_/home/myuser/oracle/install//u01/app/oracle/product/11.2.0/xe/config/scripts/startdb.sql ERROR:
ORA-01031: insufficient privileges
if I run as root, this step gave errors:

ORA-12162: TNS:net service name is incorrectly specified my listener.ora is:

_at_devbox-114942 install]$ cat ./u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora # listener.ora Network Configuration File:

    (SID_DESC =
(ORACLE_HOME = /home/myuser/oracle/install/u01/app/oracle/product/11.2.0/xe)
(PROGRAM = extproc)


(ADDRESS = (PROTOCOL = TCP)(HOST = devbox-114942)(PORT = 1521))

overall, I am able to start the listener, and I can see the oradata/ dir generated, and a bunch of trace files generated. but don't see apparently alarming things in the trace file. in fact when I do sqlplus and connect to the listener (?? ) , I don't see any more logging come out in the trace file Received on Tue Sep 23 2014 - 01:43:06 CEST

Original text of this message