Idera AI Documentation Assistant

Beginning with version 9.9 (June 2018), you can install the Precise framework on AWS and Azure as well as monitor VMs in those environments.

While the Precise installation process is relatively straight forward, installing in an AWS or Azure environment includes some unique requirements. 

You must make sure that the correct inbound rules are open in AWS or Azure.

Installing the Precise Framework

For information about installing the Precise Framework, see Precise framework installation.

Installing Precise for databases

For information about installing Precise for databases, see:

Precise Ports

In order to access Precise and the monitored VMs, you must open certain ports. These ports must be open for environments that are on-premise as well as those that are on Cloud based environments.

The following table shows the standard set of ports that must be open.

The ports in the following table are by default. You can change the port number during installation, if necessary.

Precise ComponentPortNote
Precise GUI20790, 20798Verify that these ports are open on the Precise GUI-installed machine and from all of the machines that are going to access the Precise GUI.
Precise Framework20702Verify that this port is open on the main precise installation machine and is accessible from all of the listener machines and all of the product Focal Point machines, such as Oracle FP, SQL Server FP etc. 
Precise Listener20702Verify that this port is open on each of the Precise listener machines and is accessible from the Precise framework machine and all of the product Focal Point machines, such as Oracle FP, SQL Server FP etc.

The following table lists the default ports for the monitored database instances.

InstancePortNote
SQL Server1433

SQL Server default port. Verify that this port is open on the SQL Server database server machine and is accessible from all of the following machines:

  • SQL Server instance collector machine
  • SQL Server Focal Point machine
  • Precise Framework machine
Oracle1521

Oracle server default listener port. Verify that this port is open on the Oracle database server machine and is accessible from all of the following machines:

  • Oracle instance collector machine (the same as the Oracle server machine)
  • Oracle Focal Point machine
  • Precise Framework machine
Sybase5000

Sybase server default port. Verify that this port is open on the Sybase database server machine and is accessible from all of the following machines:

  • Sybase instance collector machine
  • Sybase Focal Point machine
  • Precise Framework machine
Db250000

Db2 server default port. Verify that this port is open on the Db2 database server machine and is accessible from all of the following machines:

  • Db2 instance collector machine
  • Db2 Focal Point machine
  • Precise Framework machine

For more details on each instance installation, see Installing the Precise framework.

Enabling ports in an AWS server

You must enable the ports in the AWS server by adding inbound rules.

To add inbound rules

  1. Log in to the AWS console and search for EC2 services in the search bar.


  2. From EC2 resources, select Running Instances.


  3. Using the host name, search for any instance that needs its port opened, and then select the machine.


  4. In the Description section of the lower tab, select the Security group name as highlighted in the following image.


  5. In the Security Groups details tab, select Inbound Rules, and then edit the inbound rules.


  6. Click Add rule.


  7. Complete the details using the following parameters, and then click Save rules:
    1. Type of port you want to open, such as database server, web servers, some custom port, etc.
    2. Range of port you want to open, such as 1433 for SQL

    3. Source information includes which machines can access this port.
      The list of ports that must be open is summarised in the following table:

      TechnologyOpen PortNotes
      Precise Framework

      20790
      20798

      		Precise GUI port
      20702Precise port
      Precise PMDB Server (SQL Server)1433SQL Server listening port
      Precise PMDB Server (Oracle)1521Oracle listening port
      Oracle1521Oracle listening port
      20702Precise port
      SQL Server1433SQL Server listening port
      20702Precise port
      Sybase5000Sybase listening port
      20702Precise port
      Db250000Db2 listening port
      20702Precise port


Enabling ports on Azure

To enable ports on Azure

  1. Log in to the Azure portal, and then click Virtual machines in the Azure services search bar.


  2. In the results, select the name of the machine on which you want to open ports, and then click Networking on the left-side menu bar and Inbound port rules on the right-side menu bar.


  3. Click Add inbound port rule, and then complete the following parameters:
    1. Source. Machines from where access to this port should be allowed.

    2. Destination port. Port that you want to open on the virtual machine. 
      The list of ports that must be open is summarised in the following table:

      TechnologyOpen PortNotes
      Precise Framework

      20790
      20798

      		Precise GUI port
      20702Precise port
      Precise PMDB Server (SQL Server)1433SQL Server listening port
      Precise PMDB Server (Oracle)1521Oracle listening port
      Oracle1521Oracle listening port
      20702Precise port
      SQL Server1433SQL Server listening port
      20702Precise port
      Sybase5000Sybase listening port
      20702Precise port
      Db250000Db2 listening port
      20702Precise port


IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal