is it possible to run oracle server as non-root, non-system process?
Date: Mon, 22 Sep 2014 16:43:06 -0700 (PDT)
Message-ID: <772c57f5-e653-4a26-abf0-27b25fbe66d8_at_googlegroups.com>
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:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/myuser/oracle/install/u01/app/oracle/product/11.2.0/xe)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = devbox-114942)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
TRACE_LEVEL_LISTENER = SUPPORT
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