Control file could not be located

[manishgatha]

Hello friends,

I joined the community today only and am posting my first question.I hope you will help me.

I wanted to install only SAP central instance only for SRM system as i am having the database with me but by mistake i started the insatlling complete central instance with database.I stopped the process in between but few data files were created.I deleted the newly created database and started insatlling the central instance only.But now the central instance is not starting as database is not up.I tried to start the database but i m getting the ORA-0205 could not locate the control file.It seems the file got corrupted.Kindly help.

Regards
Manish

[debasisdas]

Cause: The system could not find a control file of the specified name and size.

Action: Check that ALL control files are online and that they are the same files that the system created at cold start time.

[debasisdas]

If the system can't find the control file, then the database can't be mounted. Find the file and put it in the path, as specified in the INITSID.ORA file's CONTROL_FILES parameter else check the CONTROL_FILES parameter of the INITSID.ORA file. Check if you have referenced the correct file.

You can find this by executing:

SELECT VALUE FROM V$PARAMETER WHERE NAME = 'control_files' 

Check that ALL controlfiles, found using the select above, are online and that they are the same files that the system created at cold start time.

If you cannot find the control file, then start the instance without mounting the database and use CREATE CONTROLFILE statement to create a new control file. After creating the control file, shut the database. Now add this control file to the INIT.ORA and then start the database.