Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

sqlplus and SIGSEGV for stack growth failure

Raquel Candelaria
Occasional Visitor

sqlplus and SIGSEGV for stack growth failure

Hi,

I am the Unix systems administrator for the HP L 9000 systems I not oracle expert but the oracle guys said that this problem is a system problem, when the run sqlplus cdi/cdi;

SQL> desc production_metadata;
They receiced this error

Pid 1796 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or tack size exceeded maxsiz. Memory fault (coredump).

I modified the kernel parameters and I select General
OLTP Database Server system and installed all the patches
December 2000 and a couple for oracle and still having the same problem. I need some help. :o(
7 REPLIES
Rita C Workman
Honored Contributor

Re: sqlplus and SIGSEGV for stack growth failure

Well, it could be a problem with the kernel parm (maxdsiz I believe) needs increased..or it could be something else. Before I would make changes to the kernel, I would ensure my swap space is reasonable.

Then you might want to check this thread---could also be something about your links....
http://mail.gnu.org/pipermail/ddd/2001-March/000669.html

Hope this helps,
Rita
A. Clay Stephenson
Acclaimed Contributor

Re: sqlplus and SIGSEGV for stack growth failure

Hi:

I'm almost positive you need to increase maxssiz.

Regards, Clay
If it ain't broke, I can fix that.
MANOJ SRIVASTAVA
Honored Contributor

Re: sqlplus and SIGSEGV for stack growth failure

Hi Raquel

I have a suggestion , plesae check the all the following system kernel parameters :Parameter Required
==================================
SHMMAX 1gb
SHMMIN 1
SHMMNI 100
SHMSEG 10

SEMMNI 70
SEMMNS 200
MAX_THREAD_PROC >= 256

This along with the disk partitions ( long name ) , maxdsiz should be able able to sort out the OS related variables.


Manoj Srivastava

Raquel Candelaria
Occasional Visitor

Re: sqlplus and SIGSEGV for stack growth failure

Thank you for the answers but I am going to give more detail s. I have 3 databases running, each one use 261 MB real memory. The system has 2049.8 MB in RAM, Swap 4096MB, 1 processor 440MHz.
OS B.11.0.U, OS Kernel 64.
kernel parameters
max_thread_proc 256
maxdsiz 268435456
maxdsiz_64bit 1073741824
maxfiles 2048
maxfiles_lim 2048
maxssiz 8388608
maxssiz_64bit 16777216
maxswapchunks 4096
maxtsiz 67108864
maxtsiz_64bit 1073741824
maxuprc 597
maxusers 200
shmem 1
shmmax 1073741824
shmmni 512
shmseg
Raquel Candelaria
Occasional Visitor

Re: sqlplus and SIGSEGV for stack growth failure

Thank you for your answers but I am going to give more details.I changed but it didn't work. I have 3 databases running, each one use 261 MB real memory. The system has 2049.8 MB in RAM, Swap 4096MB, 1 processor 440MHz.
OS B.11.0.U, OS Kernel 64.
These are the kernel parameters
max_thread_proc 256
maxdsiz 268435456
maxdsiz_64bit 1073741824
maxfiles 2048
maxfiles_lim 2048
maxssiz 8388608
maxssiz_64bit 16777216
maxswapchunks 4096
maxtsiz 67108864
maxtsiz_64bit 1073741824
maxuprc 597
maxusers 200
shmem 1
shmmax 1073741824
shmmni 512
shmseg 32
Rita C Workman
Honored Contributor

Re: sqlplus and SIGSEGV for stack growth failure

I don't consider myself a tuning expert....that said...

I think think your maxdsize (max data segment size (bytes) is a bit high. Possibly you could chg to something more like 67108864.

Just a thought....you may want to double check or wait for others comments.

Regards,
Rita
Don Morris_1
Honored Contributor

Re: sqlplus and SIGSEGV for stack growth failure

As mentioned above -- have you tried increasing
maxssiz above the 8Mb default you list as the
current value?