Skip to main content

Installing the Oracle Database Server

Follow the Oracle product documentation to install the Oracle DBMS and create a database instance. This manual states only the assumptions and requirements of the Oracle database server installation that allow it to work correctly with FlexNet Manager for Engineering Applications Admin and Reporting, and withFlexera Analytics.

Character Settings

FlexNet Manager for Engineering Applications Admin/Reporting/Flexera Analytics has been tested with a database with the following character settings:

  • Database character set: AL32UTF8
  • National character set: AL16UTF16

OPEN_CURSORS Value

The Oracle database initialization parameter value for OPEN_CURSORS should be set to at least 1000. Both of the tablespaces for FlexNet Manager for Engineering Applications (Admin and Reporting) may need, in total, up to 1,000 open cursors. If the Oracle database is being used by other applications, set this value accordingly.

PROCESSES Value

The Oracle database initialization parameter value for PROCESSES should be set to at least 1000.

Administrative User Credentials

Make note of the login name and password of an Oracle administrative user (for example, SYSTEM) because you will need to connect to Oracle as that user to create the database and corresponding database user for FlexNet Manager for Engineering Applications Admin and Reporting, and for FlexNet Report Designer.