Page History
...
The following table lists the default ports for the monitored database instances.
| Instance | Port | Note |
|---|---|---|
| SQL Server | 1433 | 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:
|
| Oracle | 1521 | 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:
|
| Sybase | 5000 | 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:
|
| Db2 | 50000 | 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:
|
For more details on each instance installation, see Installing the Precise frameworkcheck the .precise installation guide.
How to enable ports on AWS server
The ports will need to be enabled in the AWS server. This is done by adding inbound rules
To add inbound rules, carry out the following steps:
Login to the AWS console and search for EC2 services in the search bar, check the attached screenshot.
From EC2 resources select Running Instances, check in below screenshot
Search for the instances which need their ports opened using the host name and select the machine.
Once the machine is selected, in the lower tab go to the ‘Description’ section and find the Security group then select security group name as highlighted in the screenshot below.
Select Inbound Rules from the ‘Security Groups’ details tab and edit the ‘Inbound rules’
Select ‘Add rule’ and fill the details in.
The parameters are:
Type info: type of port you want to open: database server, web servers, some custom port etc.
Ex: database
Port range info: range of port to open.
Ex: 1433 for SQL
Source info: Which machines can access this port.
The list of ports that need to be open is summarised in the table below:
| Technology | Open Port | Notes |
|---|---|---|