Re: Setting db_32k_cache_size breaks 11.1.0.7

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Sat, 22 Nov 2008 22:59:38 +0100
Message-ID: <486b2b610811221359i20d92b06qc6c1768af0797622@mail.gmail.com>


I filed an SR this afternoon.

Are you on 32-bit linux as well ?

Stefan


Stefan P Knecht
Senior Consultant
Systems Engineering

OPITZ CONSULTING Schweiz GmbH
Seestrasse 97
CH-8800 Thalwil

Mobile +41-79-571 36 27
stefan.knecht_at_opitz-consulting.ch
http://www.opitz-consulting.ch

OCP 9i/10g SCSA SCNA


On Sat, Nov 22, 2008 at 10:09 PM, Andre van Winssen <dreveewee_at_gmail.com>wrote:

> I can confirm this. alter system set db_32k_cache_size=12M scope=memory;
> crashed my (test) database. Could only be opened with startup force. See
> below:
>
>
>
> alter system set db_32k_cache_size=12M scope=memory
>
> *
>
> FOUT in regel 1:
>
> .ORA-02097: Parameter kan niet worden gewijzigd omdat gespecificeerde
> waarde
>
> ongeldig is.
>
> ORA-00382: 32768 geen geldige blokgrootte, geldig bereik [..]
>
>
>
>
>
> SQL> exit
>
> Verbinding met Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 -
> Production
>
> With the Partitioning, Oracle Label Security, OLAP, Data Mining
>
> and Real Application Testing options is verbroken.
>
>
>
> C:\LinuxRac>sqlplus system/xxxx_at_rhel5a/v1110
>
>
>
> SQL*Plus: Release 11.1.0.6.0 - Production on Za Nov 22 22:02:52 2008
>
>
>
> Copyright (c) 1982, 2007, Oracle. All rights reserved.
>
>
>
> ERROR:
>
> ORA-12537: TNS:verbinding is gesloten.
>
>
>
> Startup force required.
>
> .
>
>
>
> This is bad, needs to be fixed asap by Oracle.
>
>
>
> Regards,
>
> Andre
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Stefan Knecht
> *Sent:* zaterdag 22 november 2008 14:57
> *To:* oracle-l
> *Subject:* Setting db_32k_cache_size breaks 11.1.0.7
>
>
>
> Hello all
>
> I stumbled accross this today:
>
> oracle_at_m:~/ [M] sq
>
> SQL*Plus: Release 11.1.0.7.0 - Production on Sat Nov 22 14:55:03 2008
>
> Copyright (c) 1982, 2008, Oracle. All rights reserved.
>
> Connected.
> idle> startup force;
> ORACLE instance started.
>
> Total System Global Area 2142679040 bytes
> Fixed Size 1314580 bytes
> Variable Size 1325400300 bytes
> Database Buffers 805306368 bytes
> Redo Buffers 10657792 bytes
> Database mounted.
> Database opened.
> idle>
> idle> Disconnected from Oracle Database 11g Enterprise Edition Release
> 11.1.0.7.0 - Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
> oracle_at_m:~/ [M] sqlplus system
>
> SQL*Plus: Release 11.1.0.7.0 - Production on Sat Nov 22 14:55:25 2008
>
> Copyright (c) 1982, 2008, Oracle. All rights reserved.
>
> Enter password:
>
> Connected to:
> Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
>
> system_at_M> alter system set db_32k_cache_size=100m;
> alter system set db_32k_cache_size=100m
> *
> ERROR at line 1:
> ORA-02097: parameter cannot be modified because specified value is invalid
> ORA-00382: 32768 not a valid block size, valid range [..]
>
>
> system_at_M> Disconnected from Oracle Database 11g Enterprise Edition Release
> 11.1.0.7.0 - Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
> oracle_at_m:~/ [M] sqlplus system
>
> SQL*Plus: Release 11.1.0.7.0 - Production on Sat Nov 22 14:55:41 2008
>
> Copyright (c) 1982, 2008, Oracle. All rights reserved.
>
> Enter password:
> ERROR:
> ORA-00382: %s not a valid block size, valid range [%s..%s]
>
>
>
>
> Could be pretty devastating if this happens to someone in production. You
> can't connect at all anymore, only thing that helps is a startup force...
>
> Filing SR :)
>
> Have a nice weekend
>
> Stefan
>
>
>
>
> =========================
>
> Stefan P Knecht
> Senior Consultant
> Systems Engineering
>
> OPITZ CONSULTING Schweiz GmbH
> Seestrasse 97
> CH-8800 Thalwil
>
> Mobile +41-79-571 36 27
> stefan.knecht_at_opitz-consulting.ch
> http://www.opitz-consulting.ch
>
> OCP 9i/10g SCSA SCNA
> =========================
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Nov 22 2008 - 15:59:38 CST

Original text of this message