MP9003: Network and Database (General) - Managing Instances and Creating Databases > Oracle9i Database Fundamentals 1Z0-031

This course introduces users to managing an Oracle instance, creating a database, and using globalization parameters. 

Topics:
Creating an Initialization Parameter File
Configuring Oracle-Managed Files
Starting an Instance using SQL*Plus
Startup Methods and Options
Shutting Down an Instance
Using Diagnostic Files
Planning for Database Creation
Preparing the Parameter File
Using the Database Configuration Assistant
Creating a Database Manually
Choosing a Character Set
Specifying Language-Dependent Behavior
Viewing Globalization Support Information

Objectives:
Create and manage an initialization parameter file
Configure Oracle-managed files
Use the startup command
List the different options available for starting Oracle
Shut down an Oracle instance
Describe the two types of diagnostic files used in Oracle
List the prerequisites necessary for database creation
List values that must be set in the parameter file
Use the Database Configuration Assistant
Create a database with the create database command
Define a character set for your database
Configure language-dependent behavior for the your database
Retrieve NLS information from the your database

Duration:
3 Hours