Curtis / Velikanov / Benner Practical Oracle Database Appliance

1. Auflage 2014
ISBN: 978-1-4302-6266-4
Verlag: APRESS
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 260 Seiten, eBook

Practical Oracle Database Appliance is a hands-on book taking you through the components and implementation of the Oracle Database Appliance. Learn about architecture, installation, configuration, and reconfiguration. Install and configure the Oracle Database Appliance with confidence. Make the right choices between the various configurations in order to realize your performance requirements. Manage and monitor the appliance to meet business requirements. Protect your data through proper backup and recovery procedures. Oracle Database is one of the most relied-up databases in industry. For many years Oracle Database was a software product that had to be installed and configured at no small expense. The Oracle Database Appliance makes Oracle Database into a plug-and-play proposition: Plug the appliance into the wall socket, and turn it on. That's it. You have a running database server. This book takes you through that beginning point and beyond, helping you to realize in your own organization the ease of deployment and management represented by the appliance. Covers the Oracle Database Appliance from architecture through configuration. Provides a technical resource for system- and database administrators. Examines practical use cases for the Oracle Database Appliance.

Zielgruppe

Popular/general

Autoren/Hrsg.

Curtis, Bobby

Velikanov, Yury

Benner, Erik

Elsins, Maris

Arshad, Fuad

Sharman, Pete

Gallagher, Matt

Inhaltsverzeichnis

