Oracle Database 10g: 2 Day DBA
1 Book on PDF File
Edition 1.0 ( Feb 2004 )
Official Oracle University Curriculum
These set teach you everything you need to know to become an Oracle 10g
Certified Professional. The tests are based directly from the information
from these books
Oracle Database 10g: 2 Day DBA
What you will learn:
The goal of this course is to teach Database Administrators how to install the Oracle Database 10g software and perform the tasks required to manage an Oracle database. Enterprise Manager is used throughout to teach students how to quickly accomplish the required tasks. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 10g. This course is targeted towards Database Administrators of small to medium sized businesses
Course Objectives:
Install Oracle Database software and create a database
Use Enterprise Manager Database Control to manage the database
Configure and manage the Oracle Network environment
Manage database storage structures
Administer users and security
Manage schema objects
Back up and recover the Oracle Database
Monitor the database and use the Advisors
Course Topics:
Overview of Oracle Database Administration
Overview of the Oracle Instance and Database
Tasks of an Oracle Database Administrator
Tools Used to Administer an Oracle Database
Working with Oracle Support
Searching MetaLink
Logging TARs
Installing Oracle Software and Creating the Database
Using the Oracle Universal Installer (OUI)
Installation Pre-requisites
Installing the Oracle Software
Using the Database Configuration Assistant (DBCA) to Create a Database
Using DBCA to Manage Templates
Upgrading the Database Using the Database Upgrade Assistant (DBUA)
Install the Oracle Software Using OUI
Use the DBCA to Create a Database
Using Oracle Enterprise Manager Database Control and SQL*Plus
Overview of Administering the Database Using Enterprise Manager (EM)
Starting the EM Database Console
Enterprise Manager Navigation
Granting EM Administrative Privileges
Start the EM Database Console
Navigate in EM
Grant EM Administrative Privileges to Another User
Configuring the Oracle Network Environment
Network Configuration Overview
Oracle Net Listener Configuration and Management
Oracle Net Naming Methods
Tools for Configuring and Managing the Oracle Network
Using EM to Configure and Manage the Oracle Network
Start and Stop the Listener
Configure Local Naming
Connect to the Database
Managing the Oracle Instance
Oracle Instance and Instance Management
Memory Structures
Background Processes
Accessing the Oracle Database
Initialization Parameters
Password File
Starting Up and Shutting Down the Instance
Viewing the Alert Log and Trace Files
Managing Database Storage Structures
Oracle Database Structures
Control Files
Multiplexing and Archiving the Redo Log Files
Tablespaces and Data Files
Creating a New Tablespace
Managing Undo in the Database
Using the Undo Advisor
Use EM to View the Storage Structure of the Database
Administering Users and Security
Overview of Users and Security
Creating and Administering Users
Locking and Unlocking Accounts
Setting Passwords
Administering Privileges and Roles
Create a New User
Grant Privileges to the User
Lock and Unlock the User Account
Managing Schema Objects
Creating Schema Objects
Create a New Table and View the Attributes and Contents of a Table
Understanding Data Integrity and Defining Constraints
Creating and Viewing Attributes of Indexes
Creating Views
Loading Data
Export and Import
External Tables
Performing Backup and Recovery
Backup, Restore and Recovery Concepts
Configuring the Database for Backup and Recovery and Setting Backup Policies
Configure the ARCHIVELOG Mode and Automatic Archiving
Configure the Flash Recovery Area
Retention Policy
Backing Up the Database Using EM
Oracle-Suggested Backup Strategy
Perform a Whole Database Backup and Recovery
Monitoring and Tuning the Database
Monitoring the Oracle Database
Self-Monitoring Architecture
Automatic Workload Repository
Metrics, Thresholds, and Alerts
Automatic Database Diagnostics Monitor (ADDM)
Monitoring and Tuning Usage Model
Setting Up Notification Rules
Using the Advisors
In total you will receive 1PDF File for the workbook.
Language : English
Format : PDF
Download Size : 4.6MB
Download Time : 5Minutes
Computer Requirements to Open this PDF Files :-
Operating System : Microsoft Windows 95/98/2000/ME/XP Home/XP Professional
Software Required : Adobe Acrobat or Acrobat Viewer ver 5 or above ( Can be downloaded from www.adobe.com )
Please click here for the step by step instruction on downloading and opening the PDF Files