Oracle Database XE 11gR2 Jump Start Guide

Oracle Database XE 11gR2 Jump Start Guide

By : Asif Momen

Buy this Book

Oracle Database XE 11gR2 Jump Start Guide

By: Asif Momen

Buy this Book

Overview of this book

Oracle Database XE 11gR2 is an excellent beginner-level database and is a great platform to learn database concepts. "Oracle Database XE 11gR2 Jump Start Guide" helps you to install, administer, maintain, tune, back up and upgrade your Oracle Database Express Edition. The book also helps you to build custom database applications using Oracle Application Express.Using this book, you will be able to install Oracle Database XE on Windows/Linux operating system.This book helps you understand different database editions and it guides you through the installation procedure with the aid of screenshots. You will learn to interact with the database objects. You will gain a solid understanding of stored sub-programs which is followed by an introduction to Oracle Application Express (APEX). Solid database performance tuning strategies are also discussed in this book followed by backup and recovery scenarios. All in all, "Oracle Database XE 11gR2 Jump Start Guide" delivers everything that you should know to get started with Oracle Database administration.

Oracle Database XE 11gR2 Jump Start Guide

Credits

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Database Editions and Oracle Database XE

About Oracle

Oracle Database Express Edition (XE)

Summary

References

Installing and Uninstalling Oracle Database XE

Downloading Oracle Database 11g XE

Installing Oracle Database 11g XE on Windows XP (32-bit)

Uninstalling Oracle Database 11g XE on Windows XP (32-bit)

Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)

Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)

Summary

Connecting and Configuring Oracle Database 11g XE

Local database connections

Remote database connections

Changing SGA and PGA sizes

Summary

Accessing Table Data, DML Statements, and Transactions

Unlocking sample user accounts

Installing SQL Developer

Connecting SQL Developer to Oracle Database 11g XE

About TAB and DUAL

Writing simple queries

Selecting data from multiple tables

Exploring common functions

What are Transaction Control Statements?

Understanding DML statements

Summary

References

Creating and Managing Schema Objects

Data Definition Language

Creating and managing tables

Creating and managing indexes

Integrity constraints

Creating and managing views

Creating and managing synonyms

Creating and managing sequences

Gathering statistics

Summary

References

Developing Stored Subprograms and Triggers

PL/SQL data types

Stored subprograms

Creating stored subprograms

About packages

Exception handling

Wrapping up the PL/SQL stored programs

PL/SQL triggers

Summary

References

Building a Sample Application with Oracle Application Express

What is Oracle Application Express (APEX)?

Creating application users

Loading and unloading data to a text file

Application Express Dashboard

Summary

References

Managing Database and Database Storage

Memory structure

Automatic Memory Management

Important background processes

Physical and logical database structures

Managing the Flash Recovery Area

Summary

Moving Data between Oracle Databases

Exporting and importing data

Moving data between Oracle Database 10g XE and Oracle Database 11g XE

Exporting data using SQL Developer

Summary

Upgrading Oracle Database 11g XE to Other Database Editions

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

Summary

Backup and Recovery

Introduction to backup and recovery

Recovery Manager

Connecting to Oracle Database XE using RMAN

The ARCHIVELOG mode

Backing up a database (the NOARCHIVELOG mode)

Simulating a database failure (the NOARCHIVELOG mode)

Restoring the NOARCHIVELOG database

Configuring the RMAN environment

Backing up the ARCHIVELOG database

Simulating a database failure (the ARCHIVELOG mode)

Restoring the ARCHIVELOG database

Summary

References

Tuning Oracle Database 11g XE

Performance tuning

Performance tuning approach

Avoiding common pitfalls

Autotrace utility

Explain Plan

Using indexes

Dynamic performance views

Statspack

Summary

References

Features Available with Oracle Database 11g XE

Features available

Features not available

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Backing up a database (the NOARCHIVELOG mode)

You can manually take a backup using the BACKUP command in RMAN or use the Oracle Database XE-supplied script. In this section we will use the Oracle Database XE-supplied script to perform a full database backup. Remember, RMAN by default creates backups to disk.

Backing up a database in the NOARCHIVELOG mode requires the database to be in a MOUNT state. This backup is called a consistent backup. When a consistent backup is restored, there is no need to perform any recovery.

Start the backup by running the Oracle Database XE-supplied backup script, located under Startup | Oracle Database 11g Express Edition | Backup Database on a Windows machine, and by executing $ORACLE_HOME/config/scripts/backup.sh on a Linux environment. The backup script does the following:

Shuts down the database
Starts the database in MOUNT mode
Performs backup
Opens the database for read/write operations

The following screenshot shows RMAN backup in progress on a Windows...

Oracle Database XE 11gR2 Jump Start Guide

By : Asif Momen

Oracle Database XE 11gR2 Jump Start Guide

By: Asif Momen

Overview of this book

Related Content you might be interested in

Current Title:

Oracle Database XE 11gR2 Jump Start Guide

Backing up a database (the NOARCHIVELOG mode)