• The first screen that comes after running the OpsHub Integration Manager installer is shown below.

  • After you click Next, the license agreement window appears. If you agree with the license terms and conditions, then proceed to Installation by clicking Next.

  • Select the installation directory.
    • All the log files, configuration files, and servers are placed in this directory. If the directory is not available, create a directory as per your specifications.
    • Once the directory is selected, click Next.

  • The next step is Registration. Each installation must be registered with OpsHub. Registration can be done either in Online or Offline mode.
    Please refer Registration page for more details.
  • Now, select the Installation type (database). Proceed by clicking Next.

Note:

  • Click the checkbox adjacent to Advance Configuration option only if you have to install OpsHub Integration Manager in https mode.
  • You can learn about https configuration in detail here, SSL Certificate Configuration.
  • You must configure Advance Configuration for OpsHub Integration Manager installation with Oracle 12c.
  • You have two Oracle versions that you can install: version 11g (Release 2) and 12c.
  • For either of the versions, there are certain pre-requisites that you need to fulfil. Look at the table below for details:
Pre-requisite for version 11g:Pre-requisite for version 12c:
  • Click this link: https://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html to get the requisite jar file.
  • For Oracle 12c version, download ojdbc7.jar or ojdbc6.jar.
  • The path of the executable jar files (such as ojdbc7.jar or ojdbc6.jar) is required while installing OpsHub Integration Manager with Oracle database.
  • Click this link: http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html
  • Once the ojdbc.jar file gets downloaded, rename the jdbc driver name from “ojdbc7” to “classes12”.
  • The path of the executable jar file that has been re-named as classes12.jar is required while installing OpsHub Integration Manager with Oracle Database Configuration.
  • This installation further asks for Oracle Server database credentials. You need to specify the database credentials (as shown in the image below) to connect to Oracle and give the path of the Connector Jar to allow OpsHub Integration Manager for database transactions.Click Next.

Note:

  • Database User Password can contain: Alphabets (a-z,A-Z, Numbers (0-9), Special characters from the list: !@#$^&*()_+|[];:’><,.?/`~-=.
  • Please check with your system administration if you don’t have the database credentials.
  • For Oracle CDB instance in this application, the default user name will be ‘C##opshub’ and ‘C##reportsdb’.
  • For Oracle Non CDB instance in this application, the default user name will be ‘opshub’ and ‘reportsdb’.
  • The path to download the Connector Jar is given in the application window shown below.

  • Depending on the installation you choose, you might have to specify the instance name. The steps for generating the instance name is given below:

Generate Oracle cluster instance:

  • To get the currently logged-in instance name for OpsHub Integration Manager installation when using Oracle cluster instance, please check the SQL given below.
  • Log in to the Oracle instance [Cluster] using SQL plus with username, password, and service name: sqlplus username/password@connect_identifier.
  • Run the SQL: SELECT sys_context(‘USERENV’,’DB_NAME’) AS Instance FROM dual; the output value is the instance name that will be used in installation process.

Select Oracle Database Type:

  • CDB or Container Database refers to the multitenant architecture in Oracle. CDB type was introduced with Oracle 12c version. Use the instructions given in the following screenshot to find out whether your Oracle version is CDB or not.
  • After selecting the relevant option, click Next.
 
Note:
All these operations must be allowed with ADMIN OPTION.
  • The installation begins.

  • Once the installation is finished, the following screen would come up. Click Next.

  • Shortcut will be added to the Windows program list if the operating system is Windows and  to the Linux program list if the operating system is Linux. It will also create OpsHub Integration Manager launcher. Click Next to set up shortcuts in the Operating System (OS) start menu. Then, click Next to complete the installation process.

  • Once installation completed successfully, click Done.