oracle database creation failed
760401Sep 2 2010 — edited Sep 4 2010Hi ,
iam trying to create a database manually .... my logfiles ,controlfiles and system file is getting created but later on mid it throws an error iam using o/s as windows and oracle 10g
create database krishna
*
error at line 1
ora-ora-01092:oracle instance terminated disconnection forced :
i have done the follwing steps :
1) create a service on windows
oradim -new -sid krishna
2) crete a passwordfile
orapwd file ='d:\oracle\oradata\pwdkrishna.ora password=krishna
3) sqlplus /nolog
4)connect / as sysdba
5) create spfile from pfile
6) exit
7)startup nomount
8) create database
i have tried it around 3-4 times but my database isn't getting created every time iam getting the same error
Kindly help..........
Thanks &Regards
Kavita