Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10gR2 PL/SQL-Bug ora-03113 with chr()

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 15 Dec 2005 12:44:36 -0800
Message-ID: <1134679469.381629@jetspin.drizzle.com>


Ulrik Hoffmann wrote:
>

>> 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

Don't have the docs in front of me but it seems you are missing quite a few of the parms. I'm not seeing rmem or wmem params among others.

http://docs.oracle.com

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Dec 15 2005 - 14:44:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US