Installation Guide Oracle® Database Express Edition

1 oracle Database Express EditionInstallation Guide21c for Microsoft WindowsF32978-01 October 2021 oracle Database Express Edition Installation Guide , 21c for Microsoft WindowsF32978-01 Copyright 2005, 2021, oracle and/or its software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense 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. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in this is software or related documentation that is delivered to the Government or anyone licensing it onbehalf of the Government, then the following notice is GOVERNMENT END USERS: oracle programs (including any operating system, integrated software,any programs embedded, installed or activated on delivered hardware, and modifications of such programs)and oracle computer documentation or other oracle data delivered to or accessed by Government endusers are "commercial computer software" or "commercial computer software documentation" pursuant to theapplicable Federal Acquisition Regulation and agency-specific supplemental regulations.

2 As such, the use,reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/oradaptation of i) oracle programs (including any operating system, integrated software, any programsembedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oraclecomputer documentation and/or iii) other oracle data, is subject to the rights and limitations specified in thelicense contained in the applicable contract. The terms governing the Government s use of oracle cloudservices are defined by the applicable contract for such services. No other rights are granted to the software or hardware is developed for general use in a variety of information management is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use.

3 oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous , Java, and MySQL are registered trademarks of oracle and/or its affiliates. Other names may betrademarks of their respective and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc,and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registeredtrademark of The Open 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 expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and oracle .

4 oracle Corporation and its affiliates will not beresponsible 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 PrefaceAudienceviDocumentation AccessibilityviCommand SyntaxviRelated DocumentsviiConventionsviii1 Installation Guide2 Introduction3 Studio and Visual Studio Requirement for Installing oracle Database XE3-24 Licensing Database XE CPU Database XE Installation and Execution Database XE User Data Database XE RAM Limitation4-15 Installing oracle Database the a Silent Installation5-6iii6 Connecting to oracle Database XE7 Starting and Stopping oracle Database XE8 Using Enterprise Manager oracle Database EM Express Available to Remote Clients8-19 Moving from Previous Versions of oracle Database XE to XE oracle Database XE 18c PDB to XE 21c9-110 Migrating Data and Applications11 Deinstalling oracle Database Using User Using Silent Mode11-212 Reporting Security Vulnerabilities13 Globalization Language and Locale

5 Preferences for Client Connections13-1ivList of Tables3-1 oracle Database XE Requirements for Microsoft Windows 64-bit3-15-1 Configuration, Database Files and Logs Location5-55-2 Response File Parameters5-7vPrefaceThis Guide explains how to install and configure oracle Database Express Edition onMicrosoft Guide also provides information about resources available to develop applicationusing oracle application Express Edition , and how to remove the Database software. Audience Documentation Accessibility Command Syntax Related Documents ConventionsAudienceThis Guide is intended primarily for application developers who are either developingapplications or converting applications to run in the oracle Database Database 21c Express Edition ( oracle Database XE) is a free version of theworld's most capable relational Database . oracle Database XE is easy to install, easyto manage, and easy to develop with. With oracle Database XE, you use an intuitive,browser-based interface to administer the Database , create tables, views, and otherdatabase objects, import, export, and view table data, run queries and SQL scripts,and generate AccessibilityFor information about oracle 's commitment to accessibility, visit the OracleAccessibility Program website at to oracle SupportOracle customers that have purchased support have access to electronic supportthrough My oracle Support.

6 For information, visit or visit you are hearing SyntaxRefer to these command syntax conventions to understand command examples in $Bourne or BASH shell prompt in a command example. Do not enter the promptas part of the Shell prompt in a command example. Do not enter the prompt as part of thecommand.#Superuser (root) prompt in a command example. Do not enter the prompt as partof the command syntaxbackslash \A backslash is the UNIX and Linux command continuation character. It is used incommand examples that are too long to fit on a single line. Enter the commandas displayed (with a backslash) or enter it on a single line without a backslash:dd if=/dev/rdsk/c0t1d0s6 of=/dev/rst0 bs=10b \ count=10000braces { }Braces indicate required items:.DEFINE {macro1}brackets [ ]Brackets indicate optional items:cvtcrt termname [outfile]ellipses ..Ellipses indicate an arbitrary number of similar items:CHKVAL fieldname value1 value2 .. valueNitalicItalic type indicates a variable.

