| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: SVR4 Bad Address and kccexpd error in Oracle control file
Combine the two error messages and check through Support, and you'll see the
following information:
Article-ID: <PR:1059389.6> Circulation: PUBLISHED (EXTERNAL) Platform: GENERIC Folder: server.Rdbms.misc Area: RDBMS Subject: ORA-00202 ORA-27044 IN ALERT LOG Component: RDBMS_V08.00.XX
Problem Description:
When you manually switch redo logs, or when the log buffer causes the redo threads to switch, you see errors similar to the following in your alert log:
...
Fri Apr 24 13:42:00 1998
Thread 1 advanced to log sequence 170
Current log# 4 seq# 170 mem# 0: /.../rdlACPT04.rdl
Fri Apr 24 13:42:04 1998
Errors in file /.../acpt_arch_15973.trc:
ORA-202: controlfile: '/.../ctlACPT01.dbf'
ORA-27044: unable to write the header block of file
SVR4 Error: 48: Operation not supported
Additional information: 3
Fri Apr 24 13:42:04 1998
kccexpd: controlfile resize from 356 to 368 block(s) denied by OS
...
Note: The particular SVR4 error observed may differ in your case and is
irrelevant here.
ORA-00202: "controlfile: '%s'"
Cause: This message reports the name file involved in other messages.
Action: See associated error messages for a description of the problem.
ORA-27044: "unable to write the header block of file"
Cause: write system call failed, additional information indicates
which function encountered the error Action: check errno
Problem Explanation:
This is bug 663726, which is fixed in release 8.0.6.
The write of a 16K buffer to a control file seems to fail during an implicit resize operation on the controlfile that came as a result of adding log history records (V$LOG_HISTORY) when archiving an online redo log after a log switch.
HTH. Pete
hcchan_at_ziplink.net wrote:
> Hi,
>
> We are getting the following error messages from Oracle's
> "alog" output. This is a daily status log and we were
> not doing any database reorg work when the error occurred.
> It's complaining about bad address in SVR4 and resize denial by O.S.
> I am very perplexed with the message. Luckily we have a copy of the control
> files resided on another disk to recover from.
> Has anyone experienced this before ??
>
> Here's our system configuration:
>
> System: Sun Enterprise 3500 w/ 2 A5000 disk arrays
> OS : Solaris 2.6
> Oracle: 8.0.4.2.1
> Veritas File System: 3.2.6
> Veritas Volume Manager: 2.5
>
> "alog" file output in Oracle
> ========================================================================
> :
> :
> Thread 1 advanced to log sequence 981
> Current log# 4 seq# 981 mem# 0: /g1_u03pr/oradata/gppr/redogppr04.log
> Wed Apr 21 08:00:03 1999
> Errors in file /g1_u01pr/app/g1orapr/admin/gppr/bdump/gppr_arch_923.trc:
> ORA-00202: controlfile: '/g1_u01pr/oradata/gppr/control01.ctl'
> ORA-27044: unable to write the header block of file
> SVR4 Error: 14: Bad address
> Additional information: 4
> Wed Apr 21 08:00:03 1999
> kccexpd: controlfile resize from 124 to 182 block(s) denied by OS
> krcpwnc: following controlfile record written over:
> RECID #218 Recno 218 Record timestamp
> 12/30/99 18:29:39
> Thread=1 Seq#=168
> Flags:
> Resetlogs scn and time
> scn: 0x0000.00161140
> 12/04/98 13:19:53
> filename /g1_u01pr/app/g1orapr/admin/gppr/arch/1_168.dbf
> Low
> scn: 0x0000.00241f80
> 01/25/99 10:53:09
> Next
> scn: 0x0000.00243ba9
> 12/30/99 18:29:37
> Block count=32762 Blocksize=512
> Wed Apr 21 10:10:32 1999
> Thread 1 advanced to log sequence 982
> Current log# 5 seq# 982 mem# 0: /g1_u03pr/oradata/gppr/redogppr05.log
> Wed Apr 21 10:10:34 1999
> Errors in file /g1_u01pr/app/g1orapr/admin/gppr/bdump/gppr_arch_923.trc:
> ORA-00202: controlfile: '/g1_u01pr/oradata/gppr/control01.ctl'
> ORA-27044: unable to write the header block of file
> SVR4 Error: 14: Bad address
> Additional information: 4
> Wed Apr 21 10:10:34 1999
> kccexpd: controlfile resize from 124 to 182 block(s) denied by OS
> krcpwnc: following controlfile record written over:
> RECID #219 Recno 219 Record timestamp
> 12/30/99 18:31:04
> Thread=1 Seq#=169
> Flags:
> Resetlogs scn and time
> scn: 0x0000.00161140
> 12/04/98 13:19:53
> filename /g1_u01pr/app/g1orapr/admin/gppr/arch/1_169.dbf
> Low
> scn: 0x0000.00243ba9
> 12/30/99 18:29:37
> Next
> scn: 0x0000.002452df
> 12/30/99 18:31:03
> Block count=32768 Blocksize=512
> Wed Apr 21 11:26:28 1999
> Thread 1 advanced to log sequence 983
> Current log# 6 seq# 983 mem# 0: /g1_u03pr/oradata/gppr/redogppr06.log
> Wed Apr 21 11:26:30 1999
> Errors in file /g1_u01pr/app/g1orapr/admin/gppr/bdump/gppr_arch_923.trc:
> ORA-00202: controlfile: '/g1_u01pr/oradata/gppr/control01.ctl'
> ORA-27044: unable to write the header block of file
> SVR4 Error: 14: Bad address
> Additional information: 4
> Wed Apr 21 11:26:30 1999
> kccexpd: controlfile resize from 124 to 182 block(s) denied by OS
> krcpwnc: following controlfile record written over:
> RECID #220 Recno 220 Record timestamp
> 12/30/99 18:32:29
> Thread=1 Seq#=170
> Flags:
> Resetlogs scn and time
> scn: 0x0000.00161140
> 12/04/98 13:19:53
> filename /g1_u01pr/app/g1orapr/admin/gppr/arch/1_170.dbf
> Low
> scn: 0x0000.002452df
> 12/30/99 18:31:03
> Next
> scn: 0x0000.00246886
> 12/30/99 18:32:27
> Block count=32768 Blocksize=512
> Wed Apr 21 11:40:34 1999
> alter tablespace gpprsd07 coalesce
> Wed Apr 21 11:40:34 1999
> Completed: alter tablespace gpprsd07 coalesce
> Wed Apr 21 11:40:34 1999
> :
> :
> ==================================================================
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
--
Regards
Pete
Peter Sharman Email: psharman_at_us.oracle.com WISE Course Development Manager Phone: +1.650.607.0109 (int'l) Worldwide Internal Services Education (650)607 0109 (local)San Francisco
SQL> select standard_disclaimer, witty_remark 2 from company_requirements;
Opinions are mine and do not necessarily reflect those of Oracle Corporation
"Controlling application developers is like herding cats."
Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!"
Bruce Pihlamae, long term ORACLE DBA
Received on Wed Apr 21 1999 - 16:26:00 CDT
 |
 |