| Oracle Shuts down automatically [message #278213] |
Fri, 02 November 2007 07:06  |
ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore
|
Member |
|
|
Hi,
I installed oracle10g(R2) for a german client, it went on well, but daily oracle shuts down automatically. (dont know at what time).
Next day, when I try to connect to oracle it shows "Oracle Shared memory realm doesnot exist", again I have to restart the oracle, after that it is working fine and next day again it shuts down. I tried re-installing also.
How it's happening?
Why it's happening?
Thank you.
bye
Karthik,
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Oracle Shuts down automatically [message #278232 is a reply to message #278228] |
Fri, 02 November 2007 07:57  |
 |
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Thu Nov 01 23:08:02 2007
KCF: write/open error block=0x11d3 online=1
file=1 C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
error=27072 txt: 'OSD-04008: WriteFile()-Fehler, in Datei kann nicht geschrieben werden
O/S-Error: (OS 33) Der Prozess kann nicht auf die Datei zugreifen, da ein anderer Prozess einen Teil der Datei gesperrt hat.'
Thu Nov 01 23:08:02 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_8488.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 1 (block # 4563)
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'
ORA-27072: File I/O error
OSD-04008: WriteFile()-Fehler, in Datei kann nicht geschrieben werden
O/S-Error: (OS 33) Der Prozess kann nicht auf die Datei zugreifen, da ein anderer Prozess einen Teil der Datei gesperrt hat.
I don't know what this means but it is surely not good.
But now your database is up and running, I advice you to execute a "dbverify" (search for this, or "dbv", in documentation) on the file.
Regards
Michel
|
|
|
|
|
|
| Re: Oracle Shuts down automatically [message #278250 is a reply to message #278243] |
Fri, 02 November 2007 10:07 |
|
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
| Quote: |
I dont know when it will shuts down
|
Sooner or later as you have an error (but only you know which one it is as you don't translate the message).
Investigate on the error and execute dbverify.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
