Question Re: Unable to starrtup Database in Technology Q&A

Unable to starrtup Database

Former Member — Sun, 20 Nov 2011 01:59:20 GMT

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

Re: Unable to starrtup Database

Former Member — Sun, 20 Nov 2011 03:09:30 GMT


> 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

Re: Unable to starrtup Database

Former Member — Sun, 20 Nov 2011 14:50:07 GMT

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

Re: Unable to starrtup Database

vincentlim826 — Mon, 21 Nov 2011 07:43:21 GMT

see:

Note 546006: Problems with Oracle due to operating system errors

(Solution part 3)

Regards,

Vincent

Re: Unable to starrtup Database

Former Member — Mon, 21 Nov 2011 08:03:40 GMT

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

Re: Unable to starrtup Database

Former Member — Wed, 23 Nov 2011 09:44:32 GMT

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

Re: Unable to starrtup Database

Former Member — Mon, 28 Nov 2011 11:34:42 GMT

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