Skip to main content
  • Book
  • © 2019

Oracle DBA Mentor

Succeeding as an Oracle Database Administrator

Apress

Authors:

  • Also teaches how to find answers using community, social media, and tech support resources

  • Focuses on the operational aspects of database administration that transcend individual software releases

  • Imparts a sense of confidence that readers can set up an Oracle database that will meet their needs

Buy it now

Buying options

eBook USD 49.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 64.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (21 chapters)

  1. Front Matter

    Pages i-xx
  2. Initial Setup

    1. Front Matter

      Pages 1-1
    2. Introduction

      • Brian Peasland
      Pages 3-11
    3. Working As a DBA

      • Brian Peasland
      Pages 13-22
    4. Creating Our Server

      • Brian Peasland
      Pages 23-41
    5. Disk Layouts

      • Brian Peasland
      Pages 43-51
    6. Installing Oracle

      • Brian Peasland
      Pages 53-69
    7. Creating Our Database

      • Brian Peasland
      Pages 71-87
  3. Using Oracle Database

    1. Front Matter

      Pages 89-89
    2. Recovery and Backup

      • Brian Peasland
      Pages 91-114
    3. Security

      • Brian Peasland
      Pages 115-130
    4. Connecting to Oracle

      • Brian Peasland
      Pages 131-154
    5. Test Cases

      • Brian Peasland
      Pages 155-173
  4. Learning Oracle Database

    1. Front Matter

      Pages 175-175
    2. Tools

      • Brian Peasland
      Pages 177-200
    3. Diagnostics

      • Brian Peasland
      Pages 201-220
    4. Oracle Documentation

      • Brian Peasland
      Pages 221-241
    5. Data Dictionary

      • Brian Peasland
      Pages 243-264
  5. Maintaining the Oracle Database

    1. Front Matter

      Pages 265-265
    2. My Oracle Support

      • Brian Peasland
      Pages 267-284

About this book

New Oracle database administrators can get off the ground running. This book helps you develop the ability to think on your feet and move focus in an instant from arcane syntax details to broad, corporate issues. Along the way, you will see how to create your first database and implement best practices to ensure a well-running database system.


What makes Oracle DBA Mentor different is that it also teaches you how to obtain answers that are not found in this or other books. Focus is given to creating a test bed and running test cases to examine hypotheses and prove out solutions so you can be sure they work in production. Attention is given to navigating product documentation and networking in forums and social media to build your skills and a network to draw on when solving problems under pressure. There are chapters of step-by-step technical content as well as coverage of essential skills to succeed as a DBA no matter which database engine you administer.


By the time you are done reading this book, you will have confidence to face many of the situations thrown in your direction. You will know where to go for the answers you don’t yet know that you need. You’ll be able to work and troubleshoot under pressure. You’ll know how to create a database, institute backup and recovery procedures, secure the database and its valuable corporate data, and acquire more knowledge as needed so you can run a database to meet the needs of your organization. 




What You'll Learn
  • Install Oracle Database with best practices
  • Implement backup and recovery procedures
  • Understand the fundamentals of databases and data security
  • Find answers to technical problems using Oracle documentation, Oracle Support, and other resources
  • Patch and upgrade an Oracle database






Who This Book Is For


The novice database administrator who wants help getting off the ground with their DBA career, and in building the skills to let that career flourish in the long term. Mid-level DBAs will also find the book helpful as they try to grow their career to the next level. While the book is geared toward the Oracle platform, database administrators from other platforms can benefit from the soft skills covered in this book.



Authors and Affiliations

  • Fargo, USA

    Brian Peasland

About the author

Brian Peasland is a seasoned Oracle database administrator with well over 20 years working with all Oracle database versions since Oracle 7.1 was released. He is a constant contributor to the My Oracle Support and Oracle Developer communities as well as other forums. Brian has been writing for SearchOracle.com since 2001. He has BS and MS degrees in computer science. Brian is the author of Oracle RAC Performance Tuning

Bibliographic Information

Buy it now

Buying options

eBook USD 49.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 64.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access