Language: Deutsch · English

Oracle database

How to prepare an Oracle database for Nuclos: JDBC driver, schema/user and connection settings.

HOW-TO OPERATIONS UPDATED: JUL 2026 APPLIES TO NUCLOS 4.2026.X

On this page

Overview

Vendor	oracle.com
Supported version	version 11 and up

JDBC driver separate

The Oracle JDBC driver (e.g. ojdbc8.jar) is not part of the Nuclos distribution for licensing reasons. Download it from Oracle and provide the path during installation.

Create schema and user

Create a schema and user in a SQLPLUS console. A step-by-step guide is available at Oracle: create schema (DE).

Drop an existing schema if needed:

DROP USER <schema> CASCADE;

Connection URL

jdbc:oracle:thin:@<server>:<port>:<instance-name>

Example: jdbc:oracle:thin:@localhost:1521:oracle

SID vs service name

A service name instead of a SID is not directly supported by the installer. Two workarounds:

Provide a SID in the installer, then adjust the connection URL in nuclos.xml and re-run the installer with option -s.
Configure the TNS listener to treat the SID as a service name: add USE_SID_AS_SERVICE_LISTENER = ON to listener.ora and run lsnrctl reload.

Adjust nuclos.xml

<adapter>	oracle
<connection-url>	jdbc:oracle:thin:@<server>:<port>:<instance-name>
<user>, <password>	database user and password
<schema>	schema name
<tablespace>	tablespace name
<tablespace-index> (optional)	separate tablespace for indexes