DBA

How to Create Database :-

When you install oracle ,database automatically created. If you want create manually doing following steps...( Windows )

• SID ---> Any name that is your database name

Step 1 :

• Copy the default parameter file and prepare it ( \Oracle\ora90\database)

Step 2 :

• You should change sid name as like your database name (put in pfile folder in \oracle\admin\{sid}\pfile)
• Put it five folder in \oracle\admin\{sid}\(put it and rename like create,pfile,udump,bdump,cdump)
• Save the parameter file

Step 3 :

* create password file

type on cmd platform

Run ---> cmd Enter

cmd>orapwd file= \oracle\ora90\database\pwd{sid}.ora pwd=sys (as your choice)

Step 4:

* In windows create services for instance

cmd>oradim -new -sid {sid}

* Set Oracle Sid

cmd>set oracle_sid={sid}

Step 5:

cmd>sqlplus

Enter username : sys/sys as sysdba

Connected to an idle instance

sql>Startup nomount

sql>create database {sid}

Logfile

group 1 ('\oracle\oradata\{sid}\redo01.log') size 100m,

group 2 ('\oracle\oradata\{sid}\redo02.log') size 100m

datafile '\oracle\oradata\{sid}\system01.dbf' size 20m autoextend on

undo tablespace undotbs

datafile '\oracle\oradata\{sid}\undotbs01.dbf' size 20m

default temporary tablespace tempts1

tempfile '\oracle\oradata\{sid}\tempts01.dbf'

size 20m

/

Database created

sql>@c:\oracle\ora90\rdbms\admin\catalog.sql

sql>@c:\oracle\ora90\rdbms\admin\catproc.sql

****

http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html