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

Report message to a moderator

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?

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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?

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes, I posted Frank in "Feedback and Suggestion" forum.

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Alter System
Next Topic: Dropping redolog group
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 05:57:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.