Oracle Database Administration/Instances

This lesson introduces Oracle database instance management.

Objectives and Skills
Objectives and skills for the instance management portion of Oracle Database Administration I certification include:
 * Managing the Oracle Instance
 * Setting database initialization parameters
 * Describe the stages of database startup and shutdown
 * Using alert log and trace files
 * Using data dictionary and dynamic performance views

Readings

 * 1) Oracle: Database 2-Day DBA Getting Started with Database Administration

Multimedia

 * 1) YouTube: Oracle Enterprise Manager OEM

Activities

 * 1) Use Oracle Enterprise Manager.
 * 2) Complete the tutorial Oracle: Getting Started with Oracle Enterprise Manager.
 * 3) Stop and start Enterprise Manager.
 * 4) Review Oracle: Administering a Database on Windows.
 * 5) Use the following commands to view status, stop, and start the Enterprise Manager console service:
 * 6) Use the Windows Services management console to view status, stop, and start the OracleDBConsoleorcl console service.
 * 7) Use the following commands to view status, stop, and start the NET command to stop and start the OracleDBConsoleorcl console service:
 * 8) Test connecting to Enterprise Manager.
 * 9) Use , Services, or   to stop Enterprise Manager.
 * 10) While the service is stopped, attempt to connect to Enterprise Manager using a web browser. The connection will fail.
 * 11) While the service is stopped, attempt to connect to the Oracle database using SQL*PLUS. The connection should succeed.
 * 12) Use , Services, or   to start Enterprise Manager.
 * 13) Use a web browser to connect to Enterprise Manager to verify the service started.
 * 14) User Enterprise Manager Database Control to shutdown and startup the database.
 * 15) Review Oracle: Administering a Database on Windows.
 * 16) Use Enterprise Manager Database Control to shutdown the database. Under Advanced Options, choose Transactional.
 * 17) While the database is shutdown, attempt to connect to the database with SQL*PLUS.
 * 18) Use Enterprise Manager to startup the database. Under Advanced Options, view the options available but keep the default settings.
 * 19) Use SQL*PLUS to shutdown and startup the database.
 * 20) Review Oracle: Administering a Database on Windows.
 * 21) Use the following command to shutdown the database:
 * 22) Use the following command to startup the database:
 * 23) Use SQL*PLUS to shutdown and startup the database in stages:
 * 24) Review Oracle: Starting Up a Database.
 * 25) Use the following command to close and dismount the database:
 * 26) Use the following command to verify instance status:
 * 27) Use the following command to startup the database:
 * 28) Use the following command to verify instance status:
 * 29) Use the following command to mount the database:
 * 30) Use the following command to verify instance status:
 * 31) Use the following command to open the database:
 * 32) Use the following command to verify instance status:
 * 33) View the alert log.
 * 34) Review Oracle: Viewing the Alert Log.
 * 35) Use Enterprise Manager to view Alert History and Alert Log Contents.
 * 36) Use SQL*PLUS to locate the alert log with the following query:
 * 37) Use a text editor to open and view the alert log.
 * 38) Use data dictionary and dynamic performance views.
 * 39) Review Oracle: Data Dictionary and Dynamic Performance Views.
 * 40) Use the following query to identify available DBA_ views:
 * 41) Use the following query to identify available ALL_ views:
 * 42) Use the following query to identify available USER_ views:
 * 43) Use the following query to identify available V$ views:
 * 44) Select records from one or more DBA_, ALL_, USER_, and V$ views.

Lesson Summary

 * Oracle database utilities depend on correct environment variable settings for ORACLE_HOME and ORACLE_SID.
 * %ORACLE_HOME%\bin must be included in the PATH environment variable.
 * Enterprise Manager Control (emctl) is used to start, stop, and display the status of the Enterprise Manager console website.
 * The Enterprise Manager database home page is located at https://server:1158/em.