ORA-01157: cannot identify/lock data file

[Former Member]

Hi Guys,

Could you please help me on this.when I am trying to start SAP am getting the below mentioned error.

every time i am facing this problam...when ever i restart system.

Can any one tell me the permanent solution for this error.

Thanks in Advance.

SQL> startup;

ORACLE instance started.

Total System Global Area 1929379840 bytes

Fixed Size 2072224 bytes

Variable Size 932078880 bytes

Database Buffers 939524096 bytes

Redo Buffers 14704640 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 132 - see DBWR trace file

ORA-01110: data file 132: '/oracle/AWI/sapdata4/ecc_122/ecc.data122'

Regards,

Sumit.

[former_member603052 · Accepted solution]

Hi Gupta,

The background process was either unable to find one of the data files or failed to lock it because the file was already in use.

Check the DBWR trace file as it mentioned.

Check with the permissions also as stefan already mentioned.

Kalyan

[Former Member · Accepted solution]

Hi Kalyan,

Could you please tell me the path of DBWR trace file.

Regards

Sumit

[stefan_koehler · Accepted solution]

Hello Sumit,

you already posted the DBWR trace file.

Now the error can have 2 reasons:

1) File has not the correct permissions

2) Another database instance has already attached (opened) this file

Please execute the following commands and post the result

shell> ls -la /oracle/AWI/sapdata4/ecc_122/ecc.data122
shell> fuser -uc /oracle/AWI/sapdata4/ecc_122/ecc.data122
shell> lsof /oracle/AWI/sapdata4/ecc_122/ecc.data122

Regards

Stefan

[former_member220071]

Hi Sumit ,

Your problem due to bad read-only file which is not detected at open time.

Try this

>READ_ONLY_OPEN_DELAYED=TRUE

Regards

Abhijeet

[stefan_koehler]

Hello Sumit,

just to be sure .. is the data file "/oracle/AWI/sapdata4/ecc_122/ecc.data122" available?

shell> ls -la /oracle/AWI/sapdata4/ecc_122/ecc.data122

If it was deleted or corrupted you have to restore and recover it.

Regards

Stefan

[Former Member]

Hi Stefan,

Thanks for prompt reply ... i have checked the datafile /oracle/AWI/sapdata4/ecc_122/ecc.data122 is available but still i am facing a same problame after restart.

Regards

Sumit.

[stefan_koehler]

Hello Sumit,

are the permissions correct (thats why i posted the ls command above)?

Please post the DBWR trace file.

Regards

Stefan

[Former Member]

Hi Stefan,

Please find below the DBWR trace file.

/oracle/AWI/saptrace/background/ecc_dbw0_1204420.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

ORACLE_HOME = /oracle/AWI/102_64

System name: AIX

Node name: XXXXXXXXXX

Release: 3

Version: 5

Machine: 00040F2DD600

Instance name: AWI

Redo thread mounted by this instance: 1

Oracle process number: 5

Unix process pid: 1204420, image: oracle@xxxxxxxxx (DBW0)

• SERVICE NAME:() 2009-02-07 22:08:10.315

• SESSION ID:(93.1) 2009-02-07 22:08:10.315

ORA-01157: cannot identify/lock data file 116 - see DBWR trace file

ORA-01110: data file 116: '/oracle/AWI/sapdata4/ecc_122/ecc.data122'

ORA-27041: unable to open file

IBM AIX RISC System/6000 Error: 22: Invalid argument

Additional information: 2

ORA-01157: cannot identify/lock data file 117 - see DBWR trace file

ORA-01110: data file 117: '/oracle/AWI/sapdata3/ecc_114/ecc.data114'

ORA-27041: unable to open file

IBM AIX RISC System/6000 Error: 22: Invalid argument

Additional information: 2

Regards

Sumit.

Edited by: Sumit Gupta on Mar 16, 2009 1:58 PM