RE: Setting db_32k_cache_size breaks 11.1.0.7
Date: Sat, 22 Nov 2008 22:09:19 +0100
Message-ID: <001e01c94ce6$97055d30$c5101790$@com>
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 bytesDatabase 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-lReceived on Sat Nov 22 2008 - 15:09:19 CST