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

  • Article ID: 117288
  • Updated: 04 Apr 2016

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)
SafeGuard LAN Crypt Administration 

What To Do

Please try one of the following options:

  • Increase the Oracle setting OPEN_CURSORS. This has to be done on the database server.
  • In "Oracle ODBC Driver Configuration", turn on "Enable Closing Cursors" to prevent the error messages.

 

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

Rate this article

Very poor Excellent

Comments