|
Provided by: Serebra Learning Corporation Oracle9i Database Administration: Create a DatabaseOracle9i |
 |
Training
Provided by Serebra Learning Corporation
The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components management of rollback segments temporary segments and indexes. In addition this course discusses how to create and maintain databases. The course also covers the new features of Oracle9i such as Oracle Managed Files and Undo tablespaces and the new features of the LogMiner utility.
|
|
||||||||||
Oracle9i Database Administration: Create a Database
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 data file.
Identify the features of SYSTEM and non-SYSTM tablespaces.
Identify the features of locally-managed tablespaces.
Identify the features of multiple nonstandard block size tablespaces.
Identify the features of temporary tablespaces.
Identify the restrictions on default temporary tablespaces.
Audience
The intended audience for this course include Database Administrators System Administrators Network Administrators Technical Support Professionals and Consultants. Additionally learners should have taken the first part of the series 64311. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110) Oracle SQL: Data Retrieval Techniques (61111) Oracle SQL: DML and DDL (61112) Oracle PL/SQL: PL/SQL Basics (61113) Oracle PL/SQL: Procedures Functions and Packages (61114) Oracle PL/SQL: Database Programming (61115).
Objective
Upon completion of this course the student will be able to:
- Discuss the guidelines for creating an OFA structure and the information in the ORACLE_HOME subdirectories.
- Identify the requirements and factors considered while creating a database the guidelines for planning the physical database design the registry entries that must be specified for proper database functionality and create a password file.
- Identify the types of parameter files create a parameter file by editing settings in the init.ora file and start an instance in the NOMOUNT mode.
- Identify the command options of the CREATE DATABASE command the situations in which it fails create a database by using the CREATE DATABASE command and identify its content after creation.
- Identify the benefits of using Oracle-Managed Files and manage data files control files and online redo log files using OMF.
- Describe the data dictionary structure identify the data dictionary categories and retrieve data dictionary information.
- Execute catproc.sql and identify the uses of administrative scripts categories.
- Identify the properties of stored procedures and packages the benefits of using stored program units and the functions of Oracle-supplied packages.
- Retrieve information about stored objects identify the common situations when dependent objects may have an INVALID status and the functions of the control file with the types of information stored.
- Retrieve control file information multiplex a control file and identify the uses of redo log groups the features of members and the parameter values of redo log files.
- Identify the situations in which log switches and checkpoints occur force log switches and checkpoints and identify the functions of parameters that control the checkpoints.
- Identify the features of archive modes and retrieve information about the archive modes and online redo log groups and members.
- Plan the number and size of online redo log files maintain redo log members and groups and troubleshoot LGWR errors.
- Identify the logical database structure and the types of tablespaces create resize and change the properties of a tablespace by using Oracle Enterprise Manager.
- Create read-only tablespaces and drop tablespaces identify the benefits of multiple tablespaces and specify storage parameters and retrieve data dictionary information.
- Identify the features of undo tablespaces and manage undo tablespaces.
Topics Include
Unit 1: Creating a Database: Procedure 1 - 2 hours
- Identify the guidelines for creating an OFA-compliant directory structure for Windows NT.
- Match the ORACLE_HOME subdirectories with their contents.
- Identify the factors to be considered when creating a database.
- Identify the prerequisites 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.
- Create a database by using the Oracle Database Configuration Assistant.
- Identify the registry entries that must be specified for a database to function efficiently.
- Specify a password file for an instance by using the ORAPWD utility.
- Identify the features of Oracle9i parameter files.
- 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 the Oracle SQL*Plus Worksheet.
- Identify the functionality of the CREATE DATABASE command options.
- Create a database with the specified parameter values by using the CREATE DATABASE command.
- Identify the commonly encountered situations in which the CREATE DATABASE command fails.
- Identify the database components that are created upon successful execution of the CREATE DATABASE command.
- Identify the characteristics associated with the Oracle-Managed Files feature in Oracle9i.
- Identify the benefits of using the OMF feature of Oracle9i.
- Select the features of the Oracle-Managed Files initialization parameters.
- Set the OMF initialization parameters by using the INIT.ORA file.
- Match the Oracle file types with their OMF-compliant filenames.
- Identify the clauses that can be omitted during database creation by specifying the DB_CREATE_FILE_DEST initialization parameter.
Unit 2: Data Dictionary and Standard Packages 1 - 2 hours
- Identify the types of information stored in the data dictionary.
- Identify the features of the data dictionary components.
- Create data dictionary views for a specific database by executing the appropriate script.
- Identify the contents of data dictionary view categories.
- Retrieve specific information by querying data dictionary views.
- Identify the features of dynamic performance tables.
- Create PL/SQL functionality for a specified database by using the Oracle SQL*Plus Worksheet.
- Match the administrative scripts categories with their functions.
- Identify the properties of stored procedures.
- Identify the properties of packages.
- Identify the benefits of using stored program units.
- Match the Oracle-supplied packages with their functions.
- Retrieve information about the status of objects in a specified database by querying the DBA_OBJECTS data dictionary view.
- Retrieve information about a stored program unit specification by using the DESCRIBE command.
- Identify the common situations when a dependent object may have an INVALID status.
Unit 3: Maintaining Redo Logs and Control Files 2 hours
- Identify the functions of a control file.
- Identify the types of information stored in a control file.
- Match the dynamic performance views with the information they contain about the control files.
- Multiplex a control file by using the OEM Console.
- Identify the uses of redo log groups.
- Identify the features of redo log members in a group.
- Identify the features of the parameters that limit the number of online redo log files.
- Identify the situations in which a log switch occurs.
- Force a log switch by using the OEM Console.
- Identify the situations in which a checkpoint occurs.
- Force a checkpoint by using the OEM Console.
- Select the features of the initialization parameters that control database checkpoints.
- Select the features of the ARCHIVELOG and NOARCHIVELOG archive modes.
- Match the command and dynamic performance views with the information they access about the log and archive status of a database.
- Match the dynamic performance views with the information they provide about online redo log groups and members.
- 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 and separating them from data files.
- Identify the factors that influence the sizing of the online redo log files.
- Add a redo log group by using the OEM Console.
- Add an online redo log member to a redo log group by using the OEM Console.
- Sequence the steps you use to relocate an online redo file.
- Drop an online redo log group by using the OEM Console.
- Drop an online redo log member by using the OEM Console.
- Reinitialize an online redo log file by using the Oracle SQL*Plus Worksheet.
- Identify the new features of LogMiner for redo log files generated by Oracle9i.
- Match the LogMiner views with their contents.
- Sequence the steps in a typical LogMiner session.
- Match the situations in which specific online redo log members are not available with the resulting LGWR behavior.
- Match the possible LGWR error situations with their solutions.
Unit 4: Managing Tablespaces and Data Files 2 hours
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
