Linux oracle express edition

18c for Linux x86-64

Oracle Database Express Edition Installation Guide, 18c for Linux x86-64

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are «commercial computer software» pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Источник

Установка Oracle Database 18c Express Edition на Oracle Linux

В данном посте описывается установка Oracle Database 18c Express Edition (XE) на операционную систему Oracle Linux 7. В примере рассматривается установка на Oracle Linux 7.4. Процесс установки с небольшими оговорками актуален для всех версий ОС Linux на базе RHEL (подробнее – ниже).

Будут рассмотрены следующие шаги:

Подготовка к установке
Установка Oracle Database 18c XE
Подключение к базе данных

1. Подготовка к установке

1.1. Проверяется, соответствует ли используемая операционная система минимальным требованиям для установки и работы Oracle Database 18c XE. Допустимы следующие версии и дистрибутивы Linux на базе RHEL:

Oracle Linux 7.5 with the Unbreakable Enterprise Kernel 5
Oracle Linux 7.2 with the Unbreakable Enterprise Kernel 4
Oracle Linux 7 with the Unbreakable Enterprise Kernel 3
Oracle Linux 7 with the Red Hat Compatible kernel: 3.10.0-123.el7.x86_64 or later
Red Hat Enterprise Linux 7: 3.10.0-123.el7.x86_64 or later
Oracle Linux 6.4 with the Unbreakable Enterprise Kernel 2
Oracle Linux 6.6 with the Unbreakable Enterprise Kernel 3
Oracle Linux 6.8 with the Unbreakable Enterprise Kernel 4
Oracle Linux 6.4 with the Red Hat Compatible kernel: 2.6.32-358.el6.x86_64 or later
Red Hat Enterprise Linux 6.4: 2.6.32-358.el6.x86_64 or later
SUSE Linux Enterprise Server 12 SP1: 3.12.49-11.1 or later

Для установки требуется минимум 1 Гб оперативной памяти (рекомендуется 2 Гб), минимум 10 Гб дискового пространства для ПО Oracle, 2 Гб дискового пространства для хранения временных файлов и обладание правами администратора.

1.2. Если системные требования соответствуют, то скачивается установочный файл. Oracle Database 18c Express Edition распространяется бесплатно и установочный файл можно скачать с официального сайта Oracle – https://www.oracle.com/database/technologies/xe-downloads.html

Для скачивания на портале Oracle необходимо наличие учетной записи с паролем. При ее отсутствии осуществляется регистрация новой учетной записи.

Пройдя по ссылке, выбирается версия Oracle Database 18c XE для вашей операционной системы (ОС): Oracle Database 18c Express Edition for Linux x64. Запускается скачивание rpm пакета (oracle-database-xe-18c-1.0-1.x86_64.rpm). Время скачивания может быть достаточно большим. Объем пакета около 2,3 Гб.

1.3. Скачивается пакет Oracle Database Preinstall RPM, предназначенный для создания необходимых пользователей, групп в ОС (например, пользователя oracle и группу oinstall), добавления системных параметров и файлов, необходимых для установки и работы базы данных (БД) Oracle. Если используется Oracle Linux, то данный пакет устанавливается командой под учетной записью root. Если используется RedHat, SUSE, либо отсутствует соединение с интернетом на Oracle Linux, то можно скачать сам rpm пакет по ссылке: https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

После скачивания пакет устанавливается командой:

yum localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

rpm -ivh oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

Далее используется вторая команда:

В рассматриваемом случае система требует предварительно установить два зависимых (дополнительных) пакета: ksh и libaio-level. В зависимости от текущих настроек операционной системы возможны требования установки и других зависимых (дополнительных) пакетов. Требуемые пакеты должны быть установлены. Если не настроен доступ к интернету, то пакеты можно найти в папке примонтированного образа (диска или образа, с которого была установлена ОС) – /run/media/ . Для этого, например, если используется VirtualBox, то надо в меню «Устройства виртуальной машины» перейти в раздел «Оптические диски» и указать ISO образ вашей операционной системы. Другим вариантом является создание своего репозитория на виртуальной машине и далее можно установить все пакеты из своего репозитория. Ниже устанавливаются зависимые два пакета на операционную систему из примонтированного образа.

В папке Packages определяются необходимые файлы и устанавливаются командой rpm -ivh.

Теперь устанавливается preinstall пакет еще раз.

