Practical Oracle Database Appliance (eBook)

Bobby Curtis is an Oracle ACE, Senior Technical Consultant, and member of various Oracle User Groups. He specializes in creating, managing, and tuning enterprise databases. His specialties include Exadata, GoldenGate replication, and he is known for his work in Oracle Enterprise Manager 12c. Bubby's blog, http://dbasolved.com, and twitter handle, DBASolved, are respected as sources of information on solving complex issues related to Oracle products. He is either a lead author or co-author on various technical books, has published various technical articles in user group publications, and he's presented at conferences including Oracle Open World, Collaborate, and ODTUG KScope. Bobby currently lives near Atlanta, Georgia with his wife and three kids.

Contents at a Glance 3
Contents 249
Foreword 256
About the Authors 257
About the Technical Reviewer 259
Acknowledgments 260
Chapter 1: Oracle Database Appliance 6
Why an Appliance? 6
The Appliance Hardware 8
Oracle Database Appliance V1 8
Oracle Database Appliance X3-2 13
Summary 17
Chapter 2: Integrated Lights Out Management 18
Introduction to ILOM 18
ILOM Features 20
Remote KVMS Service 20
Integrated Shell 22
Security Management 24
Local Account Management 24
Alerting and Syslog Setup 25
Oracle Database Appliance and the ILOM 28
Oracle Database Appliance Setup via Serial Connection 28
Bare-Metal Oracle Database Appliance 32
Summary 35
Chapter 3: Installation 36
Network and Power Connections 36
Original ODA 36
ODA X3-2 38
Power Cables 39
Oracle Database Appliance Initial Deployment 40
ILOM Network 40
Network Information 40
Real Application Cluster (RAC) Network 41
Network Configuration 42
Network Time Protocol (NTP) Configuration 44
Grid Infrastructure and Database Installation 45
Database Installation 46
VNC Configuration and Connection 46
Oracle Appliance Manager and Deployment 48
Oracle Database Appliance Redeploy 56
Preparing for a ZFS Array As External Storage 58
Summary 59
Chapter 4: Database Configuration 60
The oakcli Command 60
Command Options 60
Executing the Command 61
Database Configuration Types 62
Real Application Cluster 62
Real Application Cluster One 66
Single Instance (EE Option) 67
Database Deletion 68
Database Configuration Assistant 69
Creating a Database 70
Deleting a Database 80
Automatic Storage Management (ASM) 81
Automatic Storage Management Configuration Assistant 82
Automatic Storage Management Command Line 84
Summary 84
Chapter 5: Networking 85
ODA Models 85
Oracle Database Appliance V1 85
Oracle Database Appliance X3-2 87
ODA Network Deployment Process 88
Plan the ODA Networks to Be Deployed 88
Define Network Security Considerations 89
Complete Work That Can Be Accomplished Before the ODA Arrives 89
Spec and Order the ODA Network Cabling 90
Request IP Addresses 90
Build the Offline Configuration File 91
Rack the ODA 95
Cable the ODA 96
Apply the ILOM IP Addresses and Configure the ODA Public Network 97
Configure the Remaining Networks 99
Post Deployment Options for Making Network Changes 99
Virtualization Considerations 100
Summary 101
Chapter 6: Monitoring the Oracle Database Appliance 102
Configuring Database Control 102
Using the Enterprise Manager Configuration Assistant (EMCA) 103
Using a Parameter File 105
Controlling Database Control 106
Status of Database Control 106
Stopping Database Control 106
Start Database Control 107
Reconfiguring the Database Console 108
Deconfiguring Database Control 110
Supporting Oracle Enterprise Manager 111
Summary 116
Chapter 7: Diagnosing the Oracle Database Appliance 117
Proactive Diagnostics 117
Validation 117
System Component Checks 119
OS Disk Storage 123
Shared Storage 124
Network Components 125
Disk Calibration 127
Automatic Service Requests 128
ODA Configuration Audit Tool 131
Trace File Analyzer 134
Miscellaneous Tools 139
Reactive Checks 141
Diagnostic Collection 141
Disk Failures 142
Summary 142
Chapter 8: Patching the Oracle Database Appliance 143
Introduction to Patching 143
Conventional Systems Limitations 143
Oracle Database Appliance Benefits 144
Patching Flow 145
General Patching Flow 145
Specific ODA Steps 146
Timing 147
How Often to Patch 147
How Long It Takes to Patch 148
ODA Patching Options 148
New Appliances 148
Default Patching Option 149
Steps Separated in Time 149
Delayed RDBMS Update 149
Data Guard to Minimize Downtime 150
Virtual Oracle Database Appliance 151
Preparation 151
Verify the Release Level 152
Review the Patch Notes 152
Download the Patch Bundle Set 153
Unpack the Patch Bundle Set 153
Browse the Updates Repository 154
Verify Target Versions 156
Patch Execution 156
Upgrade Log Files 157
Upgrade System Infrastructure 157
Upgrade Grid Infrastructure 158
Database Upgrade 158
Upgrading All Databases 158
Upgrading One by One 159
Summary 160
Chapter 9: Business Values for the ODA 161
Business Challenges 161
Enter the ODA 162
Fast, Simple Database Infrastructure Deployments 163
RAC Without Tears 164
High Availability Without Tears 166
Costs and Value Proposition 166
Oracle Hardware 168
Security and Compliance 168
Virtualization 170
ODA Technical Solutions 170
ODA Performance 172
Summary 173
Chapter 10: Virtualization and the ODA 174
Oracle Virtual Machine (OVM) 174
OVM and the Database Appliance 174
Installation of a Virtualized ODA 175
Preparation for Virtualization 175
Virtualization Deployment Considerations 176
Deployment of the Virtualized ODA 178
Deployment of ODA_BASE 182
Deployment of a User VM 184
Virtual Image Repository 184
User VM Creation 185
Advanced VM Configuration and Patching 187
CPU Pools 187
Virtual LANs 188
Patching a Virtualized ODA 189
Summary 189
Chapter 11: e-Business Suite and the ODA 190
Is ODA a Good Fit? 190
e-Business Suite System Architecture on ODA 191
Configuring the ODA for e-Business Suite 192
Deploying e-Business Suite on ODA 192
Plan for Your Unique Environment 193
Configure the Local File System on the Database Server 195
Create a Virtual Machine for the Application Tier 197
Use ACFS for the Application Tier Files 199
Configure the Virtual IP for the Application Tier 200
Installing the e-Business Suite 201
The Database Tier Installation 201
The Application Tier Installation 204
Finalizing the Configuration 206
Create a New 11.2 Oracle Home 206
Configure the New Oracle Home 208
Migrate to ASM and RAC 211
Clone the Application Tier VM 217
Configure the Second Application Tier Node 220
Revert the Temporary Configuration 222
Post-Installation Tasks 224
Additional Configuration 224
Backups and Monitoring 224
Summary 225
Chapter 12: Oracle Enterprise Manager and the ODA 226
Architecture Overview 226
The Cloud Control Console 227
Oracle Management Agents 227
Oracle Management Service 228
Oracle Management Repository 228
Plug-ins 229
Agent Installation 229
Adding the Hosts 229
Running the root.sh Script 232
Discovering Targets 235
Summary 241
Index 242