Versions Compared

Old Version 1

changes.mady.by.user Christina Loher

Saved on

compared with

New Version Current

changes.mady.by.user Harald Saller

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Scroll Documents: Update page title prefix

...

Note
titleOracle

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.

2. Use the UMS Administrator to set up a new Oracle RAC type data source for each server.