Update the Security List for the DB System

You can update the security list for the DB systems using the following steps.

Review the list of ports in Open Ports on the DB System and for every port you open in iptables, update the security list used for the DB system, or create a new security list.

Note

The port 1521 for the Oracle default listener is included in iptables, but should also be added to the security list.

Procedure

Perform the following steps to update the security list for the DB system.

  1. Open the navigation menu. Select Oracle Database, then select Oracle Base Database Service.
  2. Select your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the name of the DB system you want to update.
  4. Note down the DB system's Subnet name and click its Virtual cloud network.
  5. Locate the subnet in the list, and then click its security list under Security lists.
  6. Click Edit all rules and add an ingress rule with source type = CIDR, source CIDR=<source CIDR>, protocol=TCP, and port=<port number or port range>.

    The source CIDR should be the CIDR block that includes the ports you open for the client connection.

For more information about creating or updating a security list, see Security Lists.