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@xxxxxxxxxxxxxxxxxxx http://www.opitz-consulting.ch OCP 9i/10g SCSA SCNA ========================= On Sat, Nov 22, 2008 at 10:09 PM, Andre van Winssen <dreveewee@xxxxxxxxx>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@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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *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@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@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@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@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@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@xxxxxxxxxxxxxxxxxxx > http://www.opitz-consulting.ch > > OCP 9i/10g SCSA SCNA > ========================= >