Kbase 13149: Error 1446 with Oracle DataServer - Open cursor error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/11/2001 |
|
Error 1446 with Oracle DataServer - Open cursor error
Progress error 1446: Open cursor error. Increase open_cursors in
init.ora (1446)
This Oracle error occurs when there are an insufficient number of
Oracle cursors available. There is a parameter in the init.ora file
that tells Oracle how many cursors to allow. To correct the problem,
shut down the Oracle instance, edit the init.ora and specify
a larger number of cursors. Progress will typically use one Oracle
cursor for each Progress cursor, plus a few extra for each referenced
table. (If a session deletes a customer, we'll compile a cursor for
that. If they add an order-line, there's another cursor). Running in
compatible mode, there will be a cursor needed for each index that is
referenced. Cursors are relatively cheap (in terms of resources) so
there shouldn't be a problem increasing the number of available
cursors.
Please note the importance of shutting down Oracle and starting it
up again after the change to init.ora.
The open_cursor default for Oracle Dataserver on MS Windows is 50 and
on Unix is 250 i.e in init.ora file
open_cursors=250
Progress Software Technical Support Note # 13149