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 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. 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. Discussion forum: 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 Go to Online Forum. 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.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. 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. 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.x8664.rpm to install Oracle Database XE. # rpm -ivh downloads/oracle-xe-11.2.0-1.0.x8664.rpm The installation displays a status of its progress.
When prompted, run the following command: # /etc/init.d/oracle-xe configure. 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. 4.2 Performing a Silent Installation The response file xe.rsp is shipped along with the Oracle Database XE executable.rpm file. 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: /u01/app/oracle/product/11.2.0/xe/bin.
Look for the following scripts:. oracleenv.csh (for C or tcsh shell). oracleenv.sh (for Bourne, Bash, or Korn shell). Run the appropriate script for your shell.
For example:. Bourne, Bash, or Korn shell: $./oracleenv.sh. C or tcsh shell:% source oracleenv.csh 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.bashprofile (to log in) or.bashrc file (to open a new shell):. /u01/app/oracle/product/11.2.0/xe/bin/oracleenv.sh For C or tcsh shell, enter the following line into the.login file (to log in) or.cshrc file (to open a new shell): source /u01/app/oracle/product/11.2.0/xe/bin/oracleenv.csh. 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:. Start SQL.Plus and log in as SYSTEM: $ sqlplus system Enter password: SYSTEMpassword Or, if you are logging in remotely: $ sqlplus system@ xeserverhostname Enter password: SYSTEMpassword.
At the SQL prompt, enter the following command: SQL EXEC DBMSXDB.SETLISTENERLOCALACCESS(FALSE). 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. 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 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:. 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 geninst.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 geninst.sql. This will generate install.sql, genapps.sql and other.sql files.
The files will be generated in the folder containing geninst.sql. SQL @/geninst.sql where localdir is the local directory where geninst.sql is copied. Note: Do not copy the geninst.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 dumpfolder on the local file system. Create directory object DUMPDIR with READ and WRITE privilege to SYSTEM user.
SQL CREATE DIRECTORY DUMPDIR AS '/'; SQLGRANT read, write ON DIRECTORY DUMPDIR TO system;. Export data from 10.2 XE database to the dump folder. Expdp system/ systempassword full=Y EXCLUDE=SCHEMA: 'LIKE 'APEX% ' ',SCHEMA: 'LIKE 'FLOWS% ' ' directory=DUMPDIR dumpfile=DB10G.dmp logfile=expdpDB10G.log expdp system/ systempassword TABLES=FLOWSFILES.WWVFLOWFILEOBJECTS$ directory=DUMPDIR dumpfile=DB10G2.dmp logfile=expdpDB10G2.log. 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.
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 DUMPDIR with READ and WRITE privilege to SYSTEM user. SQL CREATE DIRECTORY DUMPDIR AS '/'; SQLGRANT read, write ON DIRECTORY DUMPDIR TO system;. Import data to 11.2 XE database from the dump folder. Impdp system/ systempassword full=Y directory=DUMPDIR dumpfile=DB10G.dmp logfile=expdpDB10G1.log impdp system/ systempassword directory=DUMPDIR TABLEEXISTSACTION=APPEND TABLES=FLOWSFILES.WWVFLOWFILEOBJECTS$ dumpfile=DB10G2.dmp logfile=expdpDB10G1b.log. Connect to 11.2 XE database as SYS user and run the script install.sql, which was generated in Step.
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 ORACLEHOME. The Oracle Application Express user interface and database error messages are available in English, Japanese, Brazilian Portuguese, and Simplified Chinese. Provides additional character and language information. 10.1 About the NLSLANG Parameter Oracle provides globalization support that enables users to interact with a database in their preferred locale and character set settings. Setting the NLSLANG 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 NLSLANG parameter uses the following format: NLSLANG = LANGUAGETERRITORY. CHARACTERSET This format is explained in the following table. 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. CHARACTERSET 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. Provides a list of supported character sets. Oracle Database Globalization Support Guide provides information about the NLSLANG parameter and Globalization Support initialization parameters. 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:% locale charmap UTF-8 lists each charmap with its corresponding Oracle character set.
In general, you should update the CHARACTERSET part of the NLSLANG parameter according to the actual charmap of your Linux session. Table 5 Mapping charmap to Oracle Character Set Locale charmap Oracle Character Set UTF-8 AL32UTF8 ISO-8859-1 WE8ISO8859P1 ISO-8859-2 EE8ISO8859P2 ISO-8859-3 SE8ISO8859P3 ISO-8859-4 NEE8ISO8859P4 ISO-8859-5 CL8ISO8859P5 ISO-8859-6 AR8ISO8859P6 ISO-8859-7 EL8ISO8859P7 ISO-8859-8 IW8ISO8859P8 ISO-8859-9 WE8ISO8859P9 ISO-8859-13 BLT8ISO8859P13 ISO-8859-14 CEL8ISO8859P14 ISO-8859-15 WE8ISO8859P15 BIG5 ZHT16BIG5 BIG5-HKSCS ZHT16HKSCS CP1251 CL8MSWIN1251 CP1255 IW8MSWIN1255 EUC-JP JA16EUC EUC-KR KO16KSC5601 EUC-TW ZHT32EUC GB18030 ZHS32GB18030 GB2312 ZHS16CGB231280 GBK ZHS16GBK TIS-620 TH8TISASCII. 11 Documentation Accessibility For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website. Access to Oracle Support Oracle customers have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.
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.
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 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. Scripting on this page enhances content navigation, but does not change the content in any way.
Here is the step by step guide for Installing Oracle Database Express Edition 11g Release 2 on Ubuntu 12.10 Step 1. Managing Swap partition.
The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g.
But the upgrade doc requires a data pump export to be done from 10g and then data pump import it to 11g. But the concern is the 10g exceeding its limit of 4GB and hence will not allow a data pump export to be done.
Is there any alternate option to move the data to 11g other than data pump export and import. Have tried the export with expdp but i get an error saying the database has exceeded th 4gb limit. I would try the following:. Install an oracle 10g database software that I download from the (i have the appropriate license). create an empty database with this software. using the exp-tool (classical export, not datapump) to make an export from the database.
import the dumpfile (with the classical imp tool) in the empty 10g database I created. now i do the export from this database and import this in the 11g database step 3.
Is possible because the classical export does not create any table in the database in contrast to the datapump export. So i think i will not hit the 4g LIMIT ERROR step 5 is possible because now the expdp is not constrained by any 4G limit. It is not supported to import in step 4 into an 11g database but one can try if this is possible.
Attention, Internet Explorer User Announcement: Oracle Community has discontinued support for Internet Explorer 7 and below. In order to provide the best platform for continued innovation, Oracle Community no longer supports Internet Explorer 7. Oracle Community will not function with this version of Internet Explorer. Please consider upgrading to a more recent version of Internet Explorer, or trying another browser such as Firefox, Safari, or Google Chrome. (Please remember to honor your company's IT policies before installing new software!).
The Oracle Management Pack is a solution that enables monitoring of all Oracle components (including RAC, ASM, Data Guard and FRA) and tablespace availability within Microsoft’s System Center Operations Manager. POWERING INNOVATION BY SIMPLIFYING IT Hardware and software, engineered to work together Designed for optimum performance and efficiency, while eliminating IT complexity and cost. From the data center to the cloud, Oracle not only removes the complexity that stifles business innovation, but also engineers in speed, reliability, security, and manageability. The result is an integrated stack of best-in-class hardware and software products, with each layer designed to work together according to open industry standards. ORACLE MANAGEMENT PACK Native: Integrates fully into System Center 2012 & 2016 The OpsLogix Oracle Management Pack, just like all OpsLogix Management Packs contains and self-deploys the relevant components that are necessary to connect to the particular cross-platform solution. The default configuration involves read-only permissions which limit security risks to the cross-platform solution. This enforces a zero-touch monitoring policy.
Oracle Management Pack Performance and State monitoring The OpsLogix Oracle Management Pack, just like all OpsLogix Management Packs displays full class Alerts and different performance metrics on the components being monitored. Spring security grails plugin. OpsLogix MP’s contain inbuilt standard dashboards which provide an easy overview of the performance trends of the solutions-platform it is monitoring.
The OpsLogix Oracle Management Pack was designed with the assistance of Oracle consultants who placed operational emphasis on the perspective of the Oracle administrator. The OpsLogix Oracle Management Pack is agentless and makes use of the to connect the Oracle instances to OpsMgr.
The OpsLogix Oracle Management Pack contains authoring templates enabling companies to customize what they wish to have monitored in OpsMgr. Root cause analysis The OpsLogix Oracle Management Pack, just like all OpsLogix Management Packs contains complete drill-down diagram views of the solutions-platform components. Additionally, inbuilt best practice expertise articles offer suggestions, call-to-action advice and/or contain useful informative links related to particular alerts and warnings within OpsMgr as well as the product solution it is monitoring. Because OpsLogix MP’s fully integrate within System Center, the complete Microsoft reports library found in OpsMgr can be linked to the parameters and performance metrics collected by the MP.