Как видно, установка пакета успешно завершена и добавлены системные файлы для конфигурации настроек Oracle Database 18с XE. Все значения оставляются по умолчанию, но при необходимости их можно изменять.

2. Установка Oracle Database 18c Express Edition

2.1. Запускается ранее скачанный rpm пакет. Предварительно проверяется доступность более 1 Гб оперативной памяти. Проверить объем оперативной памяти можно командой free -h. Обычно, указав при создании виртуальной машины 1 Гб ОЗУ, на выходе не всегда получаем 1 гигабайт оперативной памяти в ОС. Для этого рекомендуется указывать объем оперативной памяти виртуальной машины с небольшим запасом (например, 1.4 Гб). Иначе возможна, например, следующая ошибка:

[SEVERE] Oracle Database 18c Express Edition requires a minimum of 1GB of physical memory (RAM). This system has 991 MB of RAM and does not meet minimum requirements.

Запускается установка БД:

Установка успешно завершена и система выдает сообщение: [INFO] Oracle home installed successfully and ready to be configured.

Лог файлы установок можно найти в файлах /var/log/oracle-database-preinstall-18c и /var/log/oracle-database-xe-18c. В них можно удостовериться, что никаких ошибок не произошло. Изменить некоторые параметры можно в файле /etc/sysconfig/oracle-xe-18c.conf.

Во избежание ошибок, необходимо удостовериться, что hostname операционной системы прописан в файлах /etc/hosts и /etc/hostname. Иначе получите следующее сообщение при настройке:

[Fatal] [DBT-06103] The port (5500) is already in use express edition 18c

Рекомендуется настроить сетевые параметры и сделать сетевой интерфейс автозапускаемым после перезагрузки операционной системы. В данном посте описывается настройка сети в Oracle Linux.

Для настройки паролей и завершения установки нужно запустить команду /etc/init.d/oracle-xe-18c configure

Установка БД успешно завершена. В конце установки описываются способы подключения к Pluggable и Container Databases, а также к Oracle Enterprise Manager for Oracle Database XE:

Connect to Oracle Database using one of the connect strings:
Pluggable database: dushanbe.localdomain:1539/XEPDB1
Multitenant container database: dushanbe.localdomain:1539
Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE

2.2. Теперь под пользователем oracle ОС в папке /home/oracle надо настроить файл .bash_profile, добавив переменные ORACLE_HOME, ORACLE_SID и путь $ORACLE_HOME/bin в разделе PATH. Назначается пароль пользователю oracle и работа в операционной системе производится под этим пользователем.

В домашней директории пользователя oracle (/home/oracle) ищется скрытый файл .bash_profile.

Далее файл открывается с помощью nano (или vi) и добавляются переменные ORACLE_HOME, ORACLE_SID и путь $ORACLE_HOME/bin в разделе PATH.

Изменения сохраняются и осуществляется повторный вход в систему под пользователем oracle.

3. Подключение к БД

После установки необходимо произвести подключение к БД, что позволит проверить работоспособность Oracle Database 18c XE. Для подключения к БД (multitenant container database) под пользователем SYS с помощью SQLPlus, необходимо запустить следующую команду sqlplus sys@XE as sysdba.

Выполняется запрос выборки данных из Container Database. Данный запрос показывает имеющиеся pluggable databases (PDB).

Перезагрузка операционной системы показывает, что listener и база данных не доступны, так как не настроен автоматический запуск этих служб (см. ниже).

Чтобы БД (инстанция) и listener запускались автоматически после включения или перезапуска ОС, выполняются следующие две команды под пользователем root:

Перезагружаем операционную систему. Как видно ниже, listener и база данных стартовали автоматически.

На этом установка и базовые настройки Oracle Database 18c Express Edition на Oracle Linux завершены. Container database и Pluggable database готовы к работе. В последующих постах будут рассмотрены подключение к Pluggable database и работа с ней.

4 thoughts on “ Установка Oracle Database 18c Express Edition на Oracle Linux ”

Не подскажите, а sqlplus должен изначально стоять? Столкнулся с проблемой: дистрибутив Linux Oracle. Дошёл до подключения к БД и команда не найдена… ОК, скачал oracle instantclient basic… И тут ошибка взаимосвязей… oracle-database-xe-18c конфликтует с oracle-instantclient-basic-21.1.0.0.0-1.x86_64
в Windows после установки Oracle DBXE18c сразу sqlplus работал….

Добрый день.
Спасибо за Ваш вопрос.

