Oracle Database Adminstration

Oracle Database Adminstration

Overview:
Database executives (DBAs) utilize specific programming to store and compose information. The job may incorporate scope quantification, establishment, setup, database structure, execution observing, investigating, just as reinforcement and information recuperation. Prophet Database is a multi-model database the board framework delivered and advertised by Prophet Enterprise. Every database requires in any event one database manager (DBA) to control it. Since a Prophet database framework can be huge and can have numerous clients, regularly this is definitely not a one individual occupation. In such cases, there is a gathering of DBAs who share duty.

Training Targets of Prophet DBA
Prophet DBA Preparing is intended for people who might want to become Prophet DBAs. The information is the most significant resource for any association and subsequently this makes the activity of DBA very requesting. Prophet dba Preparing begins with SQL and move to cutting edge SQL, Programming and Database Organization I, and Database Organization II. This course gives the SQL abilities that permit designers, database executives and end-clients to compose inquiries against single and various tables, control information in tables and exploit Prophet provided push capacities.

Target Understudies and Prerequisites:
Understudies must be comfortable with information preparing ideas and methods.

Course Contents:
Introduction
Identify the prophet product
Describe the fundamental idea of a social database

Installing prophet database 10g software
System requirements
Use Prophet Ideal Adaptable Engineering (OFA)
Install programming with the Prophet General Installer

Create a prophet database
Oracle Database Architecture
Oracle example architecture
Use the Database Creation Assistant

Controlling the database
Manually design the Prophet 10g EM dbconsole
Start and stop the agent
Start and stop the endeavor director database console
Start and stop the listener
Startup and shutdown the database

Storage Structures
Defining the table spaces and information files
Create tables paces
Manage table spaces
Obtain table space information
Create and oversee table space utilizing prophet endeavors manager

Administering users
Create and oversee database client accounts
Create and oversee roles
Grant and renounce privileges

Oracle Database Security — Just Theory
Apply the head of least privilege
Manage default client accounts
Implement standard secret word security features

Oracle Net Services
Understand Prophet Net concepts
Use Prophet Net Supervisor to make and design listeners
Use the Prophet Net Supervisor to design customer and center level connection
Use TNSPING to test Prophet Net connectivity

Performance Monitoring
Gather enhancer statistics
View execution metrics

Monitoring and Overseeing Memory
Oracle Memory Structures
Automatic PGA Memory Management
Using the Memory Advisor
Using Programmed Shared Memory The executives to stay away from long running question issues

Monitoring and Settling Lock Conflicts
Detect and resolve lock conflicts
Manage deadlocks

Diagnostic Sources
The Alert Log
Viewing Alarms with EM
Alerts Warning — – Just Theory
Editing Edges — – Just Theory
Trace Files

Proactive Support: Goals — Just Theory
Set cautioning and basic alarm thresholds
Collect and use gauge metrics
Use tuning and symptomatic advisors
Use the Programmed Database Symptomatic Screen (ADDM)

Automatic Stockpiling The executives — - Just Theory
ASM Concepts
ASM General Architecture
Creating an ASM instance
Creating tablespaces that utilization ASM storage
Viewing ASM information
Migrating a tablespace to utilize ASM storage.

Undo The executives — Just Theory
Monitor and regulate undo
Configure fix retention
Guarantee fix retention
Use the fix advisor

Backup and Recuperation — Just Theory
Describe the essentials of database reinforcement, reestablish and recovery
List the sorts of disappointment that may happen in a Prophet Database
Describe approaches to tune occurrence recovery
Identify the significance of checkpoints, re-try log documents, and chronicled log file

Managing Data
Manipulating information through SQL
Using Import
Using Export

Database backups
Configure ARCHIVELOG mode
Create reliable database backups
Back your database up without closing it down
Create gradual backups
Automate database backups
Monitor the glimmer recuperation area

Managing pattern objects
Create and alter tables
Define constraints
View the characteristics of a table
View the substance of a table
Create lists and views

Database Recovery
Recover from loss of a control file
Recover from loss of a re-try log file
Recover from loss of an information file


cours