RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing DB Objects
Backup Recovery
Admin Tasks
Create Database
«Prev
Next»
Creation Architecture
SQL*Plus
Describe Command
Spool Command
Database Architecture
Cycles Redo Log Files
Redo Log Info
Extract TS Information
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
Database Buffer Cache
Oracle Shared Pool
Large Pool
Program Global Area
PGA DBWR SGA
PGA Contents
SharedServer PGA
Sort Area
Shared Server Areas
Database Creation
Redo Log File Sizes
Config Files
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.