Unable to starrtup Database

[Former Member]

Dear Experts,

We are using Oracle 10g with Ecc 6.0

SQL> startup mount

ORACLE instance started.

Total System Global Area 535662592 bytes

Fixed Size 1334380 bytes

Variable Size 306185108 bytes

Database Buffers 222298112 bytes

Redo Buffers 5844992 bytes

ORA-00205: error in identifying control file, check alert log for more info

AlertSID.log

Alter database Mount.

controlfie 'sapdata1,origloA,origlogB

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Please suggest

with Regards

[Former Member]

Dear All,

I have changed correct location of control files in the source system and modify your initSID.ora file on target system after that Database opened Easily.

with Regards

Anant

[Former Member]

Hi,

Check that the proper control filename is referenced in the CONTROL_FILES initialization parameter (init<SID>.ora,spfile<SID>.ora) and check if these files physically exists on defined O/S path, If both the things are in sync then only DB can startup.

Thanks,

Kapil Pandey

[Former Member]

Hi,

When you are starting the DB it will look into the Oracle initialization profile ( init<SID>.ora )

This profile consist Orcale instance settings (SGA, buffer values) and control file locations.

As per your log DB is unable to come nomout phase to mount phase.

Please check the init<SID>.ora file and check whether specified files physically exist or not at OS level.

I hope it will help you.

Regards,

Kiran .V

[vincentlim826]

see:

Note 546006: Problems with Oracle due to operating system errors

(Solution part 3)

Regards,

Vincent

[former_member188883]

Hi,

controlfie 'sapdata1,origloA,origlogB
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

I assume you have performed database system copy using backup/restore mechanism and due to this you have landed up in this issue. You can do the steps mentioned in above thread. Alternatively you can check the correct location of control files in the source system and modify your initSID.ora file on target system accordingly.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

> controlfie 'sapdata1,origloA,origlogB
> ORA-27037: unable to obtain file status
> Linux Error: 2: No such file or directory
> Additional information: 3

Did you check the control files in above mentioned three folders ?

First verify the initSID.ora to check and verify the exact three location paths for the control files. And then verify whether the control files actually exist there in those paths or not.

Thanks