Oracle Database 11g Release 2: Database Creation and Instance Management


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
As an Oracle Database administrator, it is important to plan the database to ensure that the database software is installed properly. Planning involves the logical storage structure, the overall design, and a backup strategy. It is also important to manage the database instance after the installation to ensure that it runs properly, and is started and shut down correctly to avoid problems. This course describes the DBA tasks to plan a database installation and how to use the Database Configuration Assistant (DBCA) to install the Oracle Database 11g software. It demonstrates how to manage the instance, including setting initialization parameters, accessing the database and Enterprise Manager, viewing information about the instance, startup and shutdown stages, and viewing the alert log to ensure that there are no issues with the instance. This course also demonstrates how to use Oracle Restart to manage components. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g Release 2: Database Creation and Instance Management

  • plan a database
  • choose the character set for the database
  • configure a database using the DBCA
  • access a database instance using various Oracle tools
  • recognize the scope and capabilities of database initialization parameters
  • modify database initialization parameters
  • configure database startup and shutdown options
  • assess database performance and metadata information
  • use Oracle Restart to manage components
  • create a new database
  • stop and start the database
  • Course Number:
    od_odas_a02_it_enus

    Expertise Level
    Expert