SafeGuard LAN Crypt Administration: Oracle 11g: "Enable Closing Cursors" needed to avoid "Maximum open cursors exceeded

  • Article ID: 117288
  • Updated: 26 Nov 2015

A large directory structure has been created. (Oracle 11g) When trying to display the structure in SGLC Administration the following errors are shown:

ORA-00604: error occurred at recursive SQL level 1

ORA-01000: maximum open cursors exceeded

Known to apply to the following Sophos product(s) and version(s)
SafeGurad LAN Crypt Administration 

What To Do

Please try the first step if this does not help please try step 2

1 - Another possiblity is to increase the Oracle setting OPEN_CURSORS. This has to be done on the database server

2 - A workaround is available through the "Oracle ODBC Driver Configuration": Setting the option: "Enable Closing Cursors" will prevent the error messages.


If you need more information or guidance, then please contact technical support.

Rate this article

Very poor Excellent