Switching Database to Oracle

To use Oracle as Iotellect Server's database engine, follow the generic instructions from Switching To Another Database Engine article. Here is a list of notes specific to Oracle:

  • Download the proper version of Oracle JDBC Driver for JDK 7 and JDK 8 and store it on the machine running Iotellect Server. It was available at http://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html.
  • Put ojdbc.jar into the /jar subfolder of Iotellect Server installation folder.
  • Set Database Driver in Iotellect Server Global Configuration Setting to oracle.jdbc.OracleDriver. This is the java class name for the Oracle driver.
  • The Database URL setting for the Oracle database has the following format: jdbc:oracle:thin:@host[:port]:database, where host is the IP or hostname of the Oracle server (can be an empty string or localhost), port is port name on which Oracle server is running (omit this part of URL to use the default value), and database name is the name of database that contains Iotellect Server's data. You can use server for the database name. For example, if your Oracle server runs at 192.168.0.1 with its default port, use the following URL: jdbc:oracle:thin://192.168.0.1:server.
  • Set Database Dialect setting to Oracle 10g/11g.

    • Oracle Setup

    Iotellect requires several configuration changes to be made in Oracle configuration. These changes are normally applied via Oracle console.

    alter system set processes=<process_count> scope=spfile;

    alter system set sessions=<session_count> scope=spfile;

    alter system set transactions=<transaction_count> scope=spfile;

    Set process_count to a value higher than Maximum Connection Pool Size global Iotellect Server configuration setting, e.g. Maximum Connection Pool Size * 1.05.

    Set session_count to (1.1 * process_count) + 5.

    Set transaction_count to 1.1 * session_count.

    Maximum length of ID (table name or column name) in Oracle DB is 30 symbols.

    There is a "cluster" key word in Oracle, so please don't use it for class or column naming inside Iotellect Classes.

    CMDB plugin is not compatible with Oracle DB. Please delete it from Iotellectpluginscontext folder before server start.

    Was this page helpful?