Утилита SQLPlus всегда доступна после успешной установки Oracle Database 18c Express Edition. Подключение к БД с помощью SQLPlus под какой учетной записью ОС выполняется (oracle или root)?

Подскажите как запустить tomcat после oracle ?

Добрый день!
Спасибо за Ваш вопрос.

Вам Apache Tomcat нужен для настройки ORDS? Если да, то есть два варианта установки ORDS:
1. Автономный (standalone) режим.
2. На сервере приложений (Oracle WebLogic Server, Apache Tomcat).

В этом посте подробно описан процесс установки и настройки ORDS в автономном режиме (standalone). К сожалению, пока не подготовил пост для второго варианта (на сервере приложений – Apache Tomcat).

Источник

Oracle® Database Express Edition

11 g Release 2 (11.2) for Linux x86-64

Welcome to Oracle Database Express Edition Installation Guide for Linux x86-64 . This guide covers the following topics:

The most up-to-date version of this installation guide is available from the Oracle Database Express Edition (Oracle Database XE) download page on Oracle Technology Network:

1 Introduction

Oracle Database XE is easy to install. Oracle Database XE provides an Oracle database and tools for managing the database.

Oracle Database XE supports the following development environments:

Oracle SQL Developer : Oracle SQL Developer is a graphical version of SQL*Plus that gives database developers a convenient way to perform basic tasks. You can connect to any target Oracle Database XE schema using standard Oracle database authentication. Once connected, you can perform operations on objects in the database.

Download and install Oracle SQL Developer from:

Oracle Application Express : Oracle Database XE includes Oracle Application Express, a rapid web application development tool for the Oracle database. Oracle Application Express is enabled by default in Oracle Database XE.

Java : Java is an open-source programing language that is designed for use in the distributed environment of the Internet. You can use Oracle JDeveloper, which is a free integrated Java development environment with support for the full development life cycle.

Download and install Oracle JDeveloper from:

PHP is an open-source server-side embedded scripting language that is designed for Web development. PHP code can be embedded in HTML. You can download and install PHP from http://www.php.net .

For more information on Oracle Database XE, see the following:

Oracle Database XE home page on the Oracle Technology Network:

Oracle Database XE Documentation Library:

Click the appropriate link on the Oracle Database XE home page on the Oracle Technology Network; or from the system menus, get to Oracle Database 11g Express Edition and select Get Help , then Read Documentation .

2 Requirements

This section covers the following topics:

2.1 Software Requirements

This section covers the following topics:

2.1.1 System Requirements

Table 1 provides system requirements for Oracle Database XE.

Table 1 Oracle Database XE Requirements

One of the following:

Oracle Enterprise Linux 4 Update 7

Oracle Enterprise Linux 5 Update 2

Red Hat Enterprise Linux 4 Update 7

Red Hat Enterprise Linux 5 Update 2

SUSE Linux Enterprise Server 10 SP2

SUSE Linux Enterprise Server 11

The following protocols are supported:

256 megabytes minimum, 512 megabytes recommended

1.5 gigabyte minimum

glibc should be greater than or equal to 2.3.4-2.41

make should be greater than or equal to 3.80

binutils should be greater than or equal to 2.16.91.0.5

gcc should be greater than or equal to 4.1.2

libaio should be greater than or equal to 0.3.104

2.1.2 Swap Space Requirements

Minimum swap space required for Oracle Database XE is 2 GB or twice the size of RAM, whichever is lesser.

2.1.3 Server Component Kernel Parameter Requirements

The Oracle Database XE installation checks your system for the following kernel parameter settings. If the kernel parameters of your system are less than the values listed in Table 2, then the installation will modify the kernel parameter setting to use the values in this table.

Table 2 Kernel Parameter Settings Required for Oracle Database XE

Requirement	Value

2.2 Permission Requirement for Installing Oracle Database XE

You must have root permission to install Oracle Database XE.

3 Licensing Restrictions

This section covers the following topics:

3.1 Oracle Database XE CPU Limitations

If Oracle Database XE is installed on a computer with more than one CPU (including dual-core CPUs), then it will consume, at most, processing resources equivalent to one CPU. For example, on a computer with two CPUs, if two Oracle database clients try to simultaneously execute CPU-intensive queries, then Oracle Database 11 g Standard Edition, Oracle Database 11 g Standard Edition One, or Oracle Database 11 g Enterprise Edition will use both CPUs to efficiently process the queries. However, with Oracle Database XE, the Oracle database will process the queries at the rate of a single CPU even if concurrent processing on two CPUs would be faster. To use the full processing resources of your computer, upgrade to Oracle Database 11 g Standard Edition, Oracle Database 11 g Standard Edition One, or Oracle Database 11 g Enterprise Edition.

