DATABASE CREATION
DATABASE CREATION
Step 01
Decide on the location of
Three control files (minimum) on different disks/ drives/volumes
Three groups of redo log files, with each group having two members (minimum) on different disks/ drives/volumes Create a file structure for the data files
Step 02
Creating database manually without auto undo management:
1. a. Decide on a unique instance name on NT/2000 machines up to 8.0.x cannot have a name with more than 4 characters and 8.1.x cannot have more than 8 characters
b. Database character set. Modifying the character set at a later date lands in many issues.
2. Set the operating system variables
(UNIX)
ORACLE_HOME
ORACLE_SID
ORACLE_BASE
ORA_NLS33
PATH
(NT)
ORADIM80 -NEW -SID u16
-INTPWD password -STARTMODE auto
-PFILE ORACLE_HOMEDATABASEinitu16.ora
You must decide the SID, Password, and
Create init.ora file
SET ORACLE_SID=
Make the current SID
3. Prepare the parameter file
useinit.ora as a parameter file template
db_name =