Setting db_32k_cache_size breaks 11.1.0.7

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

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 - 07:57:22 CST