3.2 Oracle Database XE Installation and Execution Restrictions

Only one installation of Oracle Database XE can be performed on a single computer. This does not affect any existing installation or new installations of Oracle Database 11 g Standard Edition, Oracle Database 11 g Standard Edition One, or Oracle Database 11 g Enterprise Edition. In addition, users can run only one instance of the Oracle Database XE database on each individual computer. To run more than one Oracle Database server instance or install more than one copy of the database software, upgrade to Oracle Database 11 g Standard Edition, Oracle Database 11 g Standard Edition One, or Oracle Database 11 g Enterprise Edition.

3.3 Oracle Database XE User Data Limitations

The maximum amount of user data in an Oracle Database XE database cannot exceed 11 gigabytes. If the user data grows beyond this limit, then an ORA-12592 error will appear. To use more than 11 gigabytes of user data, upgrade to Oracle Database 11 g Standard Edition, Oracle Database 11 g Standard Edition One, or Oracle Database 11 g Enterprise Edition.

3.4 Oracle Database XE RAM Limitation

The maximum amount of RAM that an Oracle Database XE database uses cannot exceed 1 gigabyte, even if more is available. Table 1, «Oracle Database XE Requirements» provides the minimum and recommended RAM that you should use. The exact amount of RAM that Oracle Database XE uses is computed automatically using Automatic Memory Management.

To use more than 1 gigabyte of RAM, upgrade to Oracle Database 11 g Standard Edition, Oracle Database 11 g Standard Edition One, or Oracle Database 11 g Enterprise Edition.

For more information about managing memory, refer to Oracle Database Express Edition 2 Day DBA .

3.5 HTTPS Support

HTTPS is not supported natively with the HTTP listener built into Oracle Database XE. If you want HTTPS support, use an alternative Web listener, such as Apache, that does provide HTTPS support, and provide proxies for the URLs provided by Oracle Database XE.

For information about managing security in Oracle Database XE, refer to Oracle Database Express Edition 2 Day DBA .

4 Installing Oracle Database XE

This section covers the following topics:

4.1 Procedure for Installing Oracle Database XE

Before attempting to install Oracle Database XE 11.2 uninstall any existing Oracle Database XE or database with the SID XE from the target system.

To install Oracle Database XE:

Log on to your computer with root permissions.

Go to the following Web site:

Click Free Download and follow the instructions to select and download the Linux version of Oracle Database XE.

Run the Oracle Database XE executable oracle-xe-11.2.0-1.0.x86_64.rpm to install Oracle Database XE.

The installation displays a status of its progress.

When prompted, run the following command:

Enter the following configuration information:

A valid HTTP port for the Oracle Application Express (the default is 8080)

A valid port for the Oracle database listener (the default is 1521)

A password for the SYS and SYSTEM administrative user accounts

Confirm password for SYS and SYSTEM administrative user accounts

Whether you want the database to start automatically when the computer starts (next reboot)

This completes configuration. The database starts during the boot process.

The password for the INTERNAL and ADMIN Oracle Application Express user accounts is initially the same as the SYS and SYSTEM administrative user accounts.

To start the database manually, run this command as root user:

To stop the database manually, run the following command as root user:

