Re: Oracle write timeouts

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 9 Apr 1998 16:55:15 -0700
Message-ID: <6gjn53$67n$1@pebble.ml.org>

In article <6ghfap$o1s_at_gsms01.alcatel.com.au>, Peter Jeremy <jeremyp_at_gsms01.alcatel.com.au> wrote:
>For various reasons, I would like to be able to write lock the
>filesystems containing an Oracle database (for a few seconds).
>Unfortunately, Oracle does not appreciate this and LGWR dies with the
>following messages:
>
>error 221 detected in background process
>OPIRIP: Uncaught error 447. Error stack:
>ORA-00447: fatal error in background process
>ORA-00221: error on write to control file
>ORA-00206: error in writing control file '/opt/oracle/v716/dbs/c_001_omc.dbf' (block 33, # blocks 1)
>ORA-07376: sfwfb: write error, unable to write database block.
>SVR4 Error: 62: Timer expired
>Additional information: -1
>Additional information: 1
>ORA-00345: redo log write error block 3449 count 1
>ORA-00312: online log 5 thread 1: '/opt/oracle/v716/dbs/l_005_omc.dbf'
>ORA-07376: sfwfb: write error, unable to write database block.
>SVR4 Error: 62: Timer expired
>Additional information: -1
>Additional information: 1
>
>Can anyone suggest a way to either
>1) extend the timeout associated with whatever timer is expiring in the
> above.
>2) freeze Oracle for a few seconds without disrupting the applications
> logged into Oracle (the delay is unimportant to them).
>
>I'm using Oracle 7.1.6 (but may be moving to 7.3.2) on Solaris 2.5.1

alter system enable restricted session; although it lets people keep working. See the Administrator's Guide for more details.

Perhaps if we knew the reasons you want to do this we could give a better answer.

>
>Peter
>--
>Peter Jeremy (VK2PJ) peter.jeremy_at_alcatel.com.au
>Alcatel Australia Limited
>41 Mandible St Phone: +61 2 9690 5019
>ALEXANDRIA NSW 2015 Fax: +61 2 9690 5247

--
These opinions are my own and not necessarily those of Information Quest

jgarry@eiq.com                           http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA! Received on Thu Apr 09 1998 - 18:55:15 CDT