automatically gone to offline [message #61897] |
Wed, 09 June 2004 02:02 |
anil kumar
Messages: 16 Registered: August 2002
|
Junior Member |
|
|
Hi
mine is production database,when i tried to connect to the database,it has shown "max processes 300 exceeded".actually no sessions were there.After i reboot the system i was able to login to the database but the users datafile(which we are using for our production DB) goes offline.i have recovered the datafile and made it online,now it is working fine.
In Alert file it is showing that
alert log info:
---------------------------
Mon Jun 07 20:19:44 2004
Errors in file E:oracleadmindbbdumptdSMON.TRC:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
Wed Jun 09 00:34:48 2004
KCF: write/open error block=0x15b3f2 online=1
file=8 E:ORACLEORADATAdbUSERS01.DBF
error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because
another process has locked a portion of the file.'
Automatic datafile offline due to write error on
file 8: E:ORACLEORADATAdbUSERS01.DBF
----------------------------------------
plz let me know ,why its all happened,i could not find the problem.
please help me in this context(its urgent).
|
|
|
|