RE: weekend-fun with 11.2.0.2

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Fri, 17 Dec 2010 12:52:19 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F61F49E62_at_AAPQMAILBX02V.proque.st>

Hi Martin,

Is this what you got?

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: 16723
Session ID: 47 Serial number: 1

My guess is that's not supposed to happen....? :)

Seems to be a combination of AL32UTF8 character set and 2k block size.....

Something else I noticed...I was going to play w/ various blocksizes, see if/when the above error occurred. if I recall correctly, Oracle used to allow you to set some really crazy block sizes. 1k, odd ball numbers, etc.

I just tried setting a 1k blocksize, and I got: SQL> startup nomount
ORA-00374: parameter db_block_size = 1024 invalid ; must be a multiple of 512 in the range [2048..32768]

on startup, so, (just for fun), I set a blocksize of 2560, which is in the range, and a multiple of 512. That was enough to get me past 'startup nomount', and get an instance up.

But, as soon as I tried 'create database', I got: SQL> create database character set al32utf8;

create database character set al32utf8
*
ERROR at line 1:
ORA-25157: Specified block size 2560 is not valid

SQL> !oerr ora 25157
25157, 00000, "Specified block size %s is not valid"

// *Cause: An attempt was made to create a tablespace with a block
//         size which is not supported.
// *Action: Specify one of the valid blocksizes i.e the standard


//          blocksize or one of (2k, 4k, 8k, 16k, 32k) subject

//          to the maximum and minimum blocksizes supported by

//          the platform.



Can you guys tell I'm sitting here, killing time, waiting for this day to be over, so I can start my 2 week Christmas holiday?? :)  After today, I'm off work till Jan. 4th..... just counting the minutes now.... :)

-Mark

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martin Berger Sent: Friday, December 17, 2010 12:29 PM To: Oracle-L Freelists
Subject: weekend-fun with 11.2.0.2

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)

have a nice weekend,
 Martin

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

Received on Fri Dec 17 2010 - 11:52:19 CST