dba-02-Getting Start.ppt

Getting Started With the Oracle Server Objectives After completing this lesson, you should be able to do the following: Identify common database administration tools available to a DBA Identify the features of the Oracle Universal Installer Understand the benefits of Optimal Flexible Architecture Set up password file authentication List the main components of Oracle Enterprise Manager and their uses Database Administration Tools Tool Description Oracle Universal Installer (OUI) Used to install, upgrade, or remove software components Oracle Database Configuration Assistant A graphical user interface tool that interacts with the OUI, or can be used independently, to create, delete or modify a database Password File Utility Utility for creating a database password file SQL*Plus A utility to access data in an Oracle database Oracle Enterprise Manager A graphical interface used to administer, monitor, and tune one or more databases Oracle Universal Installer Used to install, upgrade, or remove software components, and create a database Based on a Java engine Features include: Automatic dependency resolution Allows for Web-based installations Tracking inventory of component and suite installations Deinstallation of installed components Support for multiple Oracle homes Support for globalization technology Interactive Installation To start Oracle Universal Installer on Unix: $ ./runInstaller Non-Interactive Installation Using Response Files To start Universal Installer in non-interactive mode: ./runInstaller -responsefile myrespfile -silent Oracle Database Configuration Assistant The Oracle Database Configuration Assistant allows you to: Create a database Configure database options Delete a database Manage templates Optimal Flexible Architecture (OFA) Oracles recommended standard database architecture layout OFA involves three major rules Establish a directory structure where any database file can be stored on any disk resource Separate objects with different behavior