You can find the database creation logs in $ORACLE_HOME/config/log/* .

4.2 Performing a Silent Installation

The response file xe.rsp is shipped along with the Oracle Database XE executable .rpm file.

To perform a silent installation:

After downloading the installation executable (described under «Procedure for Installing Oracle Database XE»), prepare the response file xe.rsp that contains settings for the following values:

ORACLE_LISTENER_PORT : A valid listener numeric port value, so that you can connect to Oracle Database XE

ORACLE_HTTP_PORT : A valid HTTP port numeric value for Oracle Application Express

ORACLE_PASSWORD : A password value for the SYS and SYSTEM administrative user accounts

ORACLE_CONFIRM_PASSWORD : The SYS and SYSTEM password value again, to confirm it

ORACLE_DBENABLE : Yes ( y ) or no ( n ), to specify whether you want to start Oracle Database XE automatically when the computer starts

The default values are populated for ORACLE_LISTENER_PORT , ORACLE_HTTP_PORT , and ORACLE_DBENABLE in the response file.

Create a wrapper shell script to perform the silent installation.

It should contain commands similar to the following:

Run the wrapper script as the root user.

For details of the installation, see the XEsilentinstall.log file.

After you complete the silent installation, set the Oracle Database XE environment variables, which is described in Section 4.3, «Setting the Oracle Database XE Environment Variables».

You can find the database creation logs in $ORACLE_HOME/config/log/* .

4.3 Setting the Oracle Database XE Environment Variables

After you have installed and configured Oracle Database XE, users must set their environment before they use Oracle Database XE. They do not need to log on with root permissions to do so. Oracle Database XE provides a script that sets the necessary environment variables.

Follow these steps:

Go to the following directory:

Look for the following scripts:

oracle_env.csh (for C or tcsh shell)

oracle_env.sh (for Bourne, Bash, or Korn shell)

Run the appropriate script for your shell. For example:

Bourne, Bash, or Korn shell:

C or tcsh shell:

You may also want edit your login or profile files so that these environment variables are set properly each time you log in or open a new shell.

For Bourne, Bash, or Korn shell, enter the following line into the .bash_profile (to log in) or .bashrc file (to open a new shell):

For C or tcsh shell, enter the following line into the .login file (to log in) or .cshrc file (to open a new shell):

4.4 Making Oracle Database XE Available to Remote Clients

After you install Oracle Database XE, the Get Started With Oracle Database 11g Express Edition home page is only available from the local server, not remotely.

With remote HTTP access to Oracle Database XE, all information exchanged between the browser and the database is in clear text—that is, unencrypted—including database user names and passwords. If this is cause for concern, do not enable remote HTTP connection to the database.

To use the SQL Command Line, follow these steps:

Start SQL*Plus and log in as SYSTEM :

Or, if you are logging in remotely:

At the SQL prompt, enter the following command:

4.5 Compiling the Oracle ODBC Driver Demos

If you plan to compile and run the Oracle ODBC Driver demos, then follow these steps:

If you do not have unixODBC DriverManager installed, then download it from the following Web site:

Set the ODBCDM_HOME environment variable to point to the directory where you installed DriverManager.

Run the following make file to compile the Oracle ODBC Driver demos:

5 Starting Oracle Database XE

After you have installed Oracle Database XE, the database is up and running and you can begin using it right away, as follows:

If the database is currently stopped, start it as follows: click the Main menu (on Gnome) or the Applications menu (on KDE), then Oracle Database 11g Express Edition , and then click Start Database .

Go to the Main menu (on Gnome) or the Applications menu (on KDE), then Oracle Database 11g Express Edition , and then click Run SQL Command Line . Connect to the database using the user name SYSTEM , and supply the password that you created during configuration.

To begin learning about Oracle Database XE, use the OracleDatabase XE Documentation.

To access the Oracle Database XE Documentation, from the Main menu (on Gnome) or the Applications menu (on KDE), select Oracle Database 11g Express Edition , then Get Help , and then click Read Documentation .

To use Oracle Database XE, your user id must be a member of Linux group dba .

6 Deinstalling Oracle Database XE

When you deinstall Oracle Database XE, all components, including data files, the database, and the software, are removed. If you want to save your data files but remove the Oracle Database XE software and database, then first export the data by using one of the methods described in Oracle Database Express Edition 2 Day DBA before you deinstall.

Because the deinstallation process removes all files from the directory in which Oracle Database XE is installed, back up any files from the directory (if needed) before you deinstall.

This section covers the following topic:

6.1 Deinstalling the Oracle Database XE Software

Follow these steps:

Log on with root privileges.

Run the following command to deinstall Oracle Database XE:

7 Importing and Exporting Data between 10.2 XE and 11.2 XE

To import and export data between 10.2 XE and 11.2 XE, perform the following steps:

Copy the gen_inst.sql file from the upgrade directory of 11.2 XE shiphome to your local directory.

Connect to 10.2 XE database as SYS user and run gen_inst.sql . This will generate install.sql , gen_apps.sql and other .sql files. The files will be generated in the folder containing gen_inst.sql .

SQL> @ local_dir >/gen_inst.sql

where local_dir is the local directory where gen_inst.sql is copied

Do not copy the gen_inst.sql file into the 10.2 XE home directory if you plan to install XE 11.2 on the same system. All generated files get deleted if XE 10.2 is uninstalled.

To export the data from 10.2 XE database, perform the following steps:

Connect to 10.2 XE database as SYS user.

Create a dump folder dump_folder on the local file system.

Create directory object DUMP_DIR with READ and WRITE privilege to SYSTEM user.

Export data from 10.2 XE database to the dump folder.

Deinstall 10.2 XE if installation of 11.2 XE is planned on the same system.

Install 11.2 XE database. For more information see Section 4, «Installing Oracle Database XE».

To import data to the 11.2 XE database, perform the following steps:

Connect to 11.2 XE database as SYS user.

Create directory object DUMP_DIR with READ and WRITE privilege to SYSTEM user.

Import data to 11.2 XE database from the dump folder.

Connect to 11.2 XE database as SYS user and run the script install.sql , which was generated in Step 2. This will trigger the execution of ws.sql , gen._apps.sql, and other .sql files.

8 Reporting Security Vulnerabilities

If you find any security vulnerabilities with Oracle Database XE, then send a description of the problem to Oracle at the following e-mail address:

Include the following information in your e-mail:

A complete description of the problem you encountered

The version of Oracle Database XE you were using

The platform on which you were running Oracle Database XE

Any scripts or examples that may be helpful in tracking down the security problem

For more information on how Oracle handles security issues, visit:

9 Oracle Database XE Character and Language Configurations

Oracle Database XE is available only in Universal multi-language character set and language configuration:

The database is created using Unicode( AL32UTF8 ) character set, which is suitable for global data in any language.

Japanese, Brazilian Portuguese, and Simplified Chinese language message files are installed in ORACLE_HOME .

The Oracle Application Express user interface and database error messages are available in English, Japanese, Brazilian Portuguese, and Simplified Chinese.

10 Globalization Support: Configuring Locale and Character Sets with the NLS_LANG Parameter

This section explains how to configure globalization settings for Oracle Database XE. It covers the following topics:

10.1 About the NLS_LANG Parameter

Oracle provides globalization support that enables users to interact with a database in their preferred locale and character set settings. Setting the NLS_LANG environment variable specifies locale behavior for Oracle software. It sets the language and territory used by the client application and the database server. It also sets the character set for entering and displaying data by a client program, such as SQL*Plus.

The NLS_LANG parameter uses the following format:

NLS_LANG = LANGUAGE_TERRITORY . CHARACTER_SET

This format is explained in the following table:

Kernel Parameter	Setting

Parameter	Description
LANGUAGE	Specifies the language for displaying product messages, day names, and month names in SQL.

Oracle Database Globalization Support Guide provides more information about languages.

TERRITORY Specifies the cultural-specific conventions for date, number, time, and monetary formatting.

Oracle Database Globalization Support Guide provides more information about territory conventions.

CHARACTER_SET Specifies the encoding used by the client application, which is usually the character set of the source data being processed, and the character set used in displaying the output.

«Supported Character Sets» provides a list of supported character sets.

Oracle Database Globalization Support Guide provides information about the NLS_LANG parameter and Globalization Support initialization parameters.

10.2 Default Values for NLS_LANG

The locale setting of your Linux session affects how you should set your NLS_LANG parameter. Table 3 lists the different Linux languages and their default locale IDs, together with the corresponding NLS_LANG values.

Table 3 NLS_LANG Parameter Values for Linux Locales

BRAZILIAN PORTUGUESE_BRAZIL. AL32UTF8

10.3 Supported Character Sets

Table 4 lists the supported character sets in Oracle Database XE.

The character set AL16UTF16 can be used only as an NCHAR character set, and not as a database character set.

Table 4 Supported Universal Character Sets

Language	Locale ID	NLS_LANG

Unicode 4.0 UTF-16 Universal character set

Unicode 4.0 UTF-8 Universal character set

Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant

10.4 Charmap and Oracle Character Set

The character set mapping (charmap) of the locale ID assigned for each language may vary depending on the distribution and version of the Linux operating system. To determine the current character mapping, enter the following command in a shell:

Table 5 lists each charmap with its corresponding Oracle character set. In general, you should update the CHARACTER_SET part of the NLS_LANG parameter according to the actual charmap of your Linux session.

Table 5 Mapping charmap to Oracle Character Set

Name	Description

11 Documentation Accessibility

For information about Oracle’s commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc .

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Oracle Database Express Edition Installation Guide , 11 g Release 2 (11.2) for Linux x86-64

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are «commercial computer software» or «commercial technical data» pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Источник

Locale charmap	Oracle Character Set