Download Oracle Application Express. Oracle APEX 20.1 is fully supported through Oracle Support Services on all Editions (EE, SE2, SE, and SE1) of the Oracle database, 11.2.0.4 or higher with a valid Oracle Database Technical Support agreement. Whether you are a developer, a DBA, a data scientist, an educator, or just curious about databases, Oracle Database 18c Express Edition (XE) is the ideal way to get started. It is the same powerful Oracle Database that enterprises rely on worldwide, packaged for simple download, ease-of-use, and a full-featured experience.
Installation Guide
11g Release 2 (11.2)for Linux x86-64
E18802-03
July 2011
Welcome to Oracle Database Express Edition Installation Guide for Linux x86-64. This guide covers the following topics:
Note:
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:
For more information on Oracle Database XE, see the following:
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
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
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 11g Standard Edition, Oracle Database 11g Standard Edition One, or Oracle Database 11g 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 11g Standard Edition, Oracle Database 11g Standard Edition One, or Oracle Database 11g 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 11g Standard Edition, Oracle Database 11g Standard Edition One, or Oracle Database 11g 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 11g Standard Edition, Oracle Database 11g Standard Edition One, or Oracle Database 11g 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 11g Standard Edition, Oracle Database 11g Standard Edition One, or Oracle Database 11g 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 11g Standard Edition, Oracle Database 11g Standard Edition One, or Oracle Database 11g 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:
This completes configuration. The database starts during the boot process.
Note:
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:
Note:
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 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'.
Note:
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.
How to download videos from messenger mac. Follow these steps:
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): School days visual novel english download mac.
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
Skitch mac os x download. 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.
Security Note:
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:
4.5 Compiling the Oracle ODBC Driver Demos
If you plan to compile and run the Oracle ODBC Driver demos, then follow these steps:
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:
Note:
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:
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:
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:
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:
'Globalization Support: Configuring Locale and Character Sets with the NLS_LANG Parameter' provides additional character and language information.
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:
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
Oracle Database Latest Download
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
10.4 Charmap and Oracle Character SetOracle 10g Express Edition Download
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
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 For Mac Download Full
Oracle Database Express Edition Installation Guide, 11g Release 2 (11.2) for Linux x86-64
E18802-03
Copyright © 2005, 2011, Oracle and/or its affiliates. All rights reserved.
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, 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.
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.
Download Oracle 11g Express Edition
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.
Oracle Express 11g Download
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.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |