Oracle8 Database Administration - Create Database

Audience

Database Administrators system administrators network administrators and technical support professionals. Prior to taking this course participants should be familiar with SQL and PL/SQL using Procedure Builder or have taken courses 61110 61111 61112 and 60113. In addition participants should have taken the first part of the Oracle8 Database Administration series course 61311.

Objective

• Plan and create a database.
• Create the data dictionary view.
• Use the data dictionary view to retrieve information.
• Identify the properties and benefits of using stored procedures and packages.
• Plan for the creation of redo log files.
• Plan for the maintenance of redo log groups.
• Redo log members.
• Control files.
• Identify the process of log switches and checkpoints.
• Manage tablespaces and data files.

Topics Include

Unit 1 - Creating a Database: Procedure

• Identify the guidelines for creating an OFA structure.
• Match the ORACLE_HOME subdirectories with their contents.
• Identify the factors to be considered when creating a database.
• Identify the requirements for creating a database.
• Identify the guidelines to be followed for planning a physical database design.
• Identify the steps involved in manually creating a database.
• Identify the registry entries that have to be specified for proper database functionality.
• Create a specified password file for a given instance by using the ORADIM80 utility.
• Create a specified parameter file by editing specific settings in the default init.ora file.
• Start a specified instance in the NOMOUNT mode by using Oracle SQL Worksheet.
• Identify the functionality of the CREATE DATABASE command options.
• Create a database with specified parameter values by using the CREATE DATABASE command.
• Identify the commonly encountered situations in which the CREATE DATABASE command fails.
• Identify the contents of a database after its creation.

Unit 2 - Data Dictionary Views and Standard Packages

• Identify the types of information stored in the data dictionary.
• Identify the features of the data dictionary components.
• Create a data dictionary view for a specific database by executing the appropriate script.
• Identify the contents of the data dictionary view categories.
• Retrieve specific information by querying the Dictionary view.
• Create PL/SQL functionality for a specific database by executing the appropriate script.
• Match the administrative script categories with the views and package components they create.
• Identify the properties of stored procedures.
• Identify the properties of packages.
• Identify the benefits of stored program units.
• Match the Oracle-supplied packages with their functions.
• Retrieve information about invalid objects in a specified database by querying the required data dictionary view.
• Retrieve information about a stored program unit specification by using the Oracle SQL Worksheet.
• Identify the common situations when dependent objects may have an invalid status.

Unit 3 - Maintaining Redo Log Files and Control Files

• Identify the functions of a control file.
• Identify the types of information stored in a control file.
• Identify the dynamic performance views and the information they contain about the control files.
• Multiplex a control file.
• Identify the uses of redo log groups.
• Identify the features of redo log members in a group.
• Match the parameters that limit the number of online redo log files with what they determine.
• Identify the situations in which a log switch occurs.
• Force a log switch by using Oracle Backup Manager.
• Identify the activities that are performed during a checkpoint.
• Force a checkpoint by using Oracle Backup Manager.
• Identify the functions of the initialization parameters that can be set to control database checkpoints.
• Identify the features of archive modes.
• Identify the command and dynamic performance views with the information they contain about the log and archive status of a database.
• Identify the dynamic performance views and the information they contain about online redo log groups and members.
• Add a redo log group by using Oracle Backup Manager.
• Add a online redo log member to a redo log group by using Oracle Backup Manager.
• Relocate the online redo log file by using Oracle SQL Worksheet.
• Drop an online redo log group by using Oracle Backup Manager.
• Drop an online redo log member by using Oracle Backup Manager.
• Reinitialize an online redo log file by using Oracle SQL Worksheet.
• Identify the factors to be considered while planning for the number of online redo log files.
• Identify the reasons for storing the online redo log files on different disks.
• Identify the factors that influence the sizing of the online redo log files.
• Identify the Log Writer (LGWR) errors and effects when specific online redo log members are not available.
• Identify the possible LGWR errors with their solutions.

Unit 4 - Managing Tablespaces and Data Files

• Identify the logical database structure.
• Identify the components of the logical and physical structure of a database.
• Identify the relationships between database components.
• Identify the features of a tablespace.
• Identify the uses of a tablespace.
• Identify the features of a datafile.
• Differentiate between the types of tablespaces.
• Create a specified tablespace by using Oracle Storage Manager.
• Identify the segment storage allocation parameters and what they determine.
• Create a temporary tablespace by using Oracle Storage Manager.
• Add a datafile to a tablespace by using the Oracle Storage Manager.
• Enable automatic extension of a datafile in a tablespace by using Oracle Storage Manager.
• Resize a datafile by using Oracle SQL Worksheet.
• Change the values of the storage parameters by using Oracle Storage Manager.
• Identify the features of the modes in which a tablespace can be taken offline.
• Take a tablespace offline by using Oracle Storage Manager.
• Move a datafile of the Non-SYSTEM tablespace by using Oracle SQL Worksheet.
• Move a datafile belonging to the SYSTEM tablespace by using Oracle SQL Worksheet.
• Make a tablespace read-only by using Oracle Storage Manager.
• Sequence the steps to create a read-only tablespace on a read-only media.
• Drop a tablespace by using Oracle Storage Manager.
• Identify the effects of dropping a tablespace.
• Identify the benefits of using multiple tablespaces.
• Identify the benefits of specifying storage parameters for a tablespace.
• Identify the dynamic performance views and the information they contain.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

CDROM