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<sid_name>.ora file

SET ORACLE_SID=<sid_name>

Make <sid_name> the current SID

3. Prepare the parameter file

useinit.ora as a parameter file template

db_name =  Eight characters or fewer that identify the database

control_files = the location of three control files

DB_BLOCK_SIZE = Determines the database block size (can not    change after the database has been created)

4. Create a password file

5. Start the instance

STARTUP NOMOUNT pfile=init.ora

6. Create the database

MANUALLY FROM Server Manager

CREATE DATABASE "<sid_name>"

MAXLOGFILES 6

MAXLOGMEMBERS 6

MAXDATAFILES 30

MAXLOGHISTORY 100

ARCHIVELOG

LOGFILE

GROUP 1

'E:DATAsid GROUP1log1a.rdo' SIZE 200K,

'E:DATAsid GROUP1log1b.rdo' SIZE 200K

GROUP 2

'E:DATAsid GROUP2log2a.rdo' SIZE 200K,

'E:DATAsid GROUP2log2b.rdo' SIZE 200K

GROUP 3

'E:DATAsid GROUP3log3a.rdo' SIZE 200K,

'E:DATAsid GROUP3log3b.rdo' SIZE 200K

DATAFILE

'E:DATAsid DATAFILESsystem01.dbf'

size 30M

CHARACTER SET WE8ISO8859P1;

Database

selectname,created,log_mode from v$database;

Thread

select status, instance from v$thread;

Datafiles

select name from v$datafile;

Logfiles

select member from v$logfile;

Controlfiles

select name from v$controlfile;

Verify System Creation

selectfile_name from dba_data_files

wheretablespace_name='SYSTEM';

Look at the database users

select username, created from dba_users;

7. Run scripts to generate the data dictionary and        accomplish postcreation steps.

Create the data dictionary

CATALOG.SQL

prostcreation objects

CATPROC.SQL

8.   to know/determine the archive mode of the database 

            svrmgrl> archive log list   

                  or  issue the following statement 

                        selectlog_mode from v$database;                     

also issue the following statements to know whether the archive process is enabled or not 

selectarchiver from v$instance;

The output determines whether the process is started or not.

Creating a Database using Instance Manager

Step 1.

Start Instance Manager

Press the New Button

Input a SID (4 characters) ->abcd

Step 2.

Enter the DBA Authorization password and authenication

Step 3.

Press the Advanced Button

* The Database Name must be the same as the Database Name

in the initabcd.ora file

* Enter the max logfile value and the max group member value

* Design the location of your datafiles, logfiles,

archive files, and control files

* Change the logfile location and name to meet your design

 

* Set the location of the Parameter file