How can I transfer an Oracle 11g database to a new server with Oracle 18 XE?

To stay on the free version of the Oracle database, we suggest migrating to the Oracle 18 XE (Express Edition) database, available for download on the official Oracle database website.

for Windows x64 and Linux x64: https://www.oracle.com/database/technologies/xe-downloads.html

The difference between Oracle 18 XE (Express Edition) and 11 XE (Express Edition) is as follows:

  • increasing the storage space for user data from 11GB to 12GB
  • increasing the maximum RAM consumption per database instance from a maximum of 1GB RAM to 2GB RAM
  • increasing the CPU for query processing within the database engine from 1 CORE OF CPU to 2 CORES OF CPU
  • creating and managing a plug-in database (pluggable database) in the database installation in the default CDB (container database) mode for the needs of aSISt, preparation of the database schema for the aSISt application is presented in the document describing the installation of the aSISt application in the Oracle section on 12c in the default installation mode CDB (container database)
  • the free Oracle 18 XE database provides the ability to create up to 3 plug-in databases

The transfer of the Oracle database to the server with the Oracle 18 XE (Express Edition) database is performed in the same way as described in point: “How can I transfer an Oracle 11g or 12c database to a new server with an Oracle 12c database?” in the FAQ on this aSISt website.

We would like to add that we do not provide Oracle database installation instructions.

All materials on the installation, configuration and administration of the database in its various versions can be found on the official website of the database producer.

On the Windows Server operating system, before installing the database, you need to create the user of the operating system on which the Oracle services will run (database service, listener, job scheduler, etc.), to then indicate it in one of the installation stages.

On Linux, in addition to creating appropriate user groups along with the above-mentioned service user and assigning him to appropriate groups, you also need to make the required changes to the kernel settings or security limits for users, set environment variables, create a folder for the ORACLE_HOME location, etc. according to official Oracle documentation.

When installing the database, follow the wizard.

Database encoding should be selected according to the aSISt application installation manual, according to the current database encoding.

Otherwise, the default encoding will be set and you should verify it after installation. Description of this function is available under “How to check what encoding is used by the installed Oracle database?” of this FAQ.

The default 18XE base encoding is AL32UTF8.

If the currently set encoding of the base (from which the migration will take place) is different, but also supported by the aSISt application (see aSISta installation documentation  https://support.asist-xbrl.eu/sites/default/files/asist/Distributions/5.39.2.0/aSISt-%20opis%20instalacji%205.39.2.0.pdf )  and you plan to stay on it, avoiding possible data conversion from one encoding to another, run the Oracle XE installer with the parameter indicating the current encoding, i.e .:

setup.exe /v”CHAR_SET=<character_set>”

for example:

setup.exe /v”CHAR_SET=EE8MSWIN1250″

After installation, you need to verify the encoding:

select * from NLS_DATABASE_PARAMETERS where parameter=’NLS_CHARACTERSET’