Re: 10gR2 PL/SQL-Bug ora-03113 with chr()

Ulrik Hoffmann wrote:
> Problem still exists. Is there a kernel parameter missing? Kernel
> Parameters are set with the orarun.rpm whis is provided by Suse/Novell.
> But your hint is important, I will perform a kernel/system update asap.
>
> Thanks for your advice
> Ulrik

Hi Ulrich,
this is not a kernel parameter problem.

I tested on a database of mine with your settings:

Oracle Release 10.2.0.1.0
SLES9 2.6.5-7.97-bigsmp i686 i686 i386 GNU/Linux

kernel.shm-use-hugepages = 0
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 3294967296
kernel.sem = 1250       32000   100     256

(set by orarun).

And I couldn't reproduce your problem.

However ORA-03113 is generic. It should leave you a dump. Check there.

By the way. My env:

oracle@:~> env|grep LANG
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
LANG=en_US.UTF-8
oracle@:~> locale
LANG=en_US.UTF-8

LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

I'd give a look at your locale configuration.

Regards

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe