Home » RDBMS Server » Server Administration » ORA-01157: ORA-01110:
ORA-01157: ORA-01110: [message #287676] Thu, 13 December 2007 02:35 Go to next message
ora_dilemma
Messages: 10
Registered: December 2007
Location: Universal
Junior Member
at the time of database startup

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 12 - see DBWR tra
ORA-01110: data file 12: 'C:\ORACLE\ORA92\DATABASE\PERPER'

without deleting datafile how can i resolve?

Before anybody describes:From the trace file i got,

*** SESSION ID:(2.1) 2007-12-13 11:43:21.000
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'C:\ORACLE\ORA92\DATABASE\PERPER'
ORA-27086: skgfglk: unable to lock file - already in use
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
ORA-01157: cannot identify/lock data file 14 - see DBWR trace file
ORA-01110: data file 14: 'C:\ORACLE\ORA92\DATABASE\PER'
ORA-27086: skgfglk: unable to lock file - already in use
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
ORA-01157: cannot identify/lock data file 15 - see DBWR trace file
ORA-01110: data file 15: 'C:\ORACLE\ORA92\DATABASE\TIME'
ORA-27086: skgfglk: unable to lock file - already in use
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

Thanks
Re: ORA-01157: ORA-01110: [message #287677 is a reply to message #287676] Thu, 13 December 2007 02:36 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

How this question is fit in Homework and Training Section?
Re: ORA-01157: ORA-01110: [message #287678 is a reply to message #287676] Thu, 13 December 2007 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

Check user that started the instance.
Privileges associated to this user on database file system.

Edit:
Quote:

ORA-27086: skgfglk: unable to lock file - already in use

Try to know who use the files.

Regards
Michel

[Updated on: Thu, 13 December 2007 02:39]

Report message to a moderator

Re: ORA-01157: ORA-01110: [message #287679 is a reply to message #287676] Thu, 13 December 2007 02:51 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

OP, post your OS as well as oracle database version while posting thread.
Re: ORA-01157: ORA-01110: [message #287680 is a reply to message #287679] Thu, 13 December 2007 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It was in the post header before moving it.
It seems we lose this information when we move the topic.
It was 9iR2(?) and XP.

Regards
Michel
Re: ORA-01157: ORA-01110: [message #287681 is a reply to message #287680] Thu, 13 December 2007 02:55 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>It seems we lose this information when we move the topic.
Yes micheal, it is correct. Same thing happen with us. Remeber?
Re: ORA-01157: ORA-01110: [message #287684 is a reply to message #287681] Thu, 13 December 2007 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, I posted Frank in "Feedback and Suggestion" forum.

Regards
Michel
Re: ORA-01157: ORA-01110: [message #287688 is a reply to message #287676] Thu, 13 December 2007 03:23 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I recall it. Good point. Thanks Michel.
Previous Topic: Alter System
Next Topic: Dropping redolog group
Goto Forum:
  


Current Time: Sat Dec 03 07:47:59 CST 2016

Total time taken to generate the page: 0.14917 seconds