1;Contents at a Glance;3
2;Contents;249
3;Foreword;256
4;About the Authors;257
5;About the Technical Reviewer;259
6;Acknowledgments;260
7;Chapter 1: Oracle Database Appliance;6
7.1;Why an Appliance?;6
7.2;The Appliance Hardware;8
7.2.1;Oracle Database Appliance V1;8
7.2.2;Oracle Database Appliance X3-2;13
7.3;Summary;17
8;Chapter 2: Integrated Lights Out Management;18
8.1;Introduction to ILOM;18
8.2;ILOM Features;20
8.2.1;Remote KVMS Service;20
8.2.2;Integrated Shell;22
8.2.3;Security Management;24
8.2.4;Local Account Management;24
8.2.5;Alerting and Syslog Setup;25
8.3;Oracle Database Appliance and the ILOM;28
8.3.1;Oracle Database Appliance Setup via Serial Connection;28
8.3.2;Bare-Metal Oracle Database Appliance;32
8.4;Summary;35
9;Chapter 3: Installation;36
9.1;Network and Power Connections;36
9.1.1;Original ODA;36
9.1.2;ODA X3-2;38
9.1.3;Power Cables;39
9.2;Oracle Database Appliance Initial Deployment;40
9.2.1;ILOM Network;40
9.2.2;Network Information;40
9.2.3;Real Application Cluster (RAC) Network;41
9.2.4;Network Configuration;42
9.2.5;Network Time Protocol (NTP) Configuration;44
9.2.6;Grid Infrastructure and Database Installation;45
9.3;Database Installation;46
9.3.1;VNC Configuration and Connection;46
9.3.2;Oracle Appliance Manager and Deployment;48
9.3.3;Oracle Database Appliance Redeploy;56
9.3.4;Preparing for a ZFS Array As External Storage;58
9.4;Summary;59
10;Chapter 4: Database Configuration;60
10.1;The oakcli Command;60
10.1.1;Command Options;60
10.1.2;Executing the Command;61
10.2;Database Configuration Types;62
10.2.1;Real Application Cluster;62
10.2.2;Real Application Cluster One;66
10.2.3;Single Instance (EE Option);67
10.3;Database Deletion;68
10.4;Database Configuration Assistant;69
10.4.1;Creating a Database;70
10.4.2;Deleting a Database;80
10.5;Automatic Storage Management (ASM);81
10.5.1;Automatic Storage Management Configuration Assistant;82
10.5.2;Automatic Storage Management Command Line;84
10.6;Summary;84
11;Chapter 5: Networking;85
11.1;ODA Models;85
11.1.1;Oracle Database Appliance V1;85
11.1.2;Oracle Database Appliance X3-2;87
11.2;ODA Network Deployment Process;88
11.2.1;Plan the ODA Networks to Be Deployed;88
11.2.2;Define Network Security Considerations;89
11.2.3;Complete Work That Can Be Accomplished Before the ODA Arrives;89
11.2.4;Spec and Order the ODA Network Cabling;90
11.2.5;Request IP Addresses;90
11.2.6;Build the Offline Configuration File;91
11.2.7;Rack the ODA;95
11.2.8;Cable the ODA;96
11.2.9;Apply the ILOM IP Addresses and Configure the ODA Public Network;97
11.2.10;Configure the Remaining Networks;99
11.3;Post Deployment Options for Making Network Changes;99
11.4;Virtualization Considerations;100
11.5;Summary;101
12;Chapter 6: Monitoring the Oracle Database Appliance;102
12.1;Configuring Database Control;102
12.1.1;Using the Enterprise Manager Configuration Assistant (EMCA);103
12.1.2;Using a Parameter File;105
12.2;Controlling Database Control;106
12.2.1;Status of Database Control;106
12.2.2;Stopping Database Control;106
12.2.3;Start Database Control;107
12.3;Reconfiguring the Database Console;108
12.4;Deconfiguring Database Control;110
12.5;Supporting Oracle Enterprise Manager;111
12.6;Summary;116
13;Chapter 7: Diagnosing the Oracle Database Appliance;117
13.1;Proactive Diagnostics;117
13.1.1;Validation;117
13.1.1.1;System Component Checks;119
13.1.1.2;OS Disk Storage;123
13.1.1.3;Shared Storage;124
13.1.1.4;Network Components;125
13.1.1.5;Disk Calibration;127
13.1.2;Automatic Service Requests;128
13.1.3;ODA Configuration Audit Tool;131
13.1.4;Trace File Analyzer;134
13.1.5;Miscellaneous Tools;139
13.2;Reactive Checks;141
13.2.1;Diagnostic Collection;141
13.2.2;Disk Failures;142
13.3;Summary;142
14;Chapter 8: Patching the Oracle Database Appliance;143
14.1;Introduction to Patching;143
14.1.1;Conventional Systems Limitations;143
14.1.2;Oracle Database Appliance Benefits;144
14.2;Patching Flow;145
14.2.1;General Patching Flow;145
14.2.2;Specific ODA Steps;146
14.3;Timing;147
14.3.1;How Often to Patch;147
14.3.2;How Long It Takes to Patch;148
14.4;ODA Patching Options;148
14.4.1;New Appliances;148
14.4.2;Default Patching Option;149
14.4.3;Steps Separated in Time;149
14.4.4;Delayed RDBMS Update;149
14.4.5;Data Guard to Minimize Downtime;150
14.4.6;Virtual Oracle Database Appliance;151
14.5;Preparation;151
14.5.1;Verify the Release Level;152
14.5.2;Review the Patch Notes;152
14.5.3;Download the Patch Bundle Set;153
14.5.4;Unpack the Patch Bundle Set;153
14.5.5;Browse the Updates Repository;154
14.5.6;Verify Target Versions;156
14.6;Patch Execution;156
14.6.1;Upgrade Log Files;157
14.6.2;Upgrade System Infrastructure;157
14.6.3;Upgrade Grid Infrastructure;158
14.7;Database Upgrade;158
14.7.1;Upgrading All Databases;158
14.7.2;Upgrading One by One;159
14.8;Summary;160
15;Chapter 9: Business Values for the ODA;161
15.1;Business Challenges;161
15.2;Enter the ODA;162
15.3;Fast, Simple Database Infrastructure Deployments;163
15.4;RAC Without Tears;164
15.5;High Availability Without Tears;166
15.6;Costs and Value Proposition;166
15.7;Oracle Hardware;168
15.8;Security and Compliance;168
15.9;Virtualization;170
15.10;ODA Technical Solutions;170
15.11;ODA Performance;172
15.12;Summary;173
16;Chapter 10: Virtualization and the ODA;174
16.1;Oracle Virtual Machine (OVM);174
16.2;OVM and the Database Appliance;174
16.3;Installation of a Virtualized ODA;175
16.3.1;Preparation for Virtualization;175
16.3.2;Virtualization Deployment Considerations;176
16.4;Deployment of the Virtualized ODA;178
16.4.1;Deployment of ODA_BASE;182
16.4.2;Deployment of a User VM;184
16.4.2.1;Virtual Image Repository;184
16.4.3;User VM Creation;185
16.4.4;Advanced VM Configuration and Patching;187
16.4.4.1;CPU Pools;187
16.4.4.2;Virtual LANs;188
16.4.4.3;Patching a Virtualized ODA;189
16.5;Summary;189
17;Chapter 11: e-Business Suite and the ODA;190
17.1;Is ODA a Good Fit?;190
17.2;e-Business Suite System Architecture on ODA;191
17.3;Configuring the ODA for e-Business Suite;192
17.3.1;Deploying e-Business Suite on ODA;192
17.3.2;Plan for Your Unique Environment;193
17.3.3;Configure the Local File System on the Database Server;195
17.3.4;Create a Virtual Machine for the Application Tier;197
17.3.5;Use ACFS for the Application Tier Files;199
17.3.6;Configure the Virtual IP for the Application Tier;200
17.4;Installing the e-Business Suite;201
17.4.1;The Database Tier Installation;201
17.4.2;The Application Tier Installation;204
17.5;Finalizing the Configuration;206
17.5.1;Create a New 11.2 Oracle Home;206
17.5.2;Configure the New Oracle Home;208
17.5.3;Migrate to ASM and RAC;211
17.5.4;Clone the Application Tier VM;217
17.5.5;Configure the Second Application Tier Node;220
17.5.6;Revert the Temporary Configuration;222
17.6;Post-Installation Tasks;224
17.6.1;Additional Configuration;224
17.6.2;Backups and Monitoring;224
17.7;Summary;225
18;Chapter 12: Oracle Enterprise Manager and the ODA;226
18.1;Architecture Overview;226
18.1.1;The Cloud Control Console;227
18.1.2;Oracle Management Agents;227
18.1.3;Oracle Management Service;228
18.1.4;Oracle Management Repository;228
18.1.5;Plug-ins;229
18.2;Agent Installation;229
18.2.1;Adding the Hosts;229
18.2.2;Running the root.sh Script;232
18.2.3;Discovering Targets;235
18.3;Summary;241
19;Index;242

Über Autor(innen)

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.