1、,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 Use SQL*Plus to interact and manipulate an Oracle database
2、 List the main components of Oracle Enterprise Manager,Database Administration Tools,Description,Tool,Used to install, upgrade, or remove software components,Oracle Universal Installer (OUI),A graphical user interface tool that interacts with the OUI, or can be used independently, to create, delete,
3、 or modify a database,Oracle Database Configuration Assistant,A utility to access data in an Oracle database,SQL*Plus,A graphical interface used to administer, monitor, and tune one or more databases,Oracle Enterprise Manager,Oracle Universal Installer,Used to install, upgrade, or remove software co
4、mponents, 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 techno
5、logy,Starting the Universal Installer,To start Oracle Universal Installer on UNIX:To start Oracle Universal Installer on NT:,$ ./runInstaller,Start Programs Oracle Installation Products Universal Installer,Non-Interactive Installation Using Response Files,Allows for no user interaction Response file
6、s: Templates must be edited. Text files contain variables and values. Parameters are customized. To start Universal Installer in non-interactive mode:,./runInstaller -responsefile myrespfile -silent,Oracle Database Configuration Assistant,You use the Oracle Database Configuration Assistant to: Creat
7、e a database Configure database options Delete a database Manage templates,Database Administrator Users,Users SYS and SYSTEM are created automatically During database creation Granted the DBA role User SYS Owner of the database data dictionary Default password: change_on_install User SYSTEM Owner of
8、 additional internal tables and views used by Oracle tools Default password: manager,SQL*Plus,An Oracle tool providing: Capability to interact with and manipulate the database Ability to start up and shut down the database, create and run queries, add rows, modify data, and write customized reports
9、A subset of the standard SQL language with specific add ons Connecting to SQL*Plus:,sqlplus /nologconnect / as sysdba Connected to an idle instance.,Oracle Enterprise Manager,Serves as a centralized systems management tool for DBAs A tool to administer, diagnose, and tune multiple databases A tool t
10、o administer multiple network nodes and services from many locations Use to share tasks with other administrators Provides tools for administering parallel servers and replicated databases,Oracle Enterprise Manager: Architecture,Oracle Management Server,Agent,Agent,Console,Oracle Management Server,R
11、epository,Console,Central launching point Can be run in a thin or fat client Can be launched stand-alone or via an OMS,Summary,In this lesson, you should have learned to: Identify database administration tools Identify the features of the Oracle Universal Installer Use SQL*Plus to interact and manipulate the database Identify the main components of Oracle Enterprise Manager,Practice 2 Overview,This practice covers the following topics: Connecting to SQL*Plus Connecting to Enterprise Manager Console,
