The Oracle server is 184.108.40.206.0 running on w2k system crashed with this error message, "ckpt terminated 4030" in the alert log. Can someone tell me what could be wrong. It is a development server. At the time of crash only two users are connected. One user is connected using sqlplus, and the other user logged in thru an application which uses weblogic to connect to the dB.
04-17-2002, 11:29 PM
May be, due to lack of space in the destination that what u set for the archive log files to grow.
Or if u want to see the exact error
open and see the ckpt.trc file from background_dump_dest .
bye from saravanan.
04-18-2002, 01:16 AM
It might be due to corruption of Datafiles or Controlfiles too.
Checkout the trace file as said by Saran. Also check whether DBWR has generated
any trace files.
04-18-2002, 11:36 AM
There is nothing in the DBWR trc file. CKPT trc file has the following info
It looks like the plsql anonymous block has created this problem. Is there a way to avoid this kind of thing repeating.
The server is win2k and has 4Gig of memory and Oracle is configured to use around 1.1Gig. Any inputs will be apreciated. Thanks in advance.
error 4030 detected in background process.