Re: weekend-fun with 11.2.0.2

From: Jeremiah Wilton <jwilton_at_bluegecko.net>
Date: Fri, 17 Dec 2010 09:57:40 -0800
Message-Id: <6A8BA51F-B59C-40CC-B0E4-1E7A246779AA_at_bluegecko.net>

On Dec 17, 2010, at 9:29 AM, Martin Berger wrote:

> If anyone want to have fun, just run this simple testcase:
> use your 11.2.0.2 rdbms binaries (linux and hp-ux tested, but others
> will also work).
>
> create a small pfile:
>
> db_name=test
> db_block_size=2048
> db_create_file_dest=/tmp
>
> set any ORACLE SID and run
>
> create database character set al32utf8;
>
> I'd like to see your results ;-)
> (I can give some more infos, do not waste time for investigations)

Wow that's broken. 2K block size doesn't really seem like much of an edge case. 8k block size works fine, but you already know that.

SQL> create database character set al32utf8; create database character set al32utf8
*
ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/doptim.bsq' near  

line 416

ORA-00604: error occurred at recursive SQL level 1
ORA-01429: Index-Organized Table: no data segment to store overflow  
row-pieces

Process ID: 2246
Session ID: 87 Serial number: 3

Removed db_block_size from the pfile, and"

SQL> create database character set al32utf8;

Database created.

--
Jeremiah Wilton
http://www.bluegecko.net




--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 17 2010 - 11:57:40 CST