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 -> NetWare ABENDS w/Oracle8

NetWare ABENDS w/Oracle8

From: Steven H. Meller <smeller_at_nospam.com>
Date: 1998/11/16
Message-ID: <3650c11e.0@stnws02.atl.mediaone.net>#1/1

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.12
Received on Mon Nov 16 1998 - 00:00:00 CST

Original text of this message

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