How to create Database Manually in oracle

CREATING   MANUAL  DATABASE

Create the following directories in a folder where u want to create database:

--          c:\oracle\admin\dbname

--          c:\oracle\oradata\dbname

--          c:\oracle\admin\dbname\pfile

--          c:\oracle\admin\dbname\cdump

--          c:\oracle\admin\dbname\bdump

--          c:\oracle\admin\dbname\udump

--          c:\oracle\admin\dbname\create

            Copy the default pfile from C:oracle\ora90\admin\sample\pfile\initsmpl.ora to                                            --          c:\oracle\admin\dbname\pfile\initdbname.ora

            Edit the pfile c:\oracle\admin\dbname\pfile\initdbname.ora as per the following:

            (check if the parameters are there in the file. If not add them manually.

           

--          db_name = dbname

--          control_files = ("C:\oracle\oradata\dbname\control01.ctl")

--          background_dump_dest = c:\oracle\admin\dbname\bdump

--          core_dump_dest = c:\oracle\admin\dbname\cdump

--          user_dump_dest = c:\oracle\admin\dbname\udump

--          remote_login_passwordfile = exclusive

--          undo_management=AUTO

--          undo_tablespace=undotbs1

Copy the initdbname.ora from ur database to

C:oracle\ora90\DATABASE\initdbname.ora.

Creating the Instance of your Database

Note: The following command is to be executed from the Cmd prompt

oradim -new -sid dbname  -startmode a –pfile c:\oracle\admin\dbname\pfile\initdbname.ora

Note : Execute this command from the direcory where you should create this file i.e. the default directory is %ORACLE_HOME%\database  directory.

--          cd C:\oracle\ora92\bin

--          orapwd.exe file=C:\oracle\ora92\database\PWDdbname.ora password=change_on_install entries=5

Getting connected.

Go to Command Prompt and set the Oracle_SID to the value same as the DB_NAME

            set oracle_sid=dbname

            sqlplusw /nolog

            connect sys/pasword as sysdba

(IT WILL CONNECT US TO AN IDLE INSTANCE)

Creating / Starting Database

startup nomount

Type the following command in a notepad & run it on SQL prompt.

CREATE DATABASE dbname

MAXINSTANCES 1

MAXLOGHISTORY 1

MAXLOGFILES 5

MAXLOGMEMBERS 3

MAXDATAFILES 100

DATAFILE 'C:\oracle\oradata\dbname\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED

DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\oracle\oradata\dbname\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED

UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:\oracle\oradata\dbname\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED

LOGFILE GROUP 1 ('C:\oracle\oradata\dbname\redo01.log') SIZE 102400K,

GROUP 2 ('C:\oracle\oradata\dbname\redo02.log') SIZE 102400K,

GROUP 3 ('C:\oracle\oradata\dbname\redo03.log') SIZE 102400K;

After creating the database run the following three scripts

To create the Data Dictionary Views

            @c:\oracle\ora92\rdbms\admin\catalog.sql;

To run the scripts for PL/SQL Procedures

@c:\ORACLE\ora92\rdbms\admin\catproc.sql;

connect system/manager

@c:\oracle\ora92\sqlplus\admin\pupbld.sql;