Oracle DBA mentor succeeding as an Oracle database administrator
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 practi...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
New York, NY
Apress
2019
|
| Series: | Expert's voice in Oracle
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Includes bibliographical references and index
- Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Initial Setup; Chapter 1: Introduction; Becoming a DBA; Typical Day of the DBA; The Data Guardian; Moving On; Chapter 2: Working As a DBA; The Rude DBA; Multiplatform Work; Typical DBA Answers; Know Your Audience; Moving On; Chapter 3: Creating Our Server; Downloading VirtualBox; Downloading Oracle Linux; Creating the Server; Moving On; Chapter 4: Disk Layouts; Optimal Flexible Architecture; ORACLE_BASE; ORACLE_HOME; Database Administration Files; Diagnostic Files; Database Files
- Playing What-If GamesSample Schemas; Moving On; Part III: Learning Oracle Database; Chapter 11: Tools; Connecting to Our Database; SQL*Plus; SQL Developer; Oracle Enterprise Manager; Showing the SQL; Database Configuration Assistant; Network Configuration Assistant; Other Tools and Utilities; Moving On; Chapter 12: Diagnostics; Diagnostic Destination; Alert Log; Listener Log; Background Process Trace Files; User Trace Files; ADRCI; Moving On; Chapter 13: Oracle Documentation; RTFM; Installing and Upgrading; Administration; 2 Day Guides; Concepts Guide; Administrator's Guide
- Full PictureMoving On; Chapter 5: Installing Oracle; Accessing the Installation Guide; Downloading Oracle Database Software; Getting the Server Ready; Installing Oracle; Moving On; Chapter 6: Creating Our Database; Creating the Database; Starting the Oracle Listener; Issuing Our First Queries; Moving On; Part II: Using Oracle Database; Chapter 7: Recovery and Backup; Recovery Before Backups; Recovery Requirements; Backup and Recovery Documentation; Backup Types; Hot and Cold Backups; RMAN and User-Managed Backups; Logical Backups; Restore and Recovery; Our Cold Backup; Archivelog Mode
- Performance Tuning GuideError Messages; Backup and Recovery; SQL Language Reference; PL/SQL Packages and Types Reference; Bookshelf; Other Books; Moving On; Chapter 14: Data Dictionary; Data Dictionary; Base Tables; Static Dictionary Views; DBA_, ALL_, USER_, and CDB_; DICT; Common DBA Views; Useful Views; Dynamic Performance Views; Common V Views; GV Views; Useful Examples; Moving On; Part IV: Maintaining the Oracle Database; Chapter 15: My Oracle Support; Logging Into My Oracle Support; CSI; Dashboard; Tutorial Videos; Knowledge Base; Service Requests; Patches and Updates; Certifications
- Our Hot BackupMoving On; Chapter 8: Security; Accessing the Security Guide; Default Users; Password Profile; Security Profiles; Auditing; Additional Security Topics; System Privileges; Object Privileges; Roles; Transparent Data Encryption; DBMS_CRYPTO; Virtual Private Database; Network Encryption; Stronger Authentication; Moving On; Chapter 9: Connecting to Oracle; Local Connections; Processes and Bequeath; Oracle Listener; Oracle Client; TNSNAMES; Common TNS Errors; EZ Connect; ODBC; JDBC; Moving On; Chapter 10: Test Cases; Failure; Success; Testbeds; Snapshots; LiveSQL; Test Cases