Steps to create a Database Manually

1. Decide a unique SID
2. Set the OS variables (in unix / linux)
3. Create the parameter file

Important Parameters are :

a. DB_NAME

b. DB_DOMAIN

c. CONTROL_FILES

d. DB_BLOCK_SIZE

e. UNDO_MANAGEMENT

f. UNDO_TABLESPACE

4. Create and Set Oracle Service
5. Create password file
6. Start the Instance in NOMOUNT mode.
7. Create the DB : issue the Create Database Command:



CREATE DATABASE [database name]

[CONTROLFILE REUSE]

[LOGFILE [GROUP integer] file specification]

[MAXLOGFILES integer]

[MAXLOGMEMBERS integer]

[MAXLOGHISTORY integer]

[MAXDATAFILES integer]

[MAXINSTANCES integer]

[ARCHIVELOGNOARCHIVELOG]

[CHARACTER SET charset]

[NATIONAL CHARACTER SET charset]

[DATAFILE filespec [autoextend]]

[DEFAULT TEMPORARY TABLESPACE tablespace filespec]

[UNDO TABLESPACE tablespace DATAFILE filespec]
[SET TIME_ZONE [time_zone_region]];

A working example of a CREATE DATABASE script follows:


create database ora10
logfile group 1 ('D:\oracle\databases\ora10\redo1.log') size 10M,
group 2 ('D:\oracle\databases\ora10\redo2.log') size 10M,
group 3 ('D:\oracle\databases\ora10\redo3.log') size 10M
character set WE8ISO8859P1
national character set utf8
datafile 'D:\oracle\databases\ora10\system.dbf'
size 50M
autoextend on
next 10M maxsize unlimited
extent management local
sysaux datafile 'D:\oracle\databases\ora10\sysaux.dbf'
size 10M
autoextend on
next 10M
maxsize unlimited
undo tablespace undo
datafile 'D:\oracle\databases\ora10\undo.dbf'
size 10M
default temporary tablespace temp
tempfile 'D:\oracle\databases\ora10\temp.dbf'
size 10M;

8. Execute the Scripts that generate the Data Dictionary Views.

- CATALOG.sql for data dictionary views
- CATPROC.sql for objects required to use PL/SQL.
- SQL> @?/rdbms/admin/catalog.sql
- SQL> @?/rdbms/admin/catproc.sql

9. Create Server Parameter File from Pfile.
10. Backup the DB (cold backup)
11. Create Additional Tablespaces