controlfile problems!

[former_member215439]

During installation of SAP, i have encounter this

1.)

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file

'%ORACLE_HOME%\DATABASE\DBS1%ORACLE_SID%.ORA'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

[former_member182657 · Accepted solution]

Hi James,

Could you please share what exactly the issue you're facing now.Are you getting

ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'G:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

If ORA-01110,then you need to perform the recovery to make the DB consistent for further actions.Refer alert_<SID>.log file for more details on it.

If getting

ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Which i supposed the issue has already been resolved by you,anyways check for the correct path,permissions and owner ships to the directories by again referring alert_<SID>.log file.

Hope this will help you.

Regards,

[former_member1232 · Accepted solution]

Check the permissions of control files and also space available in orilogA/orilogB/sapdata1/cntrl

Thank you,

Amit Lal