Sumário Itens Encontrados: 213Part I: Initial Setup 1Chapter 1: Introduction 3Becoming a DBA 5Typical Day of the DBA 7The Data Guardian 9Moving On 11Chapter 2: Working As a DBA 13The Rude DBA 13Multiplatform Work 15Typical DBA Answers 19Know Your Audience 20Moving On 22Chapter 3: Creating Our Server 23Downloading VirtualBox 24Downloading Oracle Linux 25Creating the Server 28Moving On 41Chapter 4: Disk Layouts 43Optimal Flexible Architecture 44ORACLE_BASE 44ORACLE_HOME 45Database Administration Files 47Diagnostic Files 47Database Files 48Full Picture 50Moving On 51Chapter 5: Installing Oracle 53Accessing the Installation Guide 53Downloading Oracle Database Software 56Getting the Server Ready 57Installing Oracle 61Moving On 69Chapter 6: Creating Our Database 71Creating the Database 71Starting the Oracle Listener 83Issuing Our First Queries 84Moving On 87Part II: Using Oracle Database 89Chapter 7: Recovery and Backup 91Recovery Before Backups 91Recovery Requirements 92Backup and Recovery Documentation 96Backup Types 97Hot and Cold Backups 97RMAN and User-Managed Backups 98Logical Backups 99Restore and Recovery 101Our Cold Backup 101Archivelog Mode 105Our Hot Backup 109Moving On 114Chapter 8: Security 115Accessing the Security Guide 115Default Users 116Password Profile 117Security Profiles 120Auditing 125Additional Security Topics 127System Privileges 128Object Privileges 128Roles 128Transparent Data Encryption 128DBMS_CRYPTO 129Virtual Private Database 129Network Encryption 130Stronger Authentication 130Moving On 130Chapter 9: Connecting to Oracle 131Local Connections 131Processes and Bequeath 134Oracle Listener 137Oracle Client 141TNSNAMES 142Common TNS Errors 145EZ Connect 147ODBC 148JDBC 153Moving On 154Chapter 10: Test Cases 155Failure 155Success 156Testbeds 158Snapshots 159LiveSQL 163Test Cases 165Playing What-If Games 170Sample Schemas 172Moving On 173Part III: Learning Oracle Database 175Chapter 11: Tools 177Connecting to Our Database 177SQL*Plus 182SQL Developer 186Oracle Enterprise Manager 190Showing the SQL 192Database Configuration Assistant 195Network Configuration Assistant 197Other Tools and Utilities 198Moving On 200Chapter 12: Diagnostics 201Diagnostic Destination 201Alert Log 203Listener Log 211Background Process Trace Files 213User Trace Files 214ADRCI 219Moving On 220Chapter 13: Oracle Documentation 221RTFM 222Installing and Upgrading 228Administration 2292 Day Guides 230Concepts Guide 231Administratorâs Guide 232Performance Tuning Guide 233Error Messages 234Backup and Recovery 235SQL Language Reference 236PL/SQL Packages and Types Reference 236Bookshelf 237Other Books 239Moving On 240Chapter 14: Data Dictionary 243Data Dictionary 243Base Tables 244Static Dictionary Views 249DBA_, ALL_, USER_, and CDB_ 249DICT 251Common DBA Views 253Useful Views 254Dynamic Performance Views 255Common V$ Views 256GV$ Views 257Useful Examples 257Moving On 263Part IV: Maintaining the Oracle Database 265Chapter 15: My Oracle Support 267Logging Into My Oracle Support 267CSI 268Dashboard 270Tutorial Videos 271Knowledge Base 272Service Requests 275Patches and Updates 279Certifications 280Relative Time 282Moving On 284Chapter 16: Social Media 285Social Media Definition 286Search Engines 287Blogs 289Twitter 292Ask TOM 294Discussion Forums 295YouTube 298Conferences and User Groups 299Moving On 300Chapter 17: Patching 303Patching Overview 303Oracle Versions 305OPatch 308Quarterly Patches 310Installing the PSU 317Moving On 324Chapter 18: Upgrades 325Reasons to Upgrade 325Upgrade and New Features Guides 328Upgrade Methodology 329Upgrade Methods 332Database Upgrade Assistant 333Manual Upgrade 334Export/Import 334Which to Choose? 335Installing 18c 336Pre-Upgrade Information Tool 340Upgrading the Database 347Post Upgrade 355Downgrading 360Moving On 362Chapter 19: Capacity Planning 363The Complexity 363Capacity Planning 365Enterprise Manager 367Data Dictionary 376The Tough Questions 378Moving On 380Part V: Appendixes 381Chapter 20: Oracle Architecture 383Database vs Instance 384File Types 386Memory Structures 388PGA 388SGA 390Background Processes 395Mandatory Processes 396Optional Background Processes 398User Processes 398Putting It Together 399Interactive Quick Reference 402Instance Startup 406Moving On 408Chapter 21: Advanced Options 409Diagnostics Pack 410Tuning Pack 420Partitioning 424Real Application Clusters 428Multitenant 429Data Guard 431Enterprise Manager 434Advanced Compression 438Real Application Testing 438Moving On 439Index 441