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.