OraFAQ Forum: Server Administration » ORA-01157: ORA-01110:

Home » RDBMS Server » Server Administration » ORA-01157: ORA-01110:

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01157: ORA-01110: [message #287676]

Thu, 13 December 2007 02:35

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

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

Michel Cadot
Messages: 68686
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

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

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: ORA-01157: ORA-01110: [message #287681 is a reply to message #287680]

Thu, 13 December 2007 02:55

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

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 10:45:12 CDT 2024