Re: ORA-01115 IO errors


"DA Morgan" <damorgan@xxxxxxxxx> wrote in message
news:1183213090.514261@xxxxxxxxxxxxxxxxxxxxxxxxx
Gerald Sinkiewicz wrote:
Somewhat strange ORA-01115 IO errors appearing in client software logs,
not alert.log though?
Metalink indicates hardware problems and implies that indeed these
messages may not appear in the alert.log.

Anyway one of the messages in the chain contains:

"IBM AIX RISC System/6000 Error:1: Not onwer"

I have not been able to find an explaination of "Error:1" via metalink,
google, or altavista, and cannot find
an appropriate IBM reference (I believe the box is a P55 or P550 running
AIX5L 5.3).

You might ask if I have checked the ownership of the file (which is file
10 by the way) and I assure you it is
properly owned by oracle:dba and always has been. The error is
intermittent.

I have the SAN guys looking through their logs, but my real question is
does that IBM error 1 indicate what
I think it does and somehow ownership of file 10 is at times in flux for
whatever reason?

Highly unlikely that the O/S thinks file ownership is in flux. But from
what you've posted the dots do not connect.

The error message you typed, not copied (obvious from the misspelling)
gives no indication of why you think anything relates to file 10 or what
it is you think is file 10. Hopefully you don't think AIX is reading the
file# from file$.

The error is an operating system error, not an Oracle error. And the
last time I worked with AIX files had names ... not numbers. Please
connect the dots with cut-and-paste not your interpretation. Perhaps
then we can help you.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

I did not cut an paste because I am an home (news groups are forbidden at
work).
The ORA-01115 references file 10. I cannot post file names.
Ah, I did misspell "owner" and there are other messages related to the
ORA-01115 that really just
say Oracle could not read a certain block in file 10....
The only message that is not an Oracle message is the AIX one I mistyped.

The root cause is probably related to the SAN, but it could also be an AIX
bug? I would bet on the SAN switch
being the problem. The errpt shows SAN disk errors up to Jun 14, but not on
June 27 when the "Error:1: Not owner"
error showed up in the application (client software) logs.

Really I am just wondering if anyone has seen that "Error: 1" before. There
are numerous examples in google of "Error: 2"
which indicates a named file does not exist.


.

Relevant Pages

  • W2 HP UX Admin positions (ServiceGuard & Omniback) - NY and Central NJ
    ... San ... Oracle ... AIX ... Production support ...
    (comp.sys.hp.hpux)
  • Re: Cannot run a 64 bit program on a 32 bit processor
    ... For Oracle 9i and your questions about setting up AIX in 32-bit mode, ... As for Tuxedo, I only did the install once, but don't remember it ... Use the CIO mount option for JFS2 filesystems containing Oracle data ...
    (comp.unix.aix)
  • Re: AIX Performance issue
    ... however approx 30 users normally access AIX server ... > through oracle application, every thing was running fine during last 3 ... > sar and lpstat command and their output was as given below. ... > Mostly when error occurred our database daily backup was in process ...
    (comp.unix.aix)
  • Re: How to enable 64 bit environment on AIX 4.3.3
    ... oracle versions can run under which AIX versions. ... How to enable 64 bit environment on AIX 4.3.3 ... bos.64bit fileset is on the 4.3.x media, however, installing it does not ...
    (AIX-L)
  • Re: Oracle 9i RAC, AIX and GPFS
    ... Oracle 9i RAC, AIX and GPFS ... Have you considered not using the GPFS component and substituting raw lv's? ... We have a similar environment, 2x p690s, similar versions of AIX and Oracle. ...
    (AIX-L)