Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle Database XE 11gR2 Jump Start Guide

You're reading from   Oracle Database XE 11gR2 Jump Start Guide Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and ebook.

Arrow left icon
Product type Paperback
Published in Jul 2012
Publisher Packt
ISBN-13 9781849686747
Length 146 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Asif Momen Asif Momen
Author Profile Icon Asif Momen
Asif Momen
Arrow right icon
View More author details
Toc

Table of Contents (20) Chapters Close

Oracle Database XE 11gR2 Jump Start Guide
Credits
About the Author
Acknowledgement
About the Reviewers
1. www.PacktPub.com
2. Preface
1. Database Editions and Oracle Database XE FREE CHAPTER 2. Installing and Uninstalling Oracle Database XE 3. Connecting and Configuring Oracle Database 11g XE 4. Accessing Table Data, DML Statements, and Transactions 5. Creating and Managing Schema Objects 6. Developing Stored Subprograms and Triggers 7. Building a Sample Application with Oracle Application Express 8. Managing Database and Database Storage 9. Moving Data between Oracle Databases 10. Upgrading Oracle Database 11g XE to Other Database Editions 11. Backup and Recovery 12. Tuning Oracle Database 11g XE Features Available with Oracle Database 11g XE

Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition


This section provides a step-by-step guide on upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition. Ensure that the release number and patch level of Enterprise Edition server software are the same as the original Express Edition server software. For example, if the Express Edition is 11.2.0.2, then your Enterprise Edition should also be 11.2.0.2.

The following are the steps to upgrade Oracle Database 11g XE (11.2.0.2) to Oracle Database 11g Enterprise Edition on a Windows environment:

  1. 1. Shut down the database.

  2. 2. Stop Windows service (this step is not required under Linux).

  3. 3. Back up the database. You may use one of the following three backup methods to safeguard your database before starting the upgrade process:

    • Oracle's export utility (discussed in the previous chapter). If you choose to use this method, it should be performed before shutting down the database.

    • RMAN Backup (discussed in the next...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image