2.6. Exam Essentials

Define the Oracle Enterprise Management Framework. Describe what the Oracle Enterprise Management Framework is and the components of the framework. Understand how the components of the Management Framework communicate using agents.

Know how to start and stop Grid Control. Understand the commands necessary to start and stop the Grid Control. Be able to describe the circumstances in which the Grid Control is utilized in the Oracle enterprise.

Know how to start and stop the EM Database Control. Know the command necessary to start and stop the EM Database Control. Be able to describe the difference between the Database Control and the Grid Control and under what circumstances the Database Control is used in the Oracle enterprise.

Know how to start and stop the iSQL*Plus agent. You should understand how to stop and start the iSQL*Plus agent. The agent must be started in order to use the iSQL*Plus tool to interact with the database.

Understand how to login and interact with the database using iSQL*Plus. You need to understand how to connect to the database using the iSQL*Plus tool and how to enter and run commands using the tool.

Be able to create a database using the DBCA. Describe the steps involved in creating a database using the Oracle Database Configuration Assistant (DBCA). Understand how the DBCA uses templates to store information about databases and how templates are used by the DBCA to create databases. Be familiar with the various options available to you when creating an Oracle database using the DBCA.

Know how to delete a database using the DBCA. Understand how to use the DBCA tool to delete a database.

Know how to manage DBCA templates. Understand how to use the DBCA to manage templates and the various options available when creating new database templates. Understand what each option is and when it should be used.

Describe the database startup modes. Understand the various modes of database startup. Understand what each database startup option is and when you might use the option.

Recognize how to start up an Oracle database. Understand how to use the database tools to start up an Oracle database.

Describe the shutdown database modes. Understand the various modes of database shutdown. Understand what each database shutdown option is and when you might use the option.

Be able to shut down an Oracle database. Understand how to use the database tools to shut down an Oracle database.

Know how to manage the Oracle parameter file. Be able to identify the Oracle parameter file and the different types of parameter files. Also understand how you can change the parameter files.

View and understand the contents of the Oracle alert log. Be able to identify the Oracle alert log and the kinds of information Oracle writes to the alert log. Be able to identify the database initialization parameter that provides the location of the alert log.