Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle database creation failed

760401Sep 2 2010 — edited Sep 4 2010
Hi ,
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
This post has been answered by rajeysh on Sep 3 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2010
Added on Sep 2 2010
15 comments
3,978 views