Re: control file not created at the time of installation

Try:

1- Shutdown
2- Rename or delete the existing control files
3- startup nomount
4- 

create controlfile set database new
datafile 'e:\ORacle\oradata\new\system01.dbf',
'e:\ORacle\oradata\new\temp01.dbf',
'e:\ORacle\oradata\new\rbs01.dbf',
'e:\ORacle\oradata\new\indx01.dbf',
'e:\ORacle\oradata\new\tools01.dbf',
'e:\ORacle\oradata\new\dr01.dbf',
'e:\ORacle\oradata\new\users01.dbf'

logfile 'e:\ORacle\oradata\new\redo01.log' size 1M,

(note that in your case you should not use "reuse" and "resetlogs").

5- Alter database open.

HTH Daniel Received on Wed Sep 10 2003 - 17:44:35 CEST