1、Installing the Oracle Database SoftwareObjectivesAfter completing this lesson, you should be able to do the following:Describe your role as a database administrator (DBA), and explain typical tasks and toolsPlan an Oracle database installationUse Optimal Flexible ArchitectureInstall the Oracle softw

2、are by usingOracle Universal Installer (OUI)Create a database with OUIHow DBAs Spend Their TimeLoading andarchiving data: 6%Maintainingsoftware: 6%Installing: 6%Creating and configuring: 12%Managing databasesystem: 55% Source: Survey conducted at a recent convention Tasks of an Oracle Database Admin

3、istratorA prioritized approach for designing, implementing, and maintaining an Oracle database involves the following tasks: 1.Evaluating the database server hardware2.Installing the Oracle software3.Planning the database and security strategy4.Creating, migrating, and opening the database5.Backing

4、up the database6.Enrolling system users and planning for their Oracle Network access7.Implementing the database design8.Recovering from database failure9.Monitoring database performanceTools Used to Administer an Oracle DatabaseOracle Universal InstallerDatabase Configuration AssistantDatabase Upgra

5、de AssistantOracle Net ManagerOracle Enterprise ManagerSQL*Plus and iSQL*PlusRecovery Manager Oracle Secure BackupData PumpSQL*LoaderCommand-line toolsFull Notes PagePlanning an Oracle Database Installation1.Understand how the installation fits into the overall technical architecture of an organizat

6、ion.2.Review (and update) capacity plans.3.Choose database software (required version and options).4.Ensure that system requirements are met for all chosen elements.5.Plan configuration parameters to be set before, during, and after the installation.6.Plan security and access.7.Plan backup and recov

7、ery mechanisms.Planning and Executing DBA Projects: QuizAs a DBA:1.You must be able to install and configure many different types of databases.2.You should be aware of upcoming projects.3.You do not need to understand the business requirements for a database.4.You should always compare your planned

8、and actual results.5.You do not need to plan for database recovery, because you have an uninterrupted power supply.6.You do not need to plan for security, because your users are reliable people.True/FalseTrue/FalseTrue/FalseTrue/FalseTrue/FalseTrue/FalseSystem RequirementsMemory requirements:1 GB fo

9、r the instance with Database ControlDisk space requirements:1.5 GB of swap space 400 MB of disk space in the /tmp directoryBetween 1.5 GB and 3.5 GB for the Oracle software1.2 GB for the preconfigured database (optional)2.4 GB for the flash recoveryarea (optional)Operating system: Seedocumentation.C

10、hecking the System RequirementsAdequate temporary space64-bit versus 32-bit issuesChecks for the correct operating system (OS) OS patch levelSystem packagesSystem and kernel parametersX Server permissionsSufficient swappingNonempty ORACLE_HOMEOptimal Flexible Architecture (OFA)OFA is designed to:Org

11、anize large amounts of software Facilitate routine administrative tasks Facilitate switching between multiple Oracle databasesManage and administer database growth adequately Help eliminate fragmentation of free spaceUsing Optimal Flexible ArchitectureNaming mount points:/u01/disk01Naming directorie

12、s:/u01/app/oracle/u01/app/applmgrNaming files:Control files: controln.ctlRedo log files: redon.logData files: tn.dbfUsing Optimal Flexible ArchitectureFull Notes PageSetting Environment VariablesORACLE_BASE: The base of the Oracle directory structure for OFAORACLE_HOME: The directory containing the

13、Oracle softwareORACLE_SID: The initial instance name (ORCL by default)NLS_LANG: The language, territory, and client character set settingsSetting Environment VariablesFull Notes PageOracle Universal Installer (OUI)Installing the Oracle SoftwareDatabase Configuration OptionsConfiguration Assistants P

14、assword ManagementABCCompleting Your InstallationAdvanced Installation OptionsDatabase storage options:File systemAutomatic Storage ManagementRaw devicesDatabase management options:Enterprise Manager Grid ControlEnterprise Manager Database ControlDatabase backup and recovery optionsE-mail notificati

15、on optionsCluster Ready ServicesCloningInstallation Option: Silent ModeTo install and configure Oracle products with OUI in silent mode, perform the following steps:1.Create the oraInst.loc file, if it does not already exist.2.Prepare a response file based on file templates that are delivered with t

16、he Oracle software.3.Record a response file:.runInstaller record -destinationFile 4.Run OUI in silent or suppressed mode.5.If required, run NetCA and DBCA in silent mode.SummaryIn this lesson, you should have learned how to:Describe your role as a DBA, and explain tasks and toolsPlan your installation, starting with the appropriate documentationPerform preinstallation tasks, such as checking system requirementsInstall software by using OUI Create a database with the OUI configuration assistantPractice Overview: In