ORA-7497:LGWR dies, O7.1.3,SS10 OS 4.1.3
Date: 4 Jan 1995 05:20:33 GMT
Message-ID: <3edb71$m63_at_lynx.unm.edu>
Our database is crashing due to the LGWR process termination. The only error message available (ORA-7497) says that the LGWR process cannot create the trace file. All other proecesses are writing trace information to the directory specified in init.ora parameter BACKGROUND_DUMP_DEST, so permissions are correct. The LGWR process has not written to a trace file since this problem began. A log switch will inevitably cause a crash.
Typical error in alert log or trace file :
ORA-00603: ORACLE server session terminated by fatal error ORA-00449: background process 'LGWR' unexpectedly terminated with error 7497 ORA-07497: sdpri: cannot create trace file ''; errno = . ORA-01092: ORACLE instance terminated. Disconnection forced
Server Information
Oracle Server : 7.1.3.0.0
H/W : Sun Sparc 10
OS : SunOS 4.1.3
No. CPUs : 2
Log Files : 3 groups with 3 members
Log File Size : 10M
NOFILES : 256
NOFILE_IN_U : 64
Has anyone encountered a similar situation?
Follow-up this article or email to
psfield_at_archie.lanl.gov.
Any suggestions will be appreciated.
Phil Fielder
Los Alamos Nat. Lab
505.665.3227
Received on Wed Jan 04 1995 - 06:20:33 CET