Control files missing after installation
Hi,
I installed Oracle 10g in Debian. After installation, I was able to start the instance using sqlplus(in command line).But when I try to mount and open the database ,it threw an error likr ORA:00205 control file not found ...check the alert log. This happened because I'm missing the datafiles and hence no control files.
I think it's because I didn't specify the datafiles location during installation.
My questions are below.
1) What should I do now. Can I create datafiles and create the control files. If so, how?
2)Can anybody provide me the syntax to create datafiles and controlfiles and where they should be created.
Any reply would be greatly appreciated.
Thanks.