CREATE DATABASE Manually ?

[vr76413]

Ok...now i got the services started...then this is what i did..my pfile is copied from c:\oracle9i\ora92\admin\pfile\heatdb\initheatdb.ora to c:\oracle9i\ora92\database\heatdb.ora

*********************************************************
SQL> connect / as sysdba
Connected to an idle instance.
SQL>
SQL>
SQL>
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE9I\ORA92\DATABASE\INITCHEATDB.ORA'

**********************************************************

Why is it saying caouldnot open ?...any ideas...

Thanks a lot for all your help

[Sameer]

It is poiting to different pfile, i.e to " 'C:\ORACLE9I\ORA92\DATABASE\INITCHEATDB.ORA'"
where as your pfile is "c:\oracle9i\ora92\database\heatdb.ora"

try

startup nomount pfile=c:\oracle9i\ora92\database\heatdb.ora

[vr76413]

Thanks Sameer...Still having problems Creating DB...

**************************************************

SQL> startup nomount
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL> @c:\createdb.sql
CREATE DATABASE heatdb
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL>

***********************************

Any ideas...

thanks

[jovery]

This error can occur if the bdump destinations is incorrect or the database server does not have the correct permissions to write in that directory (alert.log file cannot be written)

regards