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