Ora-01115 Ora-01110 Ora-27091 Ora-27072 Error 5 I/o Error
Contents |
random IO error [message #394850] Mon, 30 March 2009 09:57 blake.hall Messages: 3Registered: March 2009 Location: Baytown, Texas Junior Member I have a production AIX database server with 8 production 7X24 ora-27072: file i/o error linux-x86_64 error: 5: input/output error instances. On only one of the 8 instances, randomly a scheduled procedure fails
Ora-01115 Ora-01110 Ora-27072
with these errors: ORA-01115: IO error reading block from file 10 (block # 94006) ORA-01110: data file 10: '/u05/oracle/bupurp/aap_data.dbf'
Ora-01115 Io Error Reading Block From File (block # )
ORA-27091: skgfqio: unable to queue I/O ORA-27072: skgfdisp: I/O error IBM AIX RISC System/6000 Error: 5: I/O error The procedure populates a table with data from 2 local tables and a linked
Ora-27072 Skgfdisp I/o Error
database table. Oracle recommends upgrading the AIX to the newest patch level -we are at the most current patch level.... and applying an Oracle database patch {5496862}. Unfortunately all 8 production instances will have to be patched, since all are on the same Oracle home. Not that I don't want to do the work, but I am looking for alternatives to applying this patch to these high activity instances, to minimize downtime. Has anyone had a similar situation and found another approach? On one forum I saw a similar post and the recommended solution was to move the tablespace file to a different drive, on a different controller. Thanks in advance for your help! Report message to a moderator Re: AIX random IO error [message #394856 is a reply to message #394850] Mon, 30 March 2009 10:12 ThomasG Messages: 3186Registered: April 2005 Location: Heilbronn, Germany Senior Member Have you checked on the OS side if there are any errors, or any limits placed on the Oracle user account? (ulimit) Have you checked if there are any errors in the system log or STALE PPs in the disk volume group? (errpt / lsvg) Report message to a moderator Re: AIX random IO error [message #394885 is a reply to message #394850] Mon, 30 March 2009 13:17 blake.hall Messages: 3Registered: March 2009 Location: Baytown, Texas Junior Member No limitations on the Oracle user in the OS. [response was unlimited] No obvious errors on the error report... response below: /home/eyaba> errp
Thanks for the question, Vicente. Asked: January 23, 2016 - 6:35 am UTC Answered by: Connor McDonald � Last updated: January 26, 2016 - 12:54 am UTC Category: Database � Version: Oracle 9i (9.2.0.6.0) Whilst you are here, check out some content from the AskTom team: KISS video series for Analytic functions Latest Followup You Asked Operating system AIX 5.2 64bits Hello there. I have tried to uninstall/install JAVAVM because I have obtain the following error when I was doing a full database export: Connected to: Oracle9i Enterprise http://www.orafaq.com/forum/t/142856/ Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production Export done in US7ASCII character set and AL16UTF16 NCHAR character set About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles . exporting resource costs https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9525710200346446539 . exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context namespaces . exporting foreign function library names . exporting PUBLIC type synonyms EXP-00008: ORACLE error 29516 encountered ORA-29516: Aurora assertion failure: Assertion failure at joevm.c:3129 Unable to locate well known object: 22 EXP-00000: Export terminated unsuccessfully Trying to uninstall/install the JAVAVM I have the following error: DOC>####################################################################### DOC>####################################################################### DOC> The following statement may cause an DOC> ORA-29554: unhandled Java out of memory condition DOC> error, and thereby terminate the sqlplus connection. DOC> If so, this is because there is insufficient system tablespace, DOC> shared or java pool size, or some other resource value is too small. DOC> An additional message describing the problem will be output by DOC> the statement. DOC>####################################################################### DOC>####################################################################### DOC>*/ SQL> execute initjvmaux.check_sizes_for_cjs; alter system flush shared_pool BEGIN initjvmaux.check_sizes_for_cjs; END; * ERROR at line 1: ORA-01115: IO error reading block from file 1 (block # 93463) ORA-01110: data file 1: '/ORADATA/DATA/system_01.dbf' ORA-27091: skgfqio: una
PDSERVICE's blog > ORA-01115 ORA-01110:system01.dbf Oracle OS http://www.parnassusdata.com/en/node/645 corrupted ORA-01115 ORA-01110:system01.dbf Oracle OS corrupted ORA-01115 ORA-01110:system01.dbf Oracle OS corrupted Posted by PDSERVICE on Mar 21, 2016 In If you cannot recover data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help. Parnassusdata i/o error Software Database Recovery Team Service Hotline: +86 13764045638 E-mail: service@parnassusdata.com Database has been forced to open with _allow_resetlogs_corruption and _corrupted_rollback_segments Now we are trying to export all the data to recreate database, export fails with: Connected to: Oracle ora-01115 ora-01110 ora-27091 Database 10g Release 10.2.0.4.0 - 64bit Production ORA-31626: job does not exist ORA-31633: unable to create master table "SYS.SYS_EXPORT_SCHEMA_05" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 871 ORA-01115: IO error reading block from file 1 (block # 68730) ORA-01110: data file 1: '/pelican/PELICAN/system01.dbf' ORA-27091: unable to queue I/O ORA-27072: File I/O error IBM AIX RISC System/6000 Error: 110: Media surface error Additional information: 7 Additional information: 68729 Additional information: -1 ora10g4S@(/pelican/PELICAN)$ /orahome/ora10204s/bin/dbv file=system01.dbf feedback=100 DBVERIFY: Release 10.2.0.4.0 - Production on Wed Aug 14 12:50:05 2013 Copyright (c) 1982, 2007, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = system01.dbf ................................................................................ ................................................................................ ................................................................................ ................................................................................ ................................................................................ ................................................................................ .......