Setting Up an Oracle Database (Windows)

The following notes apply to Oracle:

  • The Oracle clients have a configuration parameter that allows you to specify a rollback segment, specifically one that is much larger than the default rollback segment. Rollback segments are used to construct a SET TRANSACTION USE ROLLBACK SEGMENT SQL statement that is executed at the start of every transaction.
  • The Oracle clients support the CLOB data type for holding DMSII ALPHA items that are too large for the VARCHAR2 data type. The parameters in PL/SQL stored procedures for these clients limit the CLOB data type to 32K (Oracle 11g) and 16K (Oracle 10g2 and 9i). For backward compatibility, this feature is enabled via the use_clob parameter.
  • The Windows clients work with all recent Oracle databases including Oracle 9i, 10g, and 11g.
  • Starting in Oracle 11g Release 2, Oracle database passwords are case-sensitive.

The Oracle open_cursors Parameter

It is recommended that you add the open_cursors parameter to the initSID.ora file. Depending on the setting of the aux_stmts parameter, you may need to increase the value of open_cursors to make it slightly higher than the value of aux_stmts.

If open_cursors is not set high enough, an error occurs, indicating that the maximum number specified was exceeded. Refer to your Oracle documentation for information on setting these values.