Additional System Requirements for Implementing an SQL Server Database
Additional System Requirements for Implementing an SQL Server Database
To implement an SQL Server database, you must provide an installed and configured database server which fulfills the following minimum requirements in order to install the One Identity Manager schema.
Table 5: Additional System Requirements for Implementing an SQL Server Database
Software |
|
Compatibility level for databases |
SQL Server 2016 (130) |
Default collation |
- Case insensitive
- Recommendation: SQL_Latin1_General_CP1_CI_AS

|
NOTE: The collation "SQL_Latin1_General_CP1_CI_AS" is expected on One Identity Manager schema installation and applied to the database as required. | |
Default language for database server users |
English |
Language for database users |
English |
Additional requirements |
Start the SQL Server Agent in the SQL Server Service Management Portal. You can log in on an SQL Server Agent as a domain user with Windows authentication or with a local system account. |
Related Topics
Additional System Requirements for Implementing an Oracle Database
Additional System Requirements for Implementing an Oracle Database
If you use an Oracle database, you must provide an installed and configured database server, which meets the following minimum requirements for installing the One Identity Manager schema.
|
NOTE: To ensure that One Identity Manager functions properly, a database server with standard installation configuration settings is expected. |
Table 6: Additional System Requirements for Implementing an Oracle Database
Software |
-
Oracle Client Tools
This version should correspond at least to the version of the database in use. Note recommendations from Oracle with respect to the Client Tools you want to implement.
In a 64-bit system the Oracle clients are required in 64-bit and 32-bit versions.
|
NOTE: The use of Oracle Client Tools is only supported by One Identity Manager under Windows operating systems. |
|
NOTE: If a direct connection is possible to the Oracle database by TCP/IP, the Oracle client is not necessary. The One Identity Manager connector integrated in Oracle sets up the database connection. |
|
NOTE: Use of Oracle Real Application Clusters and other Oracle database configurations, which either require
- input of several "ADDRESS" entries for one "net_service_name" in the client-side tnsnames.ora
or
- additional entries in the client-side sqlnet.ora
if access to the Oracle database is through the Oracle client. | |
Character set |
Unicode (AL32UTF8) and option "Oracle Text"
Parameter NLS_LENGHT_SEMANTICS with value "CHAR" |
Tablespace |
An initial tablespace must be set up. The tablespace must have a block size of at least 8 kBytes. |
|
NOTE: If systems are implemented which have several nodes (for examples, clusters), all the nodes must have the same patch level. |
Related Topics
Minimum System Requirements for Administrative Workstations
One Identity Manager administration and configuration tools are installed on an administrative workstation in order to edit and display data.
The following system prerequisites must be guaranteed for installing tools on an administrative workstation.
Table 7: Minimum System Requirements - Administrative Workstations
Processor |
4 physical cores 2.5 GHz+ |
Memory |
4 GB+ RAM |
Hard drive storage |
1 GB |
Operating system |
Windows operating system
Supports versions:
- Windows Vista with the current service pack
- Windows 7 (32-bit or non-Itanium 64-bit) with the current service pack
- Windows 8 (32-bit or 64-bit) with the current service pack
- Windows 8.1 (32-bit or 64-bit) with the current service pack
- Windows 10 (32-bit or 64-bit) with version 1511 or later
|
Additional software |
|
Supported browsers |
- Internet Explorer 11 or later
- Firefox (Release Channel)
- Chrome (Release Channel)
- Microsoft Edge (Release Channel)
|
Table 8: Additional System Requirements for Implementing an Oracle Database
Additional software |
Windows operating system
-
Oracle Client Tools
This version should correspond at least to the version of the database in use. Note recommendations from Oracle with respect to the Client Tools you want to implement.
In a 64-bit system the Oracle clients are required in 64-bit and 32-bit versions.
|
NOTE: The use of Oracle Client Tools is only supported by One Identity Manager under Windows operating systems. |
|
NOTE: If a direct connection is possible to the Oracle database by TCP/IP, the Oracle client is not necessary. The One Identity Manager connector integrated in Oracle sets up the database connection. |
|
NOTE: Use of Oracle Real Application Clusters and other Oracle database configurations, which either require
- input of several "ADDRESS" entries for one "net_service_name" in the client-side tnsnames.ora
or
- additional entries in the client-side sqlnet.ora
if access to the Oracle database is through the Oracle client. | |
Minimum System Requirements for the Service Server
The server service "One Identity Manager Service" ensures distribution in the network of data managed in the One Identity Manager database. The One Identity Manager Service performs data synchronization between the database and any connected target systems and executes actions at the database and file level.
The following system prerequisites must be fulfilled to install the One Identity Manager Service on a server.
Table 9: Minimum System Requirements - Services Server
Processor |
8 physical cores 2.5 GHz+ |
Memory |
16 GB RAM |
Hard drive storage |
40 GB |
operating system |
Windows operating system
Following versions are supported:
- Windows Server 2008 (non-Itanium based 64-bit) Service Pack 2 or later
- Windows Server 2008 R2 (non-Itanium based 64-bit) Service Pack 1 or later
- Windows Server 2012
- Windows Server 2012 R2
- Windows Server 2016
Linux operating system
- Linux operating system (64 bit), supported by the Mono project or Docker images provided by the Mono project.
|
Additional software |
Windows operating system
Linux operating system
|
Table 10: Additional System Requirements for Implementing an Oracle Database
Additional software |
Windows operating system
-
Oracle Client Tools
This version should correspond at least to the version of the database in use. Note recommendations from Oracle with respect to the Client Tools you want to implement.
In a 64-bit system the Oracle clients are required in 64-bit and 32-bit versions.
|
NOTE: The use of Oracle Client Tools is only supported by One Identity Manager under Windows operating systems. |
|
NOTE: If a direct connection is possible to the Oracle database by TCP/IP, the Oracle client is not necessary. The One Identity Manager connector integrated in Oracle sets up the database connection. |
|
NOTE: Use of Oracle Real Application Clusters and other Oracle database configurations, which either require
- input of several "ADDRESS" entries for one "net_service_name" in the client-side tnsnames.ora
or
- additional entries in the client-side sqlnet.ora
if access to the Oracle database is through the Oracle client. |
Linux operating system
- Direct TCP/IP access is required to use an Oracle database system. A connection to Oracle Real Application Clusters is not supported under Linux operating systems.
|
Related Topics