Oracle Database upgrade and migration methods : including Oracle 12c Release 2 / Y V Ravikumar, K M Krishnakumar, Nassyam Basha.
Ravikumar, Y V, author.; Krishnakumar, K M., author.; Basha, Nassyam, author.
2017
QA76.9.D3
Available Online

Linked e-resources

Linked Resource Online Access
Concurrent users Unlimited
Authorized users Authorized users
Document Delivery Supplied Can lend chapters, not whole ebooks

Details

Title Oracle Database upgrade and migration methods : including Oracle 12c Release 2 / Y V Ravikumar, K M Krishnakumar, Nassyam Basha.
Author Ravikumar, Y V, author.
ISBN 9781484223284 (electronic book)
1484223284 (electronic book)
9781484223277
1484223276
DOI https://doi.org/10.1007/978-1-4842-2328-4
Published [United States] : Apress, 2017.
Distributed New York, NY : Distributed to the book trade worldwide by Springer,
Copyright ©2017
Language English
Description 1 online resource.
Other Standard Identifiers 10.1007/978-1-4842-2328-4 doi
Call Number QA76.9.D3
Dewey Decimal Classification 005.74
Summary Learn all of the available upgrade and migration methods in detail to move to Oracle Database version 12c. You will become familiar with database upgrade best practices to complete the upgrade in an effective manner and understand the Oracle Database 12c patching process. So it’s time to upgrade Oracle Database to version 12c and you need to choose the appropriate method while considering issues such as downtime. This book explains all of the available upgrade and migration methods so you can choose the one that suits your environment. You will be aware of the practical issues and proactive measures to take to upgrade successfully and reduce unexpected issues. With every release of Oracle Database there are new features and fixes to bugs identified in previous versions. As each release becomes obsolete, existing databases need to be upgraded. Oracle Database Upgrade and Migration Methods explains each method along with its strategy, requirements, steps, and known issues that have been seen so far. This book also compares the methods to help you choose the proper method according to your constraints. Also included in this book: Pre-requisite patches and pre-upgrade steps Patching to perform changes at the binary and database level to apply bug fixes What You Will Learn: Understand the need and importance of database upgrading and migration Be aware of the challenges associated with database upgrade decision making Compare all upgrade/migration methods Become familiar with database upgrade best practices and recommendations Understand database upgrade concepts in high availability and multi-tenant environments Know the database downgrade steps in case the upgraded database isn’t compatible with the environment Discover the features and benefits to the organization when it moves from the old database version to the latest database version Understand Oracle 12c patching concepts Who This Book Is For: Core database administrators, solution architects, business consultants, and database architects.
Note Includes index.
Access Note Access limited to authorized users.
Digital File Characteristics text file PDF
Source of Description Online resource; title from PDF title page (viewed Mar. 10, 2017).
Added Author Krishnakumar, K M., author.
Basha, Nassyam, author.
Available in Other Form Print version: 1484223276
Linked Resources Online Access
Record Appears in Online Resources > Ebooks
All Resources
At a Glance; Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Foreword; Chapter 1: Getting Started; Why Are Database Upgrades Necessary?; New Innovations; Bug Fixes; Supporting Environment; Certification; Database Support Level; Benefits of a Database Upgrade; Hurdles That Affect the Database Upgrade Decision; Types of Database Upgrade; Things to Consider Before Upgrading; Engineers Involved in the Upgrade Activity; Database Administrator; Storage Administrator; System Administrator; Network Administrator; Solution Architect

Application Team Upgrade Compatibility Matrix; Best Practices for a Database Upgrade; Database Migration; Situations That Demand a Migration; Things to Consider Before Migration; What This Book Covers; Summary; Chapter 2: Database Upgrade Methods; Oracle Binary Relinking; Relinking Process; Known Issues; Database Upgrade Methods; The Database Upgrade Assistant; Prerequisites for the DBUA; Upgrade Compatibility Matrix; Pre-upgrade Checks; Activities Performed by the DBUA; Best Practices with the DBUA; Upgrade Steps; Sample Restore Script; 12c DBUA New Features

Use Flashback and Guarantee Restore Point DBUA Upgrade Steps; Pre-upgrade Steps; Upgrade Steps; Post-upgrade Steps; How to Make Sure the Upgrade Is Successful; Limitations; Known Issues; DBUA in Silent Mode; Comparison Between 11g R2 DBUA and 12c R1 DBUA; Database Manual Upgrade; Pre-upgrade Tasks; Pre-upgrade Script Execution; Execution Method; 12c Pre-upgrade Execution Method; Pre-upgrade Fixup Script; Post-upgrade Fixup Script; Recommended Steps for the Source Database; Database Backup; Statistics Collection; Time Zone Version; Datafile Status; CONNECT Role

Database Link with PasswordMaterialized Views; Disable Database Vault; Sysaux Tablespace; Disable Cron or Scheduled Jobs; Sys and System Tablespace; Recycle Bin; Outstanding Distributed Transactions; Flash Recovery Area; Audit User and Roles; Creating Flashback Restore Point; Authenticated SSL Users; Hidden/Underscore Parameters; PSU Patches Installation; Upgrade Steps; If Datafiles Stay in the Same Location After the Upgrade; If the Datafiles Location Is Different from the Source; Execute the Upgrade Script; 12c Upgrade Script Execution; Parallelism; Phases; Post-upgrade Steps

Upgrade the Time Zone After the Database Upgrade Upgrade Statistics Table; Enable Database Vault; Upgrade Externally Authenticated SSL Users; Enable Hidden Parameter; Comparison Between 11g R2 and 12c R1; Traditional Export/Import; Compatibility Version Matrix; Upgrade Steps; Data Pump; Parallel; Network_link; Remap Datafile; Estimate_only; Version; Stop and Reattach the Job; Upgrade Steps; Transportable Tablespace; Things to Consider; Prerequisites to Perform Transportable Tablespace; Upgrade Steps; Limitations; Advantages; Database Upgrade Using Oracle GoldenGate

Browse Subjects

Show more subjects...

Statistics

from
to
Export