Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> NetWare ABENDS w/Oracle8
I thought I would share this with the group. So in the future if anyone else like me is looking for it....
Running NetWare 4.11 and Oracle 8.0.3. When executing a large stored procedure, NetWare abends with the reported error: stack overflow. It points to the Oracle80.exe process. The following parameter set to 180 in config.ora corrects the problem.
NW_STKSIZE This parameter specifies how many kilobytes (KB) of stack space to allocate for threads started by the ORACLE7.NLM. The value should not be set lower than the default because it would cause improper behavior. Increasing this value will cause Oracle to consume more memory on the server. This parameter is only read when ORACLE7.NLM is loaded. If this value is set or changed, Oracle should be shutdown. Then the ORACLE7.NLM should be unloaded and then reloaded. Operating System: NetWare Default: 83 (83KB of stack) for 7.0.12 99 (99KB of stack) for 7.0.16.6 Legal Values: 64 to 16384 (64KB to 16MB) Version Introduced: 7.0.12Received on Mon Nov 16 1998 - 00:00:00 CST