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 =

Related Posts: