oracle 11g database manual creation

1)[oracle@localhost]cd /u01

[oracle@localhost/u01]mkdir test

[oracle@localhost/u01/test]cd test

mkdir adump diag flash_recovery_area


2) cd $ORACLE_HOME/dbs
orapwd file=orapwtest password=sys


3) [oracle@localhost test]$ cd $ORACLE_HOME/dbs


4) [oracle@localhost dbs]$ vi inittest.ora

db_name='test'

memory_target=1G

processes = 150

audit_file_dest='/u01/test/adump'

audit_trail ='db'

db_block_size=8192

db_domain=''

db_recovery_file_dest='/u01/test/flash_recovery_area'

db_recovery_file_dest_size=2G

diagnostic_dest='/u01/test/diag'

dispatchers='(PROTOCOL=TCP) (SERVICE=test)'

open_cursors=300

remote_login_passwordfile='EXCLUSIVE'

undo_tablespace='UNDOTBS1'

# You may want to ensure that control files are created on separate physical

# devices

control_files = (/u01/test/ora_control1.ctl,/u01/test/ora_control2.ctl)

compatible ='11.2.0'

:wq!

6) sqlplus '/as sysdba'

startup nomount  pfile='$ORACLE_HOME/dbs/inittest.ora';

CREATE DATABASE test

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXDATAFILES 100

MAXINSTANCES 1

LOGFILE

GROUP 1 '/u01/test/redo1.log' SIZE 50M,

GROUP 2 '/u01/test/redo2.log' SIZE 50M,

GROUP 3 '/u01/test/redo3.log' SIZE 50M

DATAFILE

'/u01/test/system.dbf' size 200M REUSE

sysaux datafile '/u01/test/sysaux.dbf' size 2G

undo tablespace UNDOTBS1

datafile '/u01/test/undo1.dbf' size 2G 

DEFAULT TEMPORARY TABLESPACE temp1

TEMPFILE '/u01/test/temp01.dbf'

SIZE 2G REUSE

CHARACTER SET AL32UTF8;

SQL>@$ORACLE_HOME/rdbms/admin/catalog.sql

SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql

conn system/manager

SQL> conn system

Enter password: 

Connected.

SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql

then shutdown the database and  startup

7) create tablespace 

  CREATE TABLESPACE test_ts DATAFILE

  '/u01/test/test_ts_01.dbf' SIZE 4294967296,

  '/u01/test/test_ts_02.dbf' SIZE 4294967296,

  '/u01/test/test_ts_03.dbf' SIZE 4294967296,

  '/u01/test/test_ts_04.dbf' SIZE 4294967296,

  '/u01/test/test_ts_05.dbf' SIZE 4294967296

 LOGGING ONLINE PERMANENT BLOCKSIZE 8192

  EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;

8)

create user

 create user test

 identified by test

 default tablespace test_ts

 temporary tablespace temp1;

if you have any doubt contact iqsha77@gmail.com