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

From: Ulrik Hoffmann <ulrik.1und1news_at_hoffmann-kiel.de>
Date: Thu, 15 Dec 2005 08:19:31 +0100
Message-ID: <op.s1tdatsmdm852a@papa>

> It is a bug ... but probably not with Oracle ... more likely with the
> Unix SA or Oracle DBA: Is there a mirror handy?
>
> Likely one of you needs to read the Oracle installation docs with
> respect to kernel parameters. Set them properly. Reboot.

I have no problem in facing the mirror ;-)

vmcborcl:~ # /sbin/sysctl -a | grep shm

kernel.shm-use-hugepages = 0
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 3294967296

vmcborcl:~ # /sbin/sysctl -a | grep sem
kernel.sem = 1250       32000   100     256
vmcborcl:~ # /sbin/sysctl -a | grep ip_local_port_range
net.ipv4.ip_local_port_range = 1024     65000

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 Received on Thu Dec 15 2005 - 01:19:31 CST