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
Shared Server Areas
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
Running pupbld Script
Starting Oracle Instance
Creating New Oracle service - Exercise
Creating a service using ORADIM
Objective:
Use the ORADIM command to create a new service for the COIN instance.
Exercise scoring
This exercise is worth a total of five points. It's auto-scored; when you've completed the exercise, click the OK, I'm Done button at the bottom of the page to receive full credit.
Background/overview
Before you can create a new database on Windows NT, you must first create a Windows NT service. You can do this with the ORADIM command. In this exercise, you will run ORADIM to create a service for the COIN database.
Instructions
If you are running on UNIX, don't do this exercise. You don't need to do this step for UNIX. And if you are not running the Oracle8 software at all, you can't do this exercise. Just click the
Submit
button and go on with the course. If you are a Windows NT user, go ahead and complete this exercise.
Open a command prompt window, and enter the following command:
ORADIM -NEW -SID COIN -STARTMODE auto -PFILE c:\oracle\admin\coin\pfile\initcoin.ora
This is a long command and it will probably wrap to a second line when you enter it. That's OK. Do be sure that the parameter filename is correct, based on how you named your initialization file and where you placed it.
You won't get much of a response from this command. If you don't get any error messages, it's safe to assume that it worked. Just to be sure though, you should check the Services control panel to be sure that the new service is listed.