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.
- 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';
- 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;
- The same command should be added to the
SPFILE
of the Oracle system in order for the changes to persist on the next reboot.