DBAI_les02_Rev1_1

Views:
 
Category: Education
     
 

Presentation Description

No description available.

Comments

By: 9841665062 (108 month(s) ago)

can i download it

By: roselover_786 (108 month(s) ago)

yeah sure, if you are unable to download, you can send me request at skype, i can forward you direct copy. :)

By: 9841665062 (108 month(s) ago)

can i download it

Presentation Transcript

Getting Started with the Oracle Server : 

Getting Started with the Oracle Server

Objectives : 

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 List the main components of Oracle Enterprise Manager

Database Administration Tools : 

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, 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 : 

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

Starting the Universal Installer : 

Starting the Universal Installer To start Oracle Universal Installer on UNIX: To start Oracle Universal Installer on NT: $ ./runInstaller D:\> setup

Non-Interactive Installation Using Response Files : 

Non-Interactive Installation Using Response Files Allows for no user interaction Response files: Templates that must be edited Text files containing variables and values Parameters are customized To start Universal Installer in non-interactive mode: ./runInstaller -responsefile myrespfile -silent

Oracle Database Configuration Assistant : 

Oracle Database Configuration Assistant The Oracle Database Configuration Assistant allows you to: Create a database Configure database options Delete a database Manage templates

Database Administrator Users : 

Database Administrator Users Users SYS and SYSTEM are created automatically During database creation Granted the DBA role SYS Password: change_on_install Owner of the database data dictionary SYSTEM Password: manager Owner of additional internal tables and views used by Oracle tools

SQL*Plus : 

SQL*Plus An Oracle tool providing: Capability to interact with and manipulate the database Ability to start up and shutdown the database, create and run queries, add rows, modify data, and write customized reports Subset of the standard SQL language with specific add ons Connecting to SQL*Plus sqlplus /nolog connect / as sysdba Connected to an idle instance.

Oracle Enterprise Manager : 

Oracle Enterprise Manager Serves as a centralized systems management for DBAs A tool to administer, diagnose, and tune multiple databases A tool to 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 Enterprise Manager - Architecture Oracle Management Server Agent Agent Console Oracle Management Server Agent Repository

Console : 

Console Central launching point Can be run in thin or fat client Can be launched standalone or via an OMS

Summary : 

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 : 

Practice 2 Overview This practice covers the following topics: Connecting to SQL*Plus Connecting to Enterprise Manager Console

authorStream Live Help