Oracle Error 1115 Encountered
19 December 2003 00:34 Mohammad Shakir Messages: 3Registered: May 2003 Junior Member we are using sco unix 5.0.4 and oracle 7.2. when we make export for a user, export show this error EXP-00008: ORACLE error 1115 encountered ORA-01115: IO error reading block from file 18 (block # 38338) ORA-01110: data file 18: '/home/sysgatho3.dbf' ORA-07373: sfrfb: read returned incorrect number of bytes. Additional information: 38338 Additional information: 55296 anybody will help me how I can slove this problem ? Report message to a moderator Re: Oracle Error 1115 encountere [message #98044 is a reply to message #98043] Fri, 19 December 2003 02:23 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator ask the unix admin to check the disk....possible disk corruption. in os level, try to copy the files . iF it whines, it is to do with hardware/OS. Report message to a moderator Re: Oracle Error 1115 encountere [message #98045 is a reply to message #98044] Fri, 19 December 2003 23:47 Mohammad Shakir Messages: 3Registered: May 2003 Junior Member I have checked that hard disk has bad sector. Can I change/recover that file from bad sector ? Report message to a moderator Re: Oracle Error 1115 encountere [message #98046 is a reply to message #98045] Sat, 20 December 2003 02:39 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator fix the disk. restore the database from ur backup. Report message to a moderator Error: Oracle error occured but error could not be reterived from oracle [message #98110 is a reply to message #98045] Sat, 28 February 2004 09:18 Ashu Goel Messages: 2Registered: February 2004 Junior Member error: Oracle error occured but error could not be reterived from oracle. This error occurs sometimes when i run the application. It just occurs while making the connection between VB6.0 and Oracle8i. The connectivity string is : cnn.O
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich http://www.orafaq.com/forum/t/37190/ Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/rollback-segment-corruption-and-ora1115-245600 problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Rollback Segment Corruption and ORA-1115 Unknown User asked Apr 18, 2003 Thanks for you reply but i have larger datafiles going up to 6GB for data tablespaces but i have only experienced the problem randomly, my database is also stuck with the error below of trying
GoogleВойтиСкрытые поляПоиск групп или сообщений
error 27091appeard:. . exporting table MHNKEXP-00008: ORACLE error 1115 encounteredORA-01115: IO error reading block from file 1 (block #13095)ORA-01110: data file 1:'/oracle/DEV/sapdata1/system_1/system.data1'ORA-27091: skgfqio: unable to queue I/OIBM AIX RISC System/6000 Error: 5: I/O errorAdditional information: 13094. exporting table MHNKAEXP-00008: ORACLE error 1115 encounteredORA-01115: IO error reading block from file 1 (block #13095)ORA-01110: data file 1:'/oracle/DEV/sapdata1/system_1/system.data1'ORA-27091: skgfqio: unable to queue I/OIBM AIX RISC System/6000 Error: 5: I/O errorAdditional information: 13094i checked the table, no record.and no such 27091 message in alertsid.log.i checked dba_extents, with block_id between 13094 and13096, the table is a SAPR3 table:agr_1250? isn't asystem table!i run dbverify and it reported error message:DEV_SVC:oradev 13> dbv file=system.data1blocksize=8192DBVERIFY: Release 8.1.7.0.0 - Production on Sun Sep 216:49:10 2001(c) Copyright 2000 Oracle Corporation. All rightsreserved.DBVERIFY - Verification starting : FILE = system.data1DBV-00102: File I/O error on FILE (system.data1)during verification read operation (-2)so, it seems the datafile has corrupted, and i do notknow when it corrupted.Shall i just recreate the tables affected, orrestore the database.If restore, when to begin? I do not know when itcorrupted, since no error message in alertsid.log?And now i cannot backup the corrupted datafile,neither through cp or dd.It always abort at the middleof the datafile.thanks.Do You Yahoo!? µÇ¼Ãâ·ÑÑÅ»¢µçÓÊ! http://mail.yahoo.com.cnÎÞÁÄ£¿ÓôÃÆ£¿¸ßÐË£¿Ã»ÀíÓÉ£¿&par