| Auszug |
|---|
|
Set up an Oracle database for Nuclos: JDBC driver, create schema and user, connection URL (SID vs service name) and nuclos.xml parameters. |
Language: Deutsch · English
Oracle database
How to prepare an Oracle database for Nuclos: JDBC driver, schema/user and connection settings.
| Status |
|---|
| colour | Blue |
|---|
| title | Operations |
|---|
|
| Status |
|---|
| colour | Green |
|---|
| title | Updated: Jul 2026 |
|---|
|
| Status |
|---|
| colour | Grey |
|---|
| title | applies to Nuclos 4.2026.x |
|---|
|
Overview
| Vendor | oracle.com |
|---|
| Supported version | version 11 and up |
|---|
| Info |
|---|
| title | 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:
| Codeblock |
|---|
DROP USER <schema> CASCADE; |
Connection URL
| Codeblock |
|---|
jdbc:oracle:thin:@<server>:<port>:<instance-name> |
Example: jdbc:oracle:thin:@localhost:1521:oracle
| Hinweis |
|---|
|
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 |
|---|
Related pages
System requirements (DE)
Supported databases at a glance.
Open →
Installation (DE)
Install Nuclos.
Open →
