X-Received: by 10.182.181.97 with SMTP id dv1mr22788069obc.49.1411429386406; Mon, 22 Sep 2014 16:43:06 -0700 (PDT) X-Received: by 10.182.20.101 with SMTP id m5mr380972obe.0.1411429386290; Mon, 22 Sep 2014 16:43:06 -0700 (PDT) Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!209.85.213.216.MISMATCH!h15no4345784igd.0!news-out.google.com!bc9ni4973igb.0!nntp.google.com!h15no4345778igd.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Mon, 22 Sep 2014 16:43:06 -0700 (PDT) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=216.113.168.128; posting-account=u5vgBgoAAADkAk97dXqE1JNchd-e6keY NNTP-Posting-Host: 216.113.168.128 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <772c57f5-e653-4a26-abf0-27b25fbe66d8@googlegroups.com> Subject: is it possible to run oracle server as non-root, non-system process? From: teddyyyy123@gmail.com Injection-Date: Mon, 22 Sep 2014 23:43:06 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Xref: news.cambrium.nl I'm trying to setup a small oracle server as part of my java junit test pro= cess, 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 sett= ings 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 @/home/myuser/oracle/install//u01/app/oracle/product/11.2.0/xe/con= fig/scripts/startdb.sql ERROR: ORA-01031: insufficient privileges if I run as root, this step gave errors: ERROR: ORA-12162: TNS:net service name is incorrectly specified my listener.ora is: @devbox-114942 install]$ cat ./u01/app/oracle/product/11.2.0/xe/network/adm= in/listener.ora # listener.ora Network Configuration File: SID_LIST_LISTENER =3D (SID_LIST =3D (SID_DESC =3D (SID_NAME =3D PLSExtProc) (ORACLE_HOME =3D /home/myuser/oracle/install/u01/app/oracle/product/1= 1.2.0/xe) (PROGRAM =3D extproc) ) ) LISTENER =3D (DESCRIPTION_LIST =3D (DESCRIPTION =3D (ADDRESS =3D (PROTOCOL =3D IPC)(KEY =3D EXTPROC0)) (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D devbox-114942)(PORT =3D 1521= )) ) ) DEFAULT_SERVICE_LISTENER =3D (XE) TRACE_LEVEL_LISTENER =3D SUPPORT overall, I am able to start the listener, and I can see the oradata/ dir ge= nerated, and a bunch of trace files generated. but don't see apparently ala= rming things in the trace file. in fact when I do sqlplus and connect to th= e listener (?? ) , I don't see any more logging come out in the trace file