Let us we  about how to create database in oracle 11g  with  manually

S-1: To view what are the databases  available on your machine

 [oracle@oracle11g ~]$ cat /etc/oratab

S-2: now enter the instance new  name like below

vi /etc/oratab

  manual db  

S-3: to set up instance name oracle environment  so we use the command "oraenv" and type new instance name => Press "Enter"

. oraenv

    m2  

S-4: we need to create the pfile for our database so copy init.ora rename it like below  

m3   

S-5: in "initVEST.ora" file we need to  change manually  dbname,memory_target into sga_target ,ORACLE_BASE location,control file location

Note :Short cut for text replace in text editor (Press esc + " :"1,$ s#<ORACL_BASE>#/u01/app/oracle/product/11.2.0.3#g +Enter)

m4  

m5  

S-6: after make a changes save the pfile and view the file because we need to create directory manually  has mentioned on our pfile

cat initVEST.ora

  m6  

m7

  S-7: in ORACLE_HOME/dbs location we need to  logon VEST db like below in nomount stage

m8   

S-8: create spfile from pfile  and shut the db

m9   

S-9: we need to create password file for our db if we dont create these file we ll get  error while creating dictionary time

m10

S-10: manual db creation script copy the file make it as create_db.sql

vi create_db.sql

  m11    

(Note : Here we should give  100m size  for mandatory tablespace if we reduce the size it gives error data dictionary creation time this size is approximate and reading purpose only)

S-11: connect your instance  and run "create-db.sql" script

m12    

m14  

S-12: go to ORACLE_HOME/dbs => create dict.sql => Execute the script like below

vi create_dictionary.sql

  m15    

m16  

S-13: once the dictionary has been created it ll shown like below

m17    

S-14: cross check  our db whether all dictionary files are created or  not

m22

m23  

S-15: once the database is opened we need to create user tablespace and make it has  default tablespace  

m24  

create  username like below

create user HARI identified by HARI

  m25  

S-16: give rights to that users

m26  

S-17: now i 'm going to connect the session with the username of hari it through error like below  

m27  

S-18: we need to execute pupbld.sql script from system user

m28  

S-19: once we done it connect the session on hari .it's working fine now

m29