oracle dba ppt | oracle dba overview | dba tutorials | oracle dba online training

1
ORACLE DBA OVERVIEW

SRY IT SOLUTIONS www.sryitsolutions.com USA
1-319-804-4998 INDIA 91-9948030675 Email
id info_at_sryitsolutions.com
2
Introduction

•   Identify the Oracle product
• Describe the basic concept of a relational
  database

3
Installing Oracle Database 10G Software

•   System requirements
•   Use Oracle Optimal Flexible Architecture (OFA)
•   Install software with the Oracle Universal
  Installer

4
Create an Oracle Database

• Oracle Database Architecture
•  Oracle instance architecture
• Use the Database Creation Assistant

5
Controlling the Database

• Manually configure the Oracle 10g EM dbconsole
• Start and stop the agent
• Start and stop the enterprise manager database
  console
• Start and stop the listener
• Startup and shutdown the database

6
Storage structures

• Defining the table spaces and data files
•  Create table spaces
•  Manage table spaces
•  Obtain table space information
•  Create and manage table space using oracle
  enterprises manager

7
Administering Users

• Create and manage database user accounts
•  Create and manage roles
•  Grant and revoke privileges

8
Oracle Net Services

•  Understand Oracle Net concepts
•  Use Oracle Net Manager to create and configure
  listeners
•  Use the Oracle Net Manager to configure client
  and middle-tier connection
•  Use TNSPING to test Oracle Net connectivity

9
Monitoring and Managing Memory

• Oracle Memory Structures
• Automatic PGA Memory Management
• Using the Memory Advisor
• Using Automatic Shared Memory Management to
  avoid long running query issues

10
Managing Data

•  Manipulating data through SQL
•  Using Import
•  Using Export

11
Database Backups

•   Configure ARCHIVELOG mode
•   Create consistent database backups
•   Back your database up without shutting it
  down
•   Create incremental backups
•   Automate database backups
•   Monitor the flash recovery area

12
Managing Schema Objects

• Create and modify tables
•   Define constraints
•   View the attributes of a table
•   View the contents of a table
•   Create indexes and views

13
Database Recovery

• Recover from loss of a control file
•   Recover from loss of a redo log file
•   Recover from loss of a data

14
Offered Other Modules

• SAP Sap bpc, basis, abap, bo, admin, fico, mdm,
  crm, hana, fscm, is utilities, bo data services,
  apoetc.
• ORACLE Dba, oaf, adf, obiee, plsql, apps dba,
  apps technical, apps financial etc.
• DWH Ab initio, ajax, informatica, data stage,
  handoop, websphereand more

15
Contact Us

• SRY IT SOLUTIONS
• USA 1-319-804-4998 INDIA91-9948030675
  Email info_at_sryitsolutions.com
• www.sryitsolutions.com

16
THANK YOU