Common Oracle DBA Tasks

1)      Installing Oracle Software

2)      Creating Oracle database

3)      Performing upgrades of the database and software to new release levels

4)      starting and shutting down database instances

5)      Managing the storage structure of the databases

6)      Managing users and security

7)      Managing database objects such as tables,indexes and views

8)      Backing up the database and performing recovery operation when necessary

9)      Monitoring the state of the database and performing the recovery operation when necessary

10)   Monitoring and tuning database performance

11)   Diagnosing and reporting critical errors to oracle support services

Tools for Administering the database

1)      OUI :-- Oracle Universal Installer .. Install Oracle software and options .

2)      DBCA :-- Database Configuration Assistant .. For creating database , Managing Instance

3)      DBUA :-- Database Upgarde Assistant .. Guides you to install database from exisiting version to new version

4)      NETCA :-- Network Configuration Assistant ..enables to configures listeners and naming methods

5)      Oracle Enterprise Manager Database Control :-- Web Based Oracle Database Management Tool