170 likes | 291 Views
Chapter 1. Installing the Oracle Binaries. Introduction to Managing and Safeguarding Your Organization’s Data. Efficiently installing Oracle software Create a secure and manageable database environment Create and manage users Create and manage database objects
E N D
Chapter 1 Installing the Oracle Binaries
Introduction to Managing and Safeguarding Your Organization’s Data • Efficiently installing Oracle software • Create a secure and manageable database environment • Create and manage users • Create and manage database objects • Understand scalability features • Competently backup database • Posses skills required to restore and recover database • Be proficient at troubleshooting problems
DBA Installation Responsibilities • Understand OFA standard • Install database software • Upgrade database software • Consistency • Efficiency • Troubleshoot issues
Optimal Flexible Architecture Purpose • Consistent directory structures • Consistent naming standards • FRA • Datafiles • Online redo logs • Control files
Optimal Flexible Archicture • Where is the OFA documented? • Oracle inventory directory • Oracle base directory • Oracle home directory • Oracle network files directory • Automatic diagnostic repository
Response File vs. Graphical Installer • Consistency • Network issues • Requirement for X software
Downloadable Oracle Software • Enterprise Edition • Standard Edition • Other editions? • Oracle Technology Network or OTN (http:/otn.oracle.com) • Base version of Oracle • Upgrades and patches to base version require support license and valid CSI number • My Oracle Support or MOS (formerly known as Metalink) (https:/support.oracle.com)
Installing Oracle • Create operating system group and user • Configure the operating system • Download Oracle installation software • Unzip the files • Configure a response file • Run the installer
Installing by Copying Existing Binaries • Copy the binaries • Attach the Oracle home • Why do DBAs install the binaries this way?
Upgrading Oracle Software • MOS note 7303365.1 • Download the upgrade file • Unzip the upgrade file • Configure the response file • Run the installer
Upgrading Oracle Software • Upgrade existing Oracle home versus • Create new Oracle home • Upgrade new Oracle home • Advantage of creating and upgrading new Oracle home is that you can leave the old Oracle home binaries in place in case you need to roll back an upgrade.
Reinstalling after failed installation • Reasons for failed installations • Modify the inventory.xml file • Remove the software that was partially installed • Rerun the installer
Applying Interim Patches • Need for a CSI number • Obtain patch from MOS • Unzip the file • Follow the instructions in the README • Apply the patch
Installing Remotely with the Graphical Installer • Install X • Start an X session • Copy the installation files • Run xhost • Log in to remote server • Set the DISPLAY variable • Run the installer
Summary • Common DBA task is installing, patching, and upgrading Oracle binaries. • Use the OFA standard to provide consistency with naming and directory structures. • DBAs should be familiar with efficient methods for installing Oracle software. • Silent installations provide a consistent and efficient mechanism for installing Oracle binaries.