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

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