Oracle Error 1242
due to error 1242"What could be reason let me know.I am using 8.1.7 on solarisThanks-SeemaGet your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Seema SinghINET: oracledbam_at_hotmail.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). reply Tweet Search Discussions Search All Groups oracle-l 1 response Oldest Nested Christopher Spence Ora-1242 is a media error, I would check the checkpoint process trace file for other symptons. Also look for other process id's in the trace file. Can you restart the database? I suspect you are going to have to do a restore. I am going to guess you are not in archive log mode due to the error message. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -----Original Message----- Sent: Friday, July 20, 2001 11:56 Christopher Spence at Jul 20, 2001 at 4:14 pm ⇧ Ora-1242 is a media error, I would check the checkpoint process trace filefor other symptons. Also look for other process id's in the trace file.Can you restart the database? I suspect you are going to have to do arestore. I am going to guess you are not in archive log mode due to theerror message."Walking on water and developing software from a specification are easy ifboth are frozen."Christopher R. SpenceOracle DBAFuelspot-----Original Message-----Sent: Friday, July 20, 2001 11:56 AMTo: Multiple recipients of list ORACLE-LHiMy database is down with following error."CKPT:terminating instance due to error 1242"What could be reason let me know.I am using 8.1.7 on solaris Thanks -SeemaGet your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Seema SinghINET: oracledbam_a
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: Oracle Error Message Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-18-2000,02:45 PM #1 sureshgane View http://grokbase.com/t/freelists.org/oracle-l/017me4pk19/instance-down-due-to-error-1242 Profile View Forum Posts Junior Member Join Date Sep 2000 Posts 56 I am getting the following error when the database is going down KCF: write/open error block=0x3bc22 online=1 file=26 N:\ORACLE816\ORADATA\TEST\DATA11.ORA 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.' DBW0: terminating http://www.dbasupport.com/forums/showthread.php?5111-Oracle-Error-Message instance due to error 1242 Mon Dec 18 11:50:20 2000 Instance terminated by DBW0, pid = 381 Dump file o:\oracle816\admin\test\bdump\testALRT.LOG Bu when I stop the service & start the service I am able to access the database.Again after some more days the same message appears.Has anyone got any clue why it happens.If so what is the solution.All suggestions are welcome.How to keep the trace on Thanks Suresh Reply With Quote 12-18-2000,02:46 PM #2 sureshgane View Profile View Forum Posts Junior Member Join Date Sep 2000 Posts 56 OOPS THE DATABASE IS RUNNING ON WINDOWSN/T & ORACLE VERSION IS 8.1.6 Reply With Quote 12-18-2000,02:53 PM #3 sureshgane View Profile View Forum Posts Junior Member Join Date Sep 2000 Posts 56 Solution Or Help Needed These are the different error messages got in a span of 2 to 3 months.Please see that error message is same that is a portion of the file is locked only difference is that each time different files got locked Fri Oct 20 03:57:23 2000 Errors in file o:\oracle816\admin\test\bdump\testCKPT.TRC: ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: c
To search for your page, try our Search function. All Technology Network PartnerNetwork (Public Only) Video and Multimedia Refine Search RSS | Legal Notices and Terms for Use | Privacy Statement