Document toolboxDocument toolbox

_Oracle: Known Issue

Owned by Renata Dulatova
Last updated: Jun 17, 2024 by Emese Pogany
1 min read

Oracle

For the proper operation of the UMS with Oracle databases, particularly for the upgrade process, the number of open_cursors for the database must be adjusted. open_cursors is a system setting.

  1. To get the actual value, log in to the database as SYSDBA and execute:
    SQL> select name, value from v$parameter where name = 'open_cursors';

  2. The recommended value for open_cursors is "3000". To set the value, issue the following command as SYSDBA:
    SQL> alter system set open_cursors = 3000 scope=both;

  3. The same command should be added to the SPFILE of the Oracle system in order for the changes to persist on the next reboot.