SUMMARY

SEARCH

Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.

BOOK PRACTICAL ORACLE DATABASE APPLIANCE

SUMMARY

191

Foreword
Chapter 1: Oracle Database Appliance 1
Why an Appliance? 1
The Appliance Hardware 3
Oracle Database Appliance V1 3
Oracle Database Appliance X3-2 8
Summary 12
Chapter 2: Integrated Lights Out Management 13
Introduction to ILOM 13
ILOM Features 15
Remote KVMS Service 15
Integrated Shell 17
Security Management 19
Local Account Management 19
Alerting and Syslog Setup 20
Oracle Database Appliance and the ILOM 23
Oracle Database Appliance Setup via Serial Connection 23
Bare-Metal Oracle Database Appliance 27
Summary 30
vi
Chapter 3: Installation 31
Network and Power Connections 31
Original ODA 31
ODA X3-2 33
Power Cables 34
Oracle Database Appliance Initial Deployment 35
ILOM Network 35
Network Information 35
Real Application Cluster (RAC) Network 36
Network Configuration 37
Network Time Protocol (NTP) Configuration 39
Grid Infrastructure and Database Installation 40
Database Installation 41
VNC Configuration and Connection 41
Oracle Appliance Manager and Deployment 43
Oracle Database Appliance Redeploy 51
Preparing for a ZFS Array As External Storage 53
Summary 54
Chapter 4: Database Configuration 55
The oakcli Command 55
Command Options 55
Executing the Command 56
Database Configuration Types 57
Real Application Cluster 57
Real Application Cluster One 61
Single Instance (EE Option) 62
Database Deletion 63
Database Configuration Assistant 64
Creating a Database 65
Deleting a Database 75
vii
Automatic Storage Management (ASM) 76
Automatic Storage Management Configuration Assistant 77
Automatic Storage Management Command Line 79
Summary 79
Chapter 5: Networking 81
ODA Models 81
Oracle Database Appliance V1 81
Oracle Database Appliance X3-2 83
ODA Network Deployment Process 84
Plan the ODA Networks to Be Deployed 84
Define Network Security Considerations 85
Complete Work That Can Be Accomplished Before the ODA Arrives 85
Spec and Order the ODA Network Cabling 86
Request IP Addresses 86
Build the Offline Configuration File 87
Rack the ODA 91
Cable the ODA 92
Apply the ILOM IP Addresses and Configure the ODA Public Network 93
Configure the Remaining Networks 95
Post Deployment Options for Making Network Changes 95
Virtualization Considerations 96
Summary 97
Chapter 6: Monitoring the Oracle Database Appliance 99
Configuring Database Control 99
Using the Enterprise Manager Configuration Assistant (EMCA) 100
Using a Parameter File 102
Controlling Database Control 103
Status of Database Control 103
Stopping Database Control 103
Start Database Control 104
Reconfiguring the Database Console 105
Deconfiguring Database Control 107
Supporting Oracle Enterprise Manager 108
Summary 113
Chapter 7: Diagnosing the Oracle Database Appliance 115
Proactive Diagnostics 115
Validation 115
Automatic Service Requests 126
ODA Configuration Audit Tool 129
Trace File Analyzer 132
Miscellaneous Tools 137
Reactive Checks 139
Diagnostic Collection 139
Disk Failures 140
Summary 140
Chapter 8: Patching the Oracle Database Appliance 141
Introduction to Patching 141
Conventional Systems Limitations 141
Oracle Database Appliance Benefits 142
Patching Flow 143
General Patching Flow 143
Specific ODA Steps 144
Timing 145
How Often to Patch 145
How Long It Takes to Patch 146
ODA Patching Options 146
New Appliances 146
Default Patching Option 147
Steps Separated in Time 147
Delayed RDBMS Update 147
ix
Data Guard to Minimize Downtime 148
Virtual Oracle Database Appliance 149
Preparation 149
Verify the Release Level 150
Review the Patch Notes 150
Download the Patch Bundle Set 151
Unpack the Patch Bundle Set 151
Browse the Updates Repository 152
Verify Target Versions 154
Patch Execution 154
Upgrade Log Files 155
Upgrade System Infrastructure 155
Upgrade Grid Infrastructure 156
Database Upgrade 156
Upgrading All Databases 156
Upgrading One by One 157
Summary 158
Chapter 9: Business Values for the ODA 159
Business Challenges 159
Enter the ODA 160
Fast, Simple Database Infrastructure Deployments 161
RAC Without Tears 162
High Availability Without Tears 164
Costs and Value Proposition 164
Oracle Hardware 166
Security and Compliance 166
Virtualization 168
ODA Technical Solutions 168
ODA Performance 170
Summary 171
x
Chapter 10: Virtualization and the ODA 173
Oracle Virtual Machine (OVM) 173
OVM and the Database Appliance 173
Installation of a Virtualized ODA 174
Deployment of the Virtualized ODA 177
Summary 188
Chapter 11: e-Business Suite and the ODA 189
Is ODA a Good Fit? 189
e-Business Suite System Architecture on ODA 190
Configuring the ODA for e-Business Suite 191
Deploying e-Business Suite on ODA 191
Plan for Your Unique Environment 192
Configure the Local File System on the Database Server 194
Create a Virtual Machine for the Application Tier 196
Use ACFS for the Application Tier Files 198
Configure the Virtual IP for the Application Tier 199
Installing the e-Business Suite 200
The Database Tier Installation 200
The Application Tier Installation 203
Finalizing the Configuration 205
Create a New 11.2 Oracle Home 205
Configure the New Oracle Home 207
Migrate to ASM and RAC 210
Clone the Application Tier VM 216
Configure the Second Application Tier Node 219
Revert the Temporary Configuration 221
Post-Installation Tasks 223
Additional Configuration 223
Backups and Monitoring 223
Summary 224
xi
Chapter 12: Oracle Enterprise Manager and the ODA 225
Architecture Overview 225
The Cloud Control Console 226
Oracle Management Agents 226
Oracle Management Service 227
Oracle Management Repository 227
Plug-ins 228
Agent Installation 228
Adding the Hosts 228
Running the root.sh Script 231
Discovering Targets 234
Summary 240
Index 241
Foreword
How did the Oracle Database Appliance (ODA) come into being? That’s a good question, and I’d like to share some of
the history, motivation, and thought-process behind the appliance’s creation.