Oracle Database Administration

Duration of       Hours 


Duration time may vary depends on course progress


Oracle Database Administration


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.



Course Content


  •  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

Have some Questions?

Call us at our care or drop quick contact box

Why with us?
  • Live Quality Training 

  • Live demonstration of of features and practicals.

  • 100% Assurance Placement Assistance

  • Effective Resume building

  • Internship Program for real exposure

  • Interview preparation with mock interview drills

  • Process of applying jobs at right places

  • Guidance of getting flexible, part time jobs

  • Facebook - Black Circle


Corporate Office


364 E Main ST STE 1001

Middle Town

DE 19709


+1 720  738 4411

Subscribe with us for regular


© 2023 by KEYZONE IT