Set up an Oracle database for Nuclos: JDBC driver, create schema and user, connection URL (SID vs service name) and nuclos.xml parameters.

globe with meridians Language: Deutsch · English

hammer and wrench Oracle database

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

On this page

Overview

Vendororacle.com
Supported versionversion 11 and up

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

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

  1. Provide a SID in the installer, then adjust the connection URL in nuclos.xml and re-run the installer with option -s.
  2. 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

Related pages

gear System requirements (DE)

Supported databases at a glance.

Öffnen →

rocket Installation (DE)

Install Nuclos.

Öffnen →