Total Time: 3 hour(s)

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

Ojectives: 
After completing this course, students will be able to:
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

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

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.