Built by Maven

Configuring Oracle XE database

This article explains how the framework server works with Oracle XE. When using Oracle XE you need to configure the following additional settings.

Space Quota

In order to prevent the following exception:

ORA-01536: space quota exceeded for tablespace 'USERS'

Extend the quota on users with the following sql:

alter user midvisionadmin quota unlimited on users;

TNS Listener

In order to prevent the following error:

ORA-12519, TNS:no appropriate service handler found The Connection 
descriptor used by the client was:
localhost:1523:XE

Solution: Via SQL Plus as System run:

ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;

Other recommended settings

ALTER SYSTEM SET open_cursors=1000 SCOPE=BOTH;
ALTER SYSTEM SET processes=500 SCOPE=SPFile;