7 Substitute a value for the variable:library_name vertical line |A vertical line indicates a choice within braces or brackets:FILE filesize [K|M]Related DocumentsTo help you with your development efforts, consult the books in the development category ofthe oracle Database documentation set at oracle Database DevelopmentTitleContent2 Day developer 's GuideExplains how to develop applications with Day + Java developer s GuideProvides a tutorial that shows you how to use Javaand JDBC to connect to oracle Database , anddemonstrates how to develop a simple Javaapplication that accesses and modifies more information, see these documents in the oracle Database documentationset: oracle Database SQL Language Reference oracle Database PL/SQL Language Reference oracle Database PL/SQL Packages and Types Reference oracle Database JSON developer s Guide oracle Database SODA for PL/SQL developer 's Guide oracle Database Development Guide oracle Database Administrator's Guide oracle Database SecureFiles and Large Objects developer 's Guide oracle Database Object-Relational developer 's Guide oracle Database Concepts oracle Database Sample SchemasSee Also: oracle Application Express Release following text conventions are used in this document.

8 ConventionMeaningboldfaceBoldface type indicates graphical user interface elements associatedwith an action, or terms defined in text or the type indicates book titles, emphasis, or placeholder variables forwhich you supply particular type indicates commands within a paragraph, URLs, codein examples, text that appears on the screen, or text that you GuideWelcome to oracle Database Express Edition Installation Guide for Microsoft Windows. Thisguide covers the following topics: Introduction Requirements Licensing Restrictions Installing oracle Database XE Connecting to oracle Database XE Starting and Stopping oracle Database XE Using Enterprise Manager Express Moving from Previous Versions of oracle Database XE to XE 21c Migrating Data and Applications #unique_24 Reporting Security Vulnerabilities Globalization Support1-12 IntroductionOracle Database Express Edition (XE) is a free Edition of oracle EnvironmentsOracle Database XE supports the following development environments (this is not a completelist): Java: Develop and deploy modern Database -bound Java Web applications (Servlets),modules (Microservices) or standalone Java frameworks using the oracle JDBC Driver,the Universal Connection Pool (UCP), and the Database -embedded JVM (for in-place,server-side processing).

9 Visit for more information C and C++ : Developers can use oracle Call Interface (OCI) and oracle C++ CallInterface (OCCI) to create high performance programs accessing oracle Database and the ODPI-C wrapper over OCI are also formore information .NET: Visual Studio and .NET developers can use oracle Data Provider for .NET( ) and oracle developer Tools for Visual Studio (ODT) for full development lifecycle for moreinformationFor a walkthrough on creating a .NET application with oracle Database XE:visit oracle SQL developer : oracle SQL developer is a graphical version of SQL*Plus thatgives Database developers a convenient way to perform basic tasks. You can connect toany target oracle Database XE schema using standard oracle Database connected, you can perform operations on objects in the and install oracle SQL developer from: oracle developer Tools for VS Code: This free Visual Studio Code extension enablesediting and execution of SQL and PL/SQL for oracle Database and oracle and install oracle developer Tools for VS Code from the Visual Studio CodeMarketplace: oracle Application Express : oracle Application Express (APEX) is a rapid webapplication development tool for the oracle and install Application Express from:2-1 oracle REST Data Services (ORDS): ORDS makes it easy to develop modernREST interfaces for relational data in the oracle Database and the OracleDatabase 21c JSON Document and install ORDS from: SODA (Simple oracle Document Access) APIs that let you develop NoSQL-styleapplications against collections of JSON documents.

10 Native language SODA drivers are available for common more informationScripting LanguagesYou can use scripting languages such as: PHPA ccess oracle Database with the PHP OCI8 extension or the PDO_OCI OCI8 and PDO_OCI are part of the PHP open source for more information on PHP OCI8 and for more information on PDO_OCI PythonThe cx_Oracle Python extension module enables access to oracle for more information aboutcx_Oracle Python extension module node-oracledb add-on for powers high performance oracle for more information about node-oracledb ROracleROracle is an open source R package supporting a DBI-compliant oracle driverbased on the high performance OCI for moreinformation about ROracle RubyBuild Ruby and Ruby on Rails applications using the ruby-oci8 driver or JRubywith the oracle Enhanced Adapter for : for information about the ruby-oci8 for information about JRuby for information about OracleEnhanced Adapter OthersChapter 22-2 Accessing oracle Database XE from other languages including Go is possible usingcommunity drivers based on OCI or Open Source drivers from: More About oracle Database XEFor more information on oracle Database XE, see the following: oracle Database XE home page on the oracle Technology Network:Visit oracle Database XE Discussion Forum:You can search that forum to see if the problem has already been discussed.