From: sstefick (sstefick@HARPER.CC.IL.US)
Date: Sat Nov 16 2002 - 10:46:34 EST
Not sure why there is a difference (2 and 3) when you run watch. I did a
search on Metalink and found the following:
Doc ID: Note:1013601.102
Subject: ORA-03113, ORA-07445: DURING INSTANCE STARTUP
Do you have an account on Metalink? If not, let me know and I can copy and
paste the text of the Note in the email for you. It looks like they have a
different suggestion.
-Scott
>===== Original Message From IBM AIX Discussion List <aix-l@Princeton.EDU>
=====
>i use watch to watch the differences between the 2 instances
>
>where it works i see
>
>FILE_Open tgdspur1 FAIL Sat Nov 16 16:00:52 2002 oracle
> flags: 67110146 mode: 660 fd: 11 filename
>/prod/oracle/ora817/dbs/lkPFMSO
>***** WATCH *****
>event login status time command
>--------------- -------- ----------- ------------------------
>-------------------------------
>FILE_Open tgdspur1 FAIL Sat Nov 16 16:00:52 2002 oracle
> flags: 67110146 mode: 660 fd: 11 filename
>/prod/oracle/ora817/dbs/lkPFMSO
>***** WATCH *****
>event login status time command
>--------------- -------- ----------- ------------------------
>-------------------------------
>FILE_Open tgdspur1 OK Sat Nov 16 16:00:52 2002 oracle
> flags: 67108866 mode: 0 fd: 11 filename
>/prod/oracle/ora817/dbs/lkPFMSO
>
>
>where it does not work I see
>FILE_Open tgdspur1 FAIL Sat Nov 16 15:55:40 2002 oracle
> flags: 67110146 mode: 660 fd: 11 filename
>/prod/oracle/ora817/dbs/lkPFMSR
>***** WATCH *****
>event login status time command
>--------------- -------- ----------- ------------------------
>-------------------------------
>FILE_Open tgdspur1 OK Sat Nov 16 15:55:40 2002 oracle
> flags: 67108866 mode: 0 fd: 11 filename
>/prod/oracle/ora817/dbs/lkPFMSR
>
>ok, after all its the same... the file gets openen with mode 0. just
>wondering why it needs 3 where it does work (PFMSO) and 2 where it
>doesnt (PFMSR)
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:21 EDT