RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing DB Objects
Backup Recovery
Admin Tasks
Create Database
«Prev
Next»
Creation Architecture
SQL*Plus
Oracle SQL*Plus
Locating Oracle Home
Shared Server Executable
Starting Shared Server
Shared Server Commands
Disconnect Command
Potential Mistake-commands
Shared Server Help
Describe Command
Oracle Describe
Spool Command
Execute SQL
Shared Server Conclusion
Database Architecture
Database File Types
Initialization File
Database Control File
Oracle Datafiles
Oracle Tablespaces
Extract TS Information
Redo Logs Crash-recovery
Preserve Redo Logs
Cycles Redo Log Files
Redo Log Info
Archived Redo Logs
Architecture Conclusion
Instance Architecture
Difference instance Database
Instance Overview
Asynchronous Process Coordination
System Global Area
System Monitor Process
Oracle Process Monitor
dbw0 Database Writer
Database Writing Time period
Writing Dirty Buffers
Checkpoint Trigger Database
Limiting Dirty Buffers
lgwr Log Writer
Llog Writing Process
Oracle Archiver Process
Archive Log List
CKPT Checkpoint Process
Other Oracle Processes
Memory Architecture
System Global Area
Database Buffer Cache
Multiple Buffer Pools
Redo Log Buffer
Oracle Shared Pool
SQL Command Matching
Large Pool
Program Global Area
PGA Contents
Sort Area
SharedServer PGA
Memory Architecture Conclusion
Database Creation
Database Environment
OFA
DB Initialization File
Determining file Location
Set Block Size
Initial DB Files
Sizing SGA
Database Parameters
DB Preparation Conclusion
DBCreate Commands
Create Database Command
Create Oracle Service
Starting Oracle Instance
Execute Create DB Command
Change System Password
Data Dictionary Scripts
Running catproc Script
Running pupbld Script
Product User Profile
Creating Initial Tablespaces
Creating Rollbac Ssegments
Creating DBs Conclusion
CREATE DATABASE command - Exercise
Executing the CREATE DATABASE Command
Create your COIN database
Objective:
Execute your CREATE DATABASE script
Exercise scoring
This exercise is worth a total of ten points. It is auto-scored; when you have completed the exercise, click the
Submit
button at the bottom of the page to receive full credit.
Instructions
It is time for you to create your COIN database. Execute the CREATE DATABASE script that you have written. If you have problems that you cannot resolve on your own, e-mail the spool file to the cyborg for help. Otherwise, click the Submit button after you create the database.
Hints
Remember to connect to the COIN instance with Server Manager and to start it using the STARTUP NOMOUNT command.
If you previously started the instance, and then exited Server Manager, you will need to reconnect before you run the CREATE DATABASE script.
Remember to spool the output from the script in case you need it for debugging purposes.
If your command fails and you need to retry it, you will need to delete any control files, redo log files, and datafiles that may have been created before the